SQL Converter
Rewrite quoting, escaping, row limits and function names between 16 dialects, with a list of what it refused to guess at.
SQL Server (T-SQL) query
PostgreSQL query
Check it on a real engine
Runs the converted query on a real PostgreSQL engine inside this tab.
Sample tables
Guessed from the queryCreated in memory for each run and thrown away afterwards. Paste your real CREATE TABLE and a few rows for an exact check.
- 1Starts a real PostgreSQL in this tab, downloaded from this site the first time only.
- 2Creates the sample tables on the left, in memory.
- 3Runs the converted query and shows what it returns, or the exact error.
- 4Throws the tables away. Nothing is sent anywhere.
What it changed
TOP 10LIMIT 101 place[name]"name"8 placesISNULL()COALESCE()1 placeLEN(x)LENGTH(RTRIM(x))1 placecurrent timestampCURRENT_TIMESTAMP1 place
What you still need to do
Anything left in this list was recognised and left as it was on purpose. A function renamed to one that takes its arguments in a different order produces SQL that runs and returns the wrong rows, which is worse than SQL that fails.
How to Use SQL Dialect Converter
How to translate SQL queries between 16 database engines without data leaks.
Choose From & To Dialects
Select your source database engine in the "From" dropdown and your destination database in the "To" dropdown.
Paste Your Query
Paste your original SQL query into the left panel. The tool begins converting immediately as you type.
Inspect Receipts & Copy
Review the rewritten query, check the list of changes made, and review any items flagged for human verification.
Frequently Asked Questions
Common questions about privacy, supported dialects, and how SQL Dialect Converter works under the hood.
What syntax differences does SQLParity translate automatically?
It translates identifier delimiters (brackets to quotes or backticks), row limit syntax (TOP n vs. LIMIT n), string escaping rules, date functions, null checks (ISNULL to COALESCE), and string length functions (LEN to LENGTH with RTRIM).
What does "What you still need to do" mean in the SQL Converter?
Instead of blindly guessing at complex stored procedures or proprietary engine functions and returning SQL that fails silently, SQLParity lists any non-portable constructs that require manual human review.
Can I check that the converted query actually runs?
Yes, when the target is PostgreSQL, SQLite or DuckDB. The converted query runs on that real database engine inside your browser tab, against sample tables guessed from the query that you can edit. When the source is one of the three as well, the original runs alongside it on the same data and the two results are compared row by row.
Are queries sent to an AI backend or third-party translation server?
No. The entire conversion logic runs locally inside your browser tab using deterministically tested parsers and tokenizers. No queries are uploaded or logged.
How many database pairs can I convert between?
All 16 supported dialects can be converted to any other dialect, providing 240 pairwise translation paths including SQL Server to Postgres, MySQL to Snowflake, and Oracle to BigQuery.
Browse SQL conversions by source database
Choose the database your query uses now, then the database you want to convert it to.
Convert from PostgreSQL
- PostgreSQL to MySQL
- PostgreSQL to SQLite
- PostgreSQL to SQL Server (T-SQL)
- PostgreSQL to Oracle
- PostgreSQL to MariaDB
- PostgreSQL to Snowflake
- PostgreSQL to Google BigQuery
- PostgreSQL to Amazon Redshift
- PostgreSQL to Amazon Athena / Trino
- PostgreSQL to Apache Spark SQL
- PostgreSQL to Apache Hive
- PostgreSQL to ClickHouse
- PostgreSQL to DuckDB
- PostgreSQL to IBM Db2
- PostgreSQL to Standard SQL
Convert from MySQL
- MySQL to PostgreSQL
- MySQL to SQLite
- MySQL to SQL Server (T-SQL)
- MySQL to Oracle
- MySQL to MariaDB
- MySQL to Snowflake
- MySQL to Google BigQuery
- MySQL to Amazon Redshift
- MySQL to Amazon Athena / Trino
- MySQL to Apache Spark SQL
- MySQL to Apache Hive
- MySQL to ClickHouse
- MySQL to DuckDB
- MySQL to IBM Db2
- MySQL to Standard SQL
Convert from SQLite
- SQLite to PostgreSQL
- SQLite to MySQL
- SQLite to SQL Server (T-SQL)
- SQLite to Oracle
- SQLite to MariaDB
- SQLite to Snowflake
- SQLite to Google BigQuery
- SQLite to Amazon Redshift
- SQLite to Amazon Athena / Trino
- SQLite to Apache Spark SQL
- SQLite to Apache Hive
- SQLite to ClickHouse
- SQLite to DuckDB
- SQLite to IBM Db2
- SQLite to Standard SQL
Convert from SQL Server (T-SQL)
- SQL Server (T-SQL) to PostgreSQL
- SQL Server (T-SQL) to MySQL
- SQL Server (T-SQL) to SQLite
- SQL Server (T-SQL) to Oracle
- SQL Server (T-SQL) to MariaDB
- SQL Server (T-SQL) to Snowflake
- SQL Server (T-SQL) to Google BigQuery
- SQL Server (T-SQL) to Amazon Redshift
- SQL Server (T-SQL) to Amazon Athena / Trino
- SQL Server (T-SQL) to Apache Spark SQL
- SQL Server (T-SQL) to Apache Hive
- SQL Server (T-SQL) to ClickHouse
- SQL Server (T-SQL) to DuckDB
- SQL Server (T-SQL) to IBM Db2
- SQL Server (T-SQL) to Standard SQL
Convert from Oracle
- Oracle to PostgreSQL
- Oracle to MySQL
- Oracle to SQLite
- Oracle to SQL Server (T-SQL)
- Oracle to MariaDB
- Oracle to Snowflake
- Oracle to Google BigQuery
- Oracle to Amazon Redshift
- Oracle to Amazon Athena / Trino
- Oracle to Apache Spark SQL
- Oracle to Apache Hive
- Oracle to ClickHouse
- Oracle to DuckDB
- Oracle to IBM Db2
- Oracle to Standard SQL
Convert from MariaDB
- MariaDB to PostgreSQL
- MariaDB to MySQL
- MariaDB to SQLite
- MariaDB to SQL Server (T-SQL)
- MariaDB to Oracle
- MariaDB to Snowflake
- MariaDB to Google BigQuery
- MariaDB to Amazon Redshift
- MariaDB to Amazon Athena / Trino
- MariaDB to Apache Spark SQL
- MariaDB to Apache Hive
- MariaDB to ClickHouse
- MariaDB to DuckDB
- MariaDB to IBM Db2
- MariaDB to Standard SQL
Convert from Snowflake
- Snowflake to PostgreSQL
- Snowflake to MySQL
- Snowflake to SQLite
- Snowflake to SQL Server (T-SQL)
- Snowflake to Oracle
- Snowflake to MariaDB
- Snowflake to Google BigQuery
- Snowflake to Amazon Redshift
- Snowflake to Amazon Athena / Trino
- Snowflake to Apache Spark SQL
- Snowflake to Apache Hive
- Snowflake to ClickHouse
- Snowflake to DuckDB
- Snowflake to IBM Db2
- Snowflake to Standard SQL
Convert from Google BigQuery
- Google BigQuery to PostgreSQL
- Google BigQuery to MySQL
- Google BigQuery to SQLite
- Google BigQuery to SQL Server (T-SQL)
- Google BigQuery to Oracle
- Google BigQuery to MariaDB
- Google BigQuery to Snowflake
- Google BigQuery to Amazon Redshift
- Google BigQuery to Amazon Athena / Trino
- Google BigQuery to Apache Spark SQL
- Google BigQuery to Apache Hive
- Google BigQuery to ClickHouse
- Google BigQuery to DuckDB
- Google BigQuery to IBM Db2
- Google BigQuery to Standard SQL
Convert from Amazon Redshift
- Amazon Redshift to PostgreSQL
- Amazon Redshift to MySQL
- Amazon Redshift to SQLite
- Amazon Redshift to SQL Server (T-SQL)
- Amazon Redshift to Oracle
- Amazon Redshift to MariaDB
- Amazon Redshift to Snowflake
- Amazon Redshift to Google BigQuery
- Amazon Redshift to Amazon Athena / Trino
- Amazon Redshift to Apache Spark SQL
- Amazon Redshift to Apache Hive
- Amazon Redshift to ClickHouse
- Amazon Redshift to DuckDB
- Amazon Redshift to IBM Db2
- Amazon Redshift to Standard SQL
Convert from Amazon Athena / Trino
- Amazon Athena / Trino to PostgreSQL
- Amazon Athena / Trino to MySQL
- Amazon Athena / Trino to SQLite
- Amazon Athena / Trino to SQL Server (T-SQL)
- Amazon Athena / Trino to Oracle
- Amazon Athena / Trino to MariaDB
- Amazon Athena / Trino to Snowflake
- Amazon Athena / Trino to Google BigQuery
- Amazon Athena / Trino to Amazon Redshift
- Amazon Athena / Trino to Apache Spark SQL
- Amazon Athena / Trino to Apache Hive
- Amazon Athena / Trino to ClickHouse
- Amazon Athena / Trino to DuckDB
- Amazon Athena / Trino to IBM Db2
- Amazon Athena / Trino to Standard SQL
Convert from Apache Spark SQL
- Apache Spark SQL to PostgreSQL
- Apache Spark SQL to MySQL
- Apache Spark SQL to SQLite
- Apache Spark SQL to SQL Server (T-SQL)
- Apache Spark SQL to Oracle
- Apache Spark SQL to MariaDB
- Apache Spark SQL to Snowflake
- Apache Spark SQL to Google BigQuery
- Apache Spark SQL to Amazon Redshift
- Apache Spark SQL to Amazon Athena / Trino
- Apache Spark SQL to Apache Hive
- Apache Spark SQL to ClickHouse
- Apache Spark SQL to DuckDB
- Apache Spark SQL to IBM Db2
- Apache Spark SQL to Standard SQL
Convert from Apache Hive
- Apache Hive to PostgreSQL
- Apache Hive to MySQL
- Apache Hive to SQLite
- Apache Hive to SQL Server (T-SQL)
- Apache Hive to Oracle
- Apache Hive to MariaDB
- Apache Hive to Snowflake
- Apache Hive to Google BigQuery
- Apache Hive to Amazon Redshift
- Apache Hive to Amazon Athena / Trino
- Apache Hive to Apache Spark SQL
- Apache Hive to ClickHouse
- Apache Hive to DuckDB
- Apache Hive to IBM Db2
- Apache Hive to Standard SQL
Convert from ClickHouse
- ClickHouse to PostgreSQL
- ClickHouse to MySQL
- ClickHouse to SQLite
- ClickHouse to SQL Server (T-SQL)
- ClickHouse to Oracle
- ClickHouse to MariaDB
- ClickHouse to Snowflake
- ClickHouse to Google BigQuery
- ClickHouse to Amazon Redshift
- ClickHouse to Amazon Athena / Trino
- ClickHouse to Apache Spark SQL
- ClickHouse to Apache Hive
- ClickHouse to DuckDB
- ClickHouse to IBM Db2
- ClickHouse to Standard SQL
Convert from DuckDB
- DuckDB to PostgreSQL
- DuckDB to MySQL
- DuckDB to SQLite
- DuckDB to SQL Server (T-SQL)
- DuckDB to Oracle
- DuckDB to MariaDB
- DuckDB to Snowflake
- DuckDB to Google BigQuery
- DuckDB to Amazon Redshift
- DuckDB to Amazon Athena / Trino
- DuckDB to Apache Spark SQL
- DuckDB to Apache Hive
- DuckDB to ClickHouse
- DuckDB to IBM Db2
- DuckDB to Standard SQL
Convert from IBM Db2
- IBM Db2 to PostgreSQL
- IBM Db2 to MySQL
- IBM Db2 to SQLite
- IBM Db2 to SQL Server (T-SQL)
- IBM Db2 to Oracle
- IBM Db2 to MariaDB
- IBM Db2 to Snowflake
- IBM Db2 to Google BigQuery
- IBM Db2 to Amazon Redshift
- IBM Db2 to Amazon Athena / Trino
- IBM Db2 to Apache Spark SQL
- IBM Db2 to Apache Hive
- IBM Db2 to ClickHouse
- IBM Db2 to DuckDB
- IBM Db2 to Standard SQL
Convert from Standard SQL
- Standard SQL to PostgreSQL
- Standard SQL to MySQL
- Standard SQL to SQLite
- Standard SQL to SQL Server (T-SQL)
- Standard SQL to Oracle
- Standard SQL to MariaDB
- Standard SQL to Snowflake
- Standard SQL to Google BigQuery
- Standard SQL to Amazon Redshift
- Standard SQL to Amazon Athena / Trino
- Standard SQL to Apache Spark SQL
- Standard SQL to Apache Hive
- Standard SQL to ClickHouse
- Standard SQL to DuckDB
- Standard SQL to IBM Db2