Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
INSTALL polyglot FROM community;
LOAD polyglot FROM community;
Using upstream DuckDB? Follow the maintainerβs installation instructions.
Usage example
Transpile a PostgreSQL query to DuckDB SQL
-- Transpile a PostgreSQL query to DuckDB SQL
D SELECT polyglot_transpile('SELECT NOW()', 'postgresql');
ββββββββββββββββββββββββββββββββββββββββββββββββββββ
β polyglot_transpile('SELECT NOW()', 'postgresql') β
β varchar β
ββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β SELECT CURRENT_TIMESTAMP β
ββββββββββββββββββββββββββββββββββββββββββββββββββββ
-- Transpile a Snowflake query to DuckDB SQL
D SELECT polyglot_transpile('SELECT DATEDIFF(''day'', ''2020-01-01'', ''2025-10-12'')', 'snowflake');
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β polyglot_transpile('SELECT DATEDIFF(''day'', ''2020-01-01'', ''2025-10-12'')', 'snowflake') β
β varchar β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β SELECT DATE_DIFF('DAY', CAST('2020-01-01' AS DATE), CAST('2025-10-12' AS DATE)) β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
-- Transpile between two non-DuckDB dialects
D SELECT polyglot_transpile('SELECT DATEDIFF(''day'', ''2020-01-01'', ''2025-10-12'')', 'snowflake', 'postgresql');
-- Validate SQL syntax
D SELECT polyglot_validate('SELECT 1', 'generic');
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β polyglot_validate('SELECT 1', 'generic') β
β struct(valid boolean, message varchar, line integer, ...) β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β {'valid': true, 'message': , 'line': 0, 'col': 0} β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
-- Parse SQL into an AST (JSON)
D SELECT polyglot_parse('SELECT 1', 'generic');
-- Optimize a SQL statement
D SELECT polyglot_optimize('SELECT a FROM t WHERE b = 1', 'generic');
-- List all supported SQL dialects
D SELECT * FROM polyglot_dialects() LIMIT 5;
ββββββββββββββββ
β dialect_name β
β varchar β
ββββββββββββββββ€
β generic β
β postgresql β
β mysql β
β bigquery β
β snowflake β
ββββββββββββββββ
-- Transpile and execute a query from another dialect
D SELECT * FROM polyglot_query('SELECT 1 AS a, 2 AS b', 'postgresql');
βββββββββ¬ββββββββ
β a β b β
β int32 β int32 β
βββββββββΌββββββββ€
β 1 β 2 β
βββββββββ΄ββββββββ
-- Trace column lineage through a SQL statement
D SELECT * FROM polyglot_lineage('SELECT a FROM t', 'generic', 'a');
βββββββββββββ¬βββββββββββββββ
β node_name β source_table β
β varchar β varchar β
βββββββββββββΌβββββββββββββββ€
β a β β
β t.a β β
βββββββββββββ΄βββββββββββββββ
-- Diff two SQL statements at the AST level
D SELECT * FROM polyglot_diff('SELECT a FROM t', 'SELECT b FROM t', 'generic');
βββββββββββββ¬βββββββββββββ
β edit_type β expression β
β varchar β varchar β
βββββββββββββΌβββββββββββββ€
β remove β a β
β insert β b β
βββββββββββββ΄βββββββββββββ
Provided by tobilg. Not yet verified on Haybarn 2.0.0.
Sample data & setupAbout this extension
The polyglot extension enables SQL transpilation from 34 different SQL dialects into DuckDB-compatible SQL, powered by the polyglot-sql crate. It can transpile, validate, parse, optimize, and execute SQL queries, as well as trace column lineage and diff SQL statements.
The extension supports 34 SQL dialects: athena, bigquery, clickhouse, cockroachdb, databricks, datafusion, doris, dremio, drill, druid, duckdb, dune, exasol, fabric, generic, hive, materialize, mysql, oracle, postgresql, presto, redshift, risingwave, singlestore, snowflake, solr, spark, sqlite, starrocks, tableau, teradata, tidb, trino, tsql.
Project overview from the community descriptor.
Documentation and resources
Project and build details
- Repository
- tobilg/duckdb-polyglot
- License
- MIT
- Maintainers
- tobilg
- Written in
- Rust
- Build source
c28271ebf05c- Build definition
- Community descriptor