How to get data in chunks | need for pagination

Elastic Stack Elasticsearch
1

I am trying to implement pagination in my React Grid . In the base I am using SQL query to get data from ElasticSearch.

I need something like ,

SELECT* FROM bank ORDER BY account_number OFFSET 5 * (1 - 1) ROWS FETCH NEXT 50 ROWS ONLY

Which gives me next 50 or 100 records per hit/page. How can I achieve that. Please help me.

2

This sounds like a job for the scroll API.

3

but, do sql-cli provide such mechanism or I need to go for JSON query style as shown in scroll Api shared link.
I want to achieve the same as "scroll api" through sql query style if possible.

4

Sorry, I missed that you want to access this feature with SQL. I do not know that this is possible through the SQL API right now.