A CTE probably would have fixed it, but we weren't able to use them. We were using Citus which at the time didn't support CTEs. Using a CTE to do this would al

A CTE probably would have fixed it, but we weren't able to use them. We were using Citus which at the time didn't support CTEs. Using a CTE to do this would also be suboptimial since it materializes the entire result of the subquery in memory. This is as opposed to the OFFSET 0 which would only materialize one row at a time.