Data and AI releases

548 this month · 176 companies

BigQuery supports WHERE clauses inside aggregate function calls in preview

PreviewVerified

Aggregate function calls can now include a WHERE clause that filters their input with a boolean expression, simplifying conditional aggregation in SQL.

Developer tools

Read on docs.cloud.google.com

Also shipped Sep 14, 2026Google Cloud in September 2026 →

More from BigQueryEvery BigQuery release →