Guides

Guides for the tools and databases covered on this site. Each guide shows tested code with the exact version it was run against, and notes portable alternatives where engines differ.

DuckDB

• DuckDB: 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

All DuckDB guides →