Comment by svat

> this pipeline syntax to be mixed with regular compositional forms like CTEs and subqueries?

Yes, it's an extension (available by default), which means you can freely mix with regular SQL and use pipes for just parts of your query.

https://github.com/google/zetasql/blob/2024.08.2/docs/pipe-s...

> Pipe syntax can be mixed with standard syntax in the same query. For example, subqueries can use different syntax from the parent query.