[Help/Feature Request?] Use the "where" query to find all elements with a key value greater than/less than a certain value

[OlexG]

For instance, is something like this available/implemented? If not, are there any plans to do this?

await db.users.findMany({
  where: {
    createdAt: {
       lte: someDate,
    },
  },
})

On the side, the reason I want this is to "implement" pagination for myself. Are there any plans to get the actual pagination working?
Thanks! This library has been super super great otherwise.

[skoshx]

Hello, and good to hear that!

This is definitely something I'm planning on building, just haven't gotten around to doing it!

I want to keep the right balance between taking inspiration from the best parts of Prisma, while still keeping the codebase quite simple and extendable.

As such, which parts of the above implementation would you need for your pagination needs?

[OlexG]

If we were able to at least filter by "less than" or "more than", that would be enough for my usecase