Getting error: Alias is already used in this query

[dovrosenberg]

I have the following code:

const query = db.select({
   columns
})
.from(organizations)
.where(
   eq(organizations._id, _id),
);

const result = await safeQuery(query.$dynamic(), organizations._firmId, uid);

safeQuery is designed to handle some munti-tenancy:

export const safeQuery = async function<T extends PgSelect>
    (query: T, firmField: AnyPgColumn, authenticationId: string) {

  return query
    .innerJoin(permissions, and(
      eq(firmField, permissions._firmId),
      eq(permissions.authenticationId, authenticationId), 
      eq(permissions.canRead, true)
    ));
}

It generates this SQL, which seems perfectly fine (and executes fine directly in postgres):

sql: 'select "organizations"."_firmId", "organizations"."_id", "organizations"."name" from "organizations" inner join "permissions" on ("organizations"."_firmId" = "permissions"."_firmId" and "permissions"."authenticationId" = $1 and "permissions"."canRead" = $2) where "organizations"."_id" = $3',

params: [ 'tsjh3HCe8tZzvW27VSHqGvHi5Ur1', true, 5 ]

But generates an error: Alias "permissions" is already used in this query"

Am I missing something? Did I confuse Drizzle?

Thanks for any ideas.

[dovrosenberg]

It gets even more strange... if instead of calling safeQuery() I move that logic into the main function:

const query = db.select({
   columns
})
.from(organizations)
.where(
   eq(organizations._id, _id),
);

const result = await query.$dynamic()
   .innerJoin(permissions, and(
   eq(organizations._firmId, permissions._firmId),
   eq(permissions.authenticationId, uid), 
   eq(permissions.canRead, true)
));

it works exactly as expected.