From here: Work with pipe query syntax | BigQuery | Google Cloud Documentation
HN: SQL pipe syntax available in public preview in BigQuery | Hacker News
Example usage:
-- Filter items with no sales.
FROM Produce
|> WHERE sales > 0;
-- Compute total sales by item.
FROM Produce
|> WHERE sales > 0
|> AGGREGATE SUM(sales) AS total_sales, COUNT(*) AS num_sales
GROUP BY item;
Thought it could be worth mentioning, as it shows how Elixir proceeds to influence other languages.
