Drizzle TeamDT
Drizzle Team•2y ago
Zack

Is it possible to spread a relation object when using `with`?

I am using multiple table inheritance where I have a user table and two other separate tables for different user roles. When I do a query to find a user from the tables for the roles I would like to return the user tables columns spread on the object if that makes sense so if I do:

const userType1 = await db.query.userType1.findFirst({
      where: eq(userType1.id, id),
      with: {
        user: true,
      },
    });


Right now userType1 has the type:
{
id: string,
...other userType1 info
user: {...}
}


But I would like to have the user object spread inside the object instead. I can do this manually, but wanted to know if this was built in already or configurable.
Was this page helpful?