Friendly SQL

Auto-detecting the headers and schema of CSV files
Directly querying CSV files and Parquet files
Loading from files using the syntax FROM 'my.csv', FROM 'my.csv.gz', FROM 'my.parquet', etc.
Filename expansion (globbing), e.g.: FROM 'my-data/part-*.parquet'

Functions and Expressions

Dot operator for function chaining: SELECT ('hello').upper()
String formatters: format() function with the fmt syntax and the printf() function
List comprehensions
List slicing
String slicing
STRUCT.* notation
Simple LIST and STRUCT creation

Join Types

Trailing Commas

DuckDB allows trailing commas, both when listing entities (e.g., column and table names) and when constructing LIST items. For example, the following query works:

SELECT
    42 AS x,
    ['a', 'b', 'c',] AS y,
    'hello world' AS z,
;

Clauses

Query Features

Literals and Identifiers

Data Types

Data Import

Functions and Expressions

Join Types

Trailing Commas

See Also

About this page

In this article