// AI Platform Drift

Basin SQL adds OFFSET clause for pagination

Cloudflare developer changelog · published 2026-10-22 04:48 UTC
WORTH KNOWING VERIFY_ONLY API
WHAT CHANGEDCloudflare Basin SQL now supports the OFFSET clause as of 21 October 2026. The clause skips a specified number of rows in query results, enabling pagination when combined with LIMIT and ORDER BY.
WHY IT MATTERSExisting Basin SQL queries that paginate results using workarounds (such as WHERE conditions on indexed columns or cursor-based approaches) can now use standard SQL OFFSET pagination. Applications that need to display large result sets in pages can implement simpler query logic.
WHAT TO DOReview Basin SQL queries that implement pagination. If they use workarounds instead of OFFSET, evaluate whether switching to LIMIT/OFFSET with ORDER BY on a unique column simplifies the code or improves maintainability.
Model-reported confidence 85% (not measured accuracy) Primary source ↗ written by anthropic/claude-sonnet-4.5
Show the reasoning — raw diff, triage verdict, confidence
RAW DIFF
+## Basin SQL, Basin - Basin SQL supports OFFSET
+https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/
+Wed, 21 Oct 2026 00:00:00 GMT
+
+Basin SQL is a serverless, distributed SQL engine for querying Apache Iceberg tables in Basin Catalog. It now supports OFFSET, which lets you skip a specified number of rows when retrieving query results.
+Use LIMIT to set the page size and OFFSET to skip earlier rows. With a page size of 100, use OFFSET 0 for the first page, OFFSET 100 for the second, and increase the offset by 100 for each later page. Add ORDER BY on a unique column to keep the row order consistent.
+For example, this query returns the second page of 100 rows:
+SELECT sale_id, total_amount
+FROM my_namespace.sales_data
+ORDER BY sale_id
+LIMIT 100 OFFSET 100
+For syntax and examples, refer to the OFFSET clause in the Basin SQL reference.
HOW IT WAS JUDGED
Triage signals below are model-reported assertions, preserved verbatim; they are not independent arithmetic verification.
triage verdictMATERIAL at 0.85, needed 0.5
triage reasoningBasin SQL now supports OFFSET for pagination, a functional API capability addition.
signalsnew feature addition to API · OFFSET clause support enables pagination · functional capability change to query language · example code provided for new feature
suppression—
triage modelanthropic/claude-haiku-4.5 ($0.00000)
writer modelanthropic/claude-sonnet-4.5 ($0.00000)