Resources

Friendly SQL

duckdb.org

DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features are also supported in other systems while some are (currently) exclusive to DuckDB. Clauses Creating tables and inserting data: CREATE OR REPLACE TABLE: avoid DROP TABLE IF EXISTS statements in scripts. CREATE TABLE ... AS SELECT (CTAS): create…

Visit Site

Resources duckdb.org