In a relation subquery, how to reference parent column?
I have this query:
Basically I want to query an author, with collections, and collections have books, books can have multiple authors. I want to query only other book authors where they are not the main author. The query doesn't error out but it includes the main author on every book. What am I missing?
3 Replies
U cant filter on relations
Drizzle ORM - DrizzleORM v0.28.0 release
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
I see, thank you!