Resources
Friendly SQL
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 were first introduced by DuckDB, while some are inspired by other systems. Many of the features originally introduced by DuckDB (e.g., GROUP BY ALL) have been since adapted by other systems. Tip We have a Friendly SQL 2026 Calendar with a short…
ResourcesLibreDB Studio SQL Editorduckdb.org
ResourcesLambda Functionsduckdb.org
ResourcesLance Extensionduckdb.org
ResourcesVortex Extensionduckdb.org
ResourcesCSV Importduckdb.org
ResourcesJSON Overviewduckdb.org
ResourcesLance Extensionduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKnown Python Issuesduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesKeywords and Identifiersduckdb.org
ResourcesJupyter Notebooksduckdb.org