ed
09/11/2020, 3:30 PMfindMany
equivalent. Imagine I want to select users in 10 buckets based on their id
.
Schema:
model User {
id Int @default(autoincrement()) @id
email String
...
}
Query: (Get me all users with an id ending in “1”)
SELECT id FROM public.user
WHERE
id % 10 = 1
ORDER BY id DESC
Does this require a queryRaw
or is possible with an IntFilter
or some other thing I can pass into findMany
?