This seems straightforward, but if `large_table` doesn't have enough rows beyond the offset (e.g., fewer than 100 rows after row 1000), the query might not return an ...

GET /_sql?format=json { "query":"""SELECT * FROM process """, "fetch_size":"20" } With OFFSET {from} ROWS FETCH NEXT {size} ROWS ONLY we could paginate to backwards ...