Querying relations

const users = pgTable()...
const groups = pgTable()...
const usersToGroups = pgTable()....references the respective columns

const usersRelations = relations()...users have many groups
const groupsRelations = relations()...groups have many users

const usersToGroupsRelations = relations()...one userId to one groupId in join table

const users = pgTable()...
const groups = pgTable()...
const usersToGroups = pgTable()....references the respective columns

const usersRelations = relations()...users have many groups
const groupsRelations = relations()...groups have many users

const usersToGroupsRelations = relations()...one userId to one groupId in join table

const filters: SQL[] = [];

query?.groupId ? filters.push(eq(groups.groupId, query.groupId)) : undefined;
query?.userId ? filters.push(eq(users.userId, query.userId)) : undefined;

const users = await db.query.users.findMany({
  columns: { 
    id: true,
    name: true,
  },
  with: {
    groups: {
      groupId: true,
      userId: true,
    }
    }
  },
  where: and(...filters),
)

const filters: SQL[] = [];

query?.groupId ? filters.push(eq(groups.groupId, query.groupId)) : undefined;
query?.userId ? filters.push(eq(users.userId, query.userId)) : undefined;

const users = await db.query.users.findMany({
  columns: { 
    id: true,
    name: true,
  },
  with: {
    groups: {
      groupId: true,
      userId: true,
    }
    }
  },
  where: and(...filters),
)

ERROR [ExceptionsHandler] column users.group_id does not exist
error: column users.group_id does not exist

ERROR [ExceptionsHandler] column users.group_id does not exist
error: column users.group_id does not exist