BigQuery supports WHERE clauses inside aggregate function calls in preview
PreviewVerifiedAdded Sep 22, 2026
Aggregate function calls can now include a WHERE clause that filters their input with a boolean expression, simplifying conditional aggregation in SQL.
Topics: Developer tools
Summaries of vendors' own notes. Product names and logos belong to their owners; logos via logo.dev.
More BigQuery releases
Every BigQuery release| Date | Release | Type |
|---|---|---|
| Sep 14 | An updated version of the Simba ODBC driver for BigQuery is now available Update | Update |
| Sep 14 | Metadata for BigQuery Graph is automatically ingested and searchable in Knowledge Catalog Preview | Preview |
| Sep 16 | BigQuery migration lineage service enters preview Preview | Preview |
| Sep 17 | You can add unit tests to pipelines to validate your SQL transformation logic against mock datasets GA | GA |
| Sep 10 | BigQuery conversational analytics adds ML.CORRELATION in preview Preview | Preview |
| Sep 10 | BigQuery ML.METRICS evaluates predictions without a stored model Preview | Preview |
| Sep 10 | You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data Preview | Preview |
| Sep 10 | BigQuery Data Engineering Agent integrates with BigQuery Graph GA | GA |
