ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Teamโ€ข3y agoโ€ข
3 replies
midi

Drizzle relational query, filters

I'm trying to add some simple filters to my query, as according to https://orm.drizzle.team/docs/rqb#select-filters
I've tried both
where: eq(users.id, 1)
where: eq(users.id, 1)
syntax, and
where: (users, { eq }) => eq(users.id, 1),
where: (users, { eq }) => eq(users.id, 1),
- both result in
Type '{ where: SQL<unknown>; }' is not assignable to type 'true | { columns ?: ... 
Object literal may only specify known properties, and 'where' does not exist in type '{ columns ?: .....
Type '{ where: SQL<unknown>; }' is not assignable to type 'true | { columns ?: ... 
Object literal may only specify known properties, and 'where' does not exist in type '{ columns ?: .....


How do I add more filters to a relational query?
image.png
Drizzle Queries - DrizzleORM
Drizzle ORM | %s
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Getting Type Error With Drizzle Relational Query
Drizzle TeamDTDrizzle Team / help
2mo ago
Get Raw query string of a relational query in drizzle
Drizzle TeamDTDrizzle Team / help
3y ago
Nullable relational query?
Drizzle TeamDTDrizzle Team / help
3y ago
Relational query problem
Drizzle TeamDTDrizzle Team / help
3y ago