DuckDB Guides

DuckDB guides covering SQL differences from Postgres and MySQL, common error messages, and portable query patterns. Each guide states the DuckDB version it was tested with.

• Reference a SELECT Alias Inside CASE in the Same Query

  Why CASE WHEN revenue > 100 works in DuckDB but throws column "revenue" does not exist in Postgres — tested on DuckDB 1.0.0, with portable rewrites.

  Sep 15, 2026 · DuckDB 1.0.0

Related tool

• Parquet, CSV & JSON Viewer & Converter

  Open, query and convert Parquet, CSV and JSON files in your browser with a built-in DuckDB engine — no install, nothing uploaded.

← All guides