How to paging with elasticsearch sql

The document offers "limit", but without "offset".

I'm using elasticsearch 7.10.1.

Yes that's true. And even in 8.14 which you should definitely upgrade to: SELECT | Elasticsearch Guide [8.14] | Elastic

I know that something along those lines will be implemented in ES|QL.

But I don't know if this will happen in the SQL feature.

Please upgrade to at least 7.17.23.
Your version is missing a lot of patches including security patches.

Thanks.