2 Replies
bump
Hello, @NightKunGz ヅ! You can find some useful information for this topic in docs:
https://orm.drizzle.team/docs/joins#aliases--selfjoins
Main idea is that you have
parentId which could be null and it referenced to primary key in this tableDrizzle ORM - Joins
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.