For examples of larger queries, see here for all TPC-H queries in standard syntax and converted to pipe syntax:
https://github.com/google/zetasql/blob/master/zetasql/exampl...And several more examples with pipe syntax here:
https://github.com/google/zetasql/blob/master/zetasql/exampl...