SQL plugin offset not working

Plugins SQL
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

Describe the issue:
Hi
I use opensearch and I have two indices transaction and users
when I creating inner join the offset not working but limit works

Configuration:

Relevant Logs or Screenshots:

2

Because of the nature of OpenSearch, support for JOINs and limits/pagination is still pending.

see: Limitations - OpenSearch documentation