I think that something like a query for hundreds of millions of records that also required pagination for the exact number of records returned is anomalous and

I think that something like a query for hundreds of millions of records that also required pagination for the exact number of records returned is anomalous and not something that their application would do.