Filter on joined (with) tables
Is there any way to filter in a way like these using findFirst/findMany? (yes, screenshotting is not a good practice, sorry)
So basically I'm joining the "types" table (with: type). I only want to get entries where "types.slug" equals "test"
2 Replies
Drizzle ORM - DrizzleORM v0.28.0 release
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
1)Applying those filters manually on the code level after the rows are fetched;
2)Using the core API.