SQL Converter · PostgreSQL → Snowflake

Convert PostgreSQL SQL to Snowflake

PostgreSQL to Snowflake keeps "quotes", ::casts and ILIKE, but maps JSONB ->> access to VARIANT colon-paths and STRING_AGG to LISTAGG. A mechanical formatter only re-indents — it won’t rewrite dialect-specific syntax. The AI converter in the app translates the query and the table below shows exactly what changes.

PostgreSQL — source

PostgreSQL

SELECT o.id,
       o.data->>'plan' AS plan,
       STRING_AGG(t.tag, ',') AS tags
FROM orders o
JOIN tags t ON t.order_id = o.id
WHERE o.data->>'status' = 'paid'
GROUP BY o.id, plan;

Snowflake — converted

Snowflake

SELECT o.id,
       o.dataplanstring AS plan,
       LISTAGG(t.tag, ',') AS tags
FROM orders o
JOIN tags t ON t.order_id = o.id
WHERE o.datastatusstring = 'paid'
GROUP BY o.id, plan;

Convert your own query

What changes from PostgreSQL to Snowflake

PostgreSQL	Snowflake	Why
data->>'plan'	data:plan::string	JSONB text access becomes VARIANT colon-path plus a ::string cast.
STRING_AGG(x, ',')	LISTAGG(x, ',')	Snowflake string aggregation is LISTAGG.
ILIKE / ::cast	ILIKE / ::cast	Both are supported in Snowflake and carry over.

Other SQL conversions

PostgreSQL → MySQL PostgreSQL → T-SQL Oracle → Snowflake T-SQL → Snowflake MySQL → Snowflake PostgreSQL → Redshift PostgreSQL → BigQuery All conversions →