Implement pagination for Visibility API

Community Support
3

Also, I found that there was possible to have ORDER BY clause in the ListWorkflowExecutions (@tihomir Mentioned it here 2 years ago)
But now (1.24.2.1) adding ORDER BY and LIMIT clauses are not supported (source code)

correct, it was disabled by default as custom ordering by is pretty heavy operation. you can still enabled it via dynamic config

system.visibilityDisableOrderByClause
(set it to false)

but its recommended to use mentioned default sort order instead if possible