Is there any way to paging query using plyql?

[Y H]

hi, i make some program using plyql ( https://plywood.imply.io/plyql )

and i can't find any docs to paging using plyql

pls let me know how to if there is way to do 

thanks! 

[Sergio Ferragut]

Have you tried OFFSET / LIMIT, here is the SQL documentation that describes it.

Essentially you can use 

SELECT .... OFFSET x LIMIT y
where x is the starting point of a page and y is the number of rows you want in return.

Note that the docs mentions a few of cautions, including:

- If the data changes between consecutive queries for different pages (i.e. new streaming data is ingested), the contents may not be consistently paged because the data that is being paged through has changed.

- Skipped rows still need to be generated internally and then discarded, meaning that raising offsets to high values can cause queries to use additional resources.