[プレビュー]Pipe構文が利用申請不要でBigQueryとCloud Loggingで使用できるようになりました

SELECT item, COUNT(*) AS num_items, SUM(sales) AS total_sales
FROM Produce
WHERE item != 'bananas' AND category IN ('fruit', 'nut')
GROUP BY item
ORDER BY item DESC;

FROM Produce
|> WHERE item != 'bananas' AND category IN ('fruit', 'nut')
|> AGGREGATE COUNT(*) AS num_items, SUM(sales) AS total_sales GROUP BY item
|> ORDER BY item DESC;

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)

WITH test_data AS (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
|> FROM test_data

WITH test_data AS(
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
FROM test_data
|> WHERE id > 1

WITH test_data AS(
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
SELECT * FROM test_data
|> WHERE id > 1

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
|> SELECT id

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
|> WHERE age >= 30;

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
) AS employees
|> JOIN (
  SELECT 1 AS id, 'Engineering' AS department UNION ALL
  SELECT 2, 'HR' UNION ALL
  SELECT 3, 'Marketing'
) AS departments
ON employees.id = departments.id
|> SELECT employees.id, employees.name, employees.age, departments.department;

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
|> EXTEND IF(age >= 30, 'Senior', 'Junior') AS age_category;

FROM (
  SELECT 1 AS id, 'Alice' AS name, 25 AS age UNION ALL
  SELECT 2, 'Bob', 30 UNION ALL
  SELECT 3, 'Charlie', 35
)
|> WINDOW RANK() OVER(ORDER BY age DESC) AS rank_age

Thanks for showing your interest and supporting pipe syntax since its initial launch in October last year. Seeing the large amount of interests, we are excited to share with you that we have made it publicly available starting TODAY, without a need to allowlist your projects.

What is pipe syntax? 
Pipe syntax, a groundbreaking innovation from Google, is now available in BigQuery and Cloud Logging. It supports the same underlying operators as standard SQL, and allows applying operators in any order, any number of times. It introduces an intuitive, top-down syntax that mirrors how you naturally approach data transformations and writing SQL queries.
Example: Suppose you want to know the average number of taxi trips per year in Chicago by payment_type. With pipe syntax, you no longer need to write subqueries, making the query more readable and concise. 
What pipe syntax can be used for?

Whether you're exploring data, building dashboards, or analyzing logs, pipe syntax empowers you to write clearer, more efficient SQL.
Log data analysis: Bring order to usually messy, semi-structured log data with ease using a familiar piped data flow language 
Ad-hoc analysis and query debugging: Iteratively build and debug your queries with a natural, top-down approach. At every step, you can check the intermediate results before adding new pipe operators.
Data engineering lifecycle: Say goodbye to those deeply nested queries and CTEs; pipe syntax reimagines how to parse, extract and transform data, making it easier to create and maintain data pipelines
Applying LLMs and natural language with SQL: It's easier for LLM to generate pipe syntax, and the generated queries can be much simpler and more human-readable.