Hello :wave: I’ve got a query in SQL that I’m curi...
# prisma-client
e
Hello 👋 I’ve got a query in SQL that I’m curious is possible to write using a
findMany
equivalent. Imagine I want to select users in 10 buckets based on their
id
. Schema:
Copy code
model User {
  id  Int @default(autoincrement()) @id
  email String
  ...
}
Query: (Get me all users with an id ending in “1”)
Copy code
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
?