I wrote nexter (https://github.com/charly/nexter https://github.com/charly/nexter) a few years ago without knowing I was applying the keyset principle (it's not

I wrote nexter (https://github.com/charly/nexter https://github.com/charly/nexter) a few years ago without knowing I was applying the keyset principle (it's not pagination though but a next page library). It works well on a consistent data set but often falls short with Nulls, too many associations and whenever I aggregate stuff. Also it generates so many ANDs & ORs you do feel safer using Offset & Limit. I find it frustrating there's no easy solution provided by DBs for such a universal and simple need...