@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