4 replies

Alias join doesn't seem to work

I have a simple alias:

const parent = aliasedTable(contact, "parent")

let res = await db.select().from(policy).leftJoin(parent, eq(parent.id, policy.parent_id))

const parent = aliasedTable(contact, "parent")

let res = await db.select().from(policy).leftJoin(parent, eq(parent.id, policy.parent_id))

the query code works fine, but I cannot access the aliased name in the

res

res

. it is still inferring as

contact

contact

, but the docs show it inferring as

parent

parent

in the res.