[BUG]: Drizzle Relational Query not filtering well

[ManuLpz4]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.39.2

What version of drizzle-kit are you using?

0.30.2

Other packages

No response

Describe the Bug

I'm trying to query the teams in which a specific user is teamMember but drizzle is retrieving the whole table of teams.

Am I missing something? (I tried changing the name of the teams variable in the where function)

  const teams = await db.query.teams.findMany({
    where: (teams, { exists, eq, and }) =>
      exists(
        db
          .select()
          .from(teamMembers)
          .where(
            and(
              eq(teamMembers.teamId, teams.id),
              eq(teamMembers.userId, userId)
            )
          )
      ),
    with: {
      teamMembers: true
    }
  })