BigQuery to PostgreSQL SQL Converter

Translate BigQuery queries to PostgreSQL syntax with inline annotations. Free, 30 per hour.

FromTo

Hourly Limit: 0/30

Source SQL

SELECT user_id,
  ARRAY_AGG(STRUCT(product, qty) ORDER BY ts DESC LIMIT 5) AS recent
FROM orders
GROUP BY user_id;

Translated Result

Key Differences

•BigQuery features commonly rewritten: STRUCT / ARRAY literals, SAFE. prefix functions.
•PostgreSQL equivalents: JSONB operators, DISTINCT ON.
•Identifier quoting style differs — double quotes → double quotes.
•Date/time function names and casting semantics vary between BigQuery and PostgreSQL.