Error using relational queries but not with core queries

 const invitesData = await db.select().from(invites).innerJoin(members, eq(invites.inviterId, members.id)).where(eq(invites.invitedId, user.id));

 const invitesData = await db.select().from(invites).innerJoin(members, eq(invites.inviterId, members.id)).where(eq(invites.invitedId, user.id));

  const invitesData = await db.query.invites.findMany({
      with: {
        inviter: true
      },
      where: eq(invites.invitedId, user.id),
    })

  const invitesData = await db.query.invites.findMany({
      with: {
        inviter: true
      },
      where: eq(invites.invitedId, user.id),
    })

export const usersRelations = relations(users, ({many}) => ({
  members: many(members),
  invites: many(invites),
}))

export const invitesRelations = relations(invites, ({one}) => ({
  inviter: one(members, {
    fields: [invites.inviterId],
    references: [members.id],
  }),
  invited: one(users, {
    fields: [invites.invitedId],
    references: [users.id],
  })
}))

export const membersRelations = relations(members, ({many, one}) => ({
  invites: many(invites),
}))

export const usersRelations = relations(users, ({many}) => ({
  members: many(members),
  invites: many(invites),
}))

export const invitesRelations = relations(invites, ({one}) => ({
  inviter: one(members, {
    fields: [invites.inviterId],
    references: [members.id],
  }),
  invited: one(users, {
    fields: [invites.invitedId],
    references: [users.id],
  })
}))

export const membersRelations = relations(members, ({many, one}) => ({
  invites: many(invites),
}))