await db
.select({
id: users.id,
name: users.name,
groups: sql`json_agg(jsonb_build_object('id', ${groups.id}, 'name', ${groups.name}))`,
})
.from(users)
.leftJoin(usersToGroups, eq(users.id, usersToGroups.userId))
.leftJoin(groups, eq(groups.id, usersToGroups.groupId))
.groupBy(users.id, users.name, usersToGroups.userId)
.where(eq(users.id, newUser.id));
await db
.select({
id: users.id,
name: users.name,
groups: sql`json_agg(jsonb_build_object('id', ${groups.id}, 'name', ${groups.name}))`,
})
.from(users)
.leftJoin(usersToGroups, eq(users.id, usersToGroups.userId))
.leftJoin(groups, eq(groups.id, usersToGroups.groupId))
.groupBy(users.id, users.name, usersToGroups.userId)
.where(eq(users.id, newUser.id));