The Pipe Syntax is currently supported in GoogleSQL, an SQL dialect used across several of Google's SQL products, both publicly and internally, including BigQuery, Spanner, F1, Bigtable, Dremel ...

GSC’s performance tab shows one dimension at a time, limiting context. BigQuery allows you to combine multiple dimensions for better insights Using SQL queries means you get a neat table.