Announcing support for GROUP BY, SUM, and other aggregation queries in R2 SQL

What this post added

This post introduces significant enhancements to R2 SQL by adding support for aggregation queries (GROUP BY, SUM, COUNT, AVG, etc.). It details the implementation of scatter-gather and shuffling aggregation techniques to efficiently process these queries over large datasets stored in R2 Data Catalog. This enables users to perform complex analytical tasks like generating reports, identifying trends, and finding anomalies directly within R2, building upon existing filter query capabilities.