How do I join the media tables on the potential duplicate table? I want both of them to be present in the result. According to the docs (https://orm.drizzle.team/docs/joins#aliases--selfjoins) I can use aliased tables, but that does not seem to work. Here is my example:
const duplicate = aliasedTable(schema.media, "duplicate"); const original = aliasedTable(schema.media, "original"); const x = await db .select() .from(schema.potentialDuplicate) .innerJoin(original, eq(original.id, schema.potentialDuplicate.originalId)) .innerJoin(duplicate, eq(duplicate.id, schema.potentialDuplicate.duplicateId));
const duplicate = aliasedTable(schema.media, "duplicate"); const original = aliasedTable(schema.media, "original"); const x = await db .select() .from(schema.potentialDuplicate) .innerJoin(original, eq(original.id, schema.potentialDuplicate.originalId)) .innerJoin(duplicate, eq(duplicate.id, schema.potentialDuplicate.duplicateId));
If I try to auto complete on
x
x
I get the tables media and potential duplicate. It seems like both media tables got the name Media, which is wrong.