SQL converter
Rewrite quoting, escaping, row limits and function names between 16 dialects, with a list of what it refused to guess at.
IBM Db2 query
ClickHouse query
What it changed
current timestampnow()1 placeVARCHARString1 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.
Converting IBM Db2 to ClickHouse: Key Syntax Differences
Translating SQL queries between IBM Db2 and ClickHouse involves subtle dialect differences that standard text find-and-replace often misses. Everything below is processed entirely in your browser using SQLParity.
Identifier Quoting
IBM Db2: "name"
ClickHouse: `name`
String Literal Escaping
IBM Db2: Quotes are doubled (''), backslash is literal.
ClickHouse: Quotes are doubled (''), backslash is an escape character.
Null-Safe Equality
ClickHouse: (colA <> colB OR (colA IS NULL AND colB IS NOT NULL) OR (colA IS NOT NULL AND colB IS NULL))
Why In-Browser SQL Conversion Matters
Database migrations frequently involve proprietary business logic, sensitive table schemas, and production column names. When converting SQL between IBM Db2 and ClickHouse, SQLParity executes all parsing, tokenization, and code rewriting locally in your browser. Zero queries or schemas are transmitted to remote servers.