@cubejs-client/core load / drilldown load method requires supports for pagination like `page`, `per_page`, to improve performance

Is your feature request related to a problem? Please describe. When using a drilldown load query, the number of records returned from db can be in the order or thousands or millions of records depending on the implementation and use-case. This can affect the performance of database server and can momentarily cause huge performance issues the database server.

Describe the solution you'd like drilldown query should ideally support page, per_page, other than limit .

Describe alternatives you've considered No alternatives found as of now

Additional context

1. records recieved in the order of thousands or millions can be pginated at front-end side, but the performance is affected very badly at the db side. This is a huge concern for the product team. Not able to go for deployment.
2. offset is not enough to build a pagination ui, it gives a very bad UX