Better pagination than offset
Following [1], we should provide a better offset usage.
We could support to receive as offset a tuple of values which are the value corresponding to the "order by" clause after which to start.
The client should use this instead of increasing the offset by limit.
[1] http://use-the-index-luke.com/no-offset