4 Ways DuckDB 1.2 makes SQL even friendlier
In this video, we explore four powerful new features in DuckDB 1.2 that enhance SQL usability. Using Jeff Sackmann's tennis dataset as a practical example, we demonstrate how these features simplify common SQL operations and make queries more intuitive. From improved table creation syntax to smarter column selection and aliasing, this guide shows you how to leverage DuckDB's latest improvements in your data workflows.
⏰ Timestamps
0:00 Introduction and Dataset Overview
0:37 Feature #1: Column Names in CREATE TABLE AS
Demonstrates new syntax for defining column names during table creation
Shows how to mix custom and source column names
2:19 Feature #2: SELECT * SIMILAR TO/LIKE
Introduction to new column selection patterns
Demonstrates SIMILAR TO, LIKE, NOT LIKE, and ILIKE syntax
Examples with regex and SQL wildcard patterns
3:06 Feature #3: SELECT * RENAME
Shows new RENAME clause functionality
Demonstrates how to rename columns while maintaining their position
3:36 Feature #4: Prefix Aliases
Introduces new prefix alias syntax
Shows how to use prefix aliases for both tables and columns
📗 Resources
🔸Blog with code - https://www.markhneedham.com/blog/202...
🔸Jeff Sackmann's tennis dataset - https://github.com/JeffSackmann/tenni...
🔸DuckDB 1.2 release blog post - https://duckdb.org/2025/02/05/announc...