How I Built a DuckDB Query Transpiler for Multiple SQL Dialects

Hi everyone! I’ve been working with DuckDB for a long time, and just finished up an article about how I used it to build a query transpiler from DuckDB to other dialects. MotherDuck obviously doesn’t fall directly into this category because it already uses DuckDB’s dialect (Woo hoo), but for other dialects like Postgres, ClickHouse, it’s very relevant. Wrote about how I built it, here: www.cocoalemana.com/blog/building-a-duckdb-transpiler/