Feature

You can now use the WITH pipe operator to define common table expressions in your pipe syntax queries. This feature is generally available (GA).

Feature

You can now use named windows in your pipe syntax queries. This feature is generally available (GA).

https://cloud.google.com/bigquery/docs/release-notes#July_17_2025