System.OutOfMemoryException error when using Altru adHocQuery endpoint when using multiple fields in report.

Hello experts,

I recently encountered an issue while using the AdHocQuery endpoint with a report of constituents. It seems that when the report contains certain fields, the response size limit is reached, resulting in errors. Removing some fields solves the problem, but this is not a permanent solution as our database grows over time. I have tried to implement pagination to manage the response size limit, but I can't find any information on how to do this with the current endpoint. Can anyone provide guidance or assistance on implementing pagination for this endpoint?

Response error: System.OutOfMemoryException' was thrown.

I found this article but didn't see the real issue:

Is there way to paginate records in this endpoint?