**Is your feature request related to a problem?** * [The new engine fetches a default size of index from OpenSearch set by this setting, the default value is 200](https://github.com/opensearch-project/sql/blob/main/docs/user/admin/settings.rst#plugins-query-size-limit). It is a blocker for ML plugin to pull more data by using PPL. * [Cursor only support in V1 engine. ](https://github.com/opensearch-project/sql/blob/main/docs/user/interfaces/endpoint.rst#cursor). We should support it in V2 engine. **What solution would you like?** - [ ] add pagination support for operator which will unblock ML plugin use case. - [ ] add cursor support for V2 engine.