Hey @tdavies, following up on your other two questions:
1. Maximum rows: If you don’t specify a LIMIT in your query, it defaults to 1000 rows. You can set a different limit explicitly using the LIMIT keyword.
2. Pagination: This is supported through LIMIT combined with OFFSET.
For context, this works the same way as the LIMIT/OFFSET pattern in the Shopify Analytics query editor. The OFFSET parameter skips a specified number of rows before returning results.