Keyset pagination supprot

[l3r8yJ]

it would be nice to have keyset pagination here

[fabriciofx]

Hi @l3r8yJ!

If I undestood correctly, KeySet pagination applies when we have a sequenced column, like numbered id, right? The problem is I don't know it. In my examples (the phonebook) the id is a UUID and this don't apply keyset pagination, right? So, what do you recommend in this case?

[l3r8yJ]

@fabriciofx I'll send a pr later with the implementation. I've implemented this a few times in my work, maybe you'll like it

we don't need to know which field the customer will use for the order (there is also a time-based UUID, for that matter), we can create just a generic solution. Very often records in tables have columns like createdAt, updatedAt, etc.

[fabriciofx]

@l3r8yJ A PR will be welcome! Thanks!