Handling the upcoming LIMIT and OFFSET changes

You might be aware of the upcoming changes to LIMIT and OFFSET having a maximum value of 1000 in 23.12.

Obviously this is likely to cause a problem to any custom components that loop through data such as messages.

Cursor will work fine in some scenarios, but any kind of custom pagination will need UI/UX work to access records greater than 2000! 

Using cursor we'd only be able to move forward and not skip to page 1000 for example.

Any other thoughts on how this could be achieved with CURSOR?!