Avoid caching full query result for queries with generic sort and LIM…

[markoszah]

Queries that do generic sort and also include LIMIT clause, do not need to store that full query result in client memory, as it is done today. The just need to store a max of OFFSET+LIMIT results.