R2 SQL - R2 SQL now supports window functions, DISTINCT, and set operations (opens in new tab)

R2 SQL now supports window functions, SELECT DISTINCT, set operations, and additional aggregates, making it easier to write analytical queries without preprocessing your data elsewhere. is Cloudflare's serverless, distributed SQL engine for querying Apache Iceberg tables stored in . New capabilities Window functions — ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTH_VALUE, and aggregates with an OVER (...) clause, including PARTITION BY and...