I did some tests with retrieving all data from a SQL query that's paged.
Here's a demo:
Run the getAllUsers query
getAllUsers