Back to Code Snippets

Octavian Zarzu

@octavian

Creating parameterized views with TVFs macros (Table-Valued functions)SQL

Octavian Zarzu

Copy code

Expand

Share link

Remove duplicatesSQL

Octavian Zarzu

Copy code

Expand

Share link

Filter column names using a patternSQL

Editor's note: DuckDB aims to make SQL even easier, while supporting standards whenever possible. When you have extremely wide tables, it's often helpful to return only columns matching a regex, and COLUMNS() does exactly that. With the EXCLUDE() and REPLACE() functions you get even more simplicity.

Octavian Zarzu

Expand

Share link

Query Parquet files and their metadataSQL

Octavian Zarzu

Copy code

Expand

Share link