Impact Score: 5/10
DuckDB: 0.2.2 Preview Release "Clypeata"
Source available — automated, not human-reviewed
Component: duckdb · Channel: stable. Automated analysis, not a compatibility certification. How this works.
Analysis updated: 2026-11-01.
⚡ Executive Summary (TL;DR)
DuckDB v0.2.2. Source highlight: This is a preview release of DuckDB.
Who Does This Impact? (Role-Based Analysis)
💻 Software Engineers & Devs
Check the source notes against the package and APIs you use before upgrading.
📊 Product & Engineering Leads
Use the documented changes to assess relevance to your product; release frequency alone is not a quality measure.
⚙️ DevOps & Security
Verify the target version, runtime requirements and rollback procedure in the official documentation.
✨ New Features & Capabilities (5)
- #1057: Add PRAGMA for enabling/disabling optimizer & extend output for query graph
- #936: Add GLOB support to Parquet & CSV readers
- #899: Table functions information_schema_schemata() and information_schema_tables() and #903: Add table function information_schema_columns()
- #884: Remove NFC-normalization requirement for all data and add COLLATE NFC
- #918: Add in support for Python datetime types in bindings
🔧 Bug Fixes & Patches (1)
- #984: Parallel grouped aggregations and #1045: Some performance fixes for aggregate hash table
📄 View Raw Release Notes (Original Developer Log)
This is a preview release of DuckDB.
Starting from this release, releases get named as well. Names are chosen from species of ducks (of course). We start with "Clypeata".
*Note*: This release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the `EXPORT DATABASE` command with the old version followed by `IMPORT DATABASE` with the new version to migrate your data. See the [documentation](https://duckdb.org/docs/sql/statements/export) for details.
Binary builds are listed below. Feedback is very welcome. Major changes:
SQL
- #1057: Add PRAGMA for enabling/disabling optimizer & extend output for query graph
- #1048: Allow CTEs in subqueries (including CTEs themselves) and #987: Allow CTEs in CREATE VIEW statements
- #1046: Prettify Explain/Query Profiler output
- #1037: Support FROM clauses in UPDATE statements
- #1006: STRING_SPLIT and STRING_SPLIT_REGEX SQL functions
- #1000: Implement MD5 function
- #936: Add GLOB support to Parquet & CSV readers
- #899: Table functions information_schema_schemata() and information_schema_tables() and #903: Add table function information_schema_columns()
Engine
- #984: Parallel grouped aggregations and #1045: Some performance fixes for aggregate hash table
- #1008: Index Join
- #991: Local Storage Rework: Per-morsel version info and flush intermediate chunks to the base tables
- #906: Parallel scanning of single Parquet files and #982: ZSTD Support in Parquet library
- #883: Unify Table Scans with Table Functions
- #873: TPC-H Extension
- #884: Remove NFC-normalization requirement for all data and add COLLATE NFC
Client
- #1001: Dynamic Syntax Highlighting in Shell
- #933: Upgrade shell.c to 3330000
- #918: Add in support for Python datetime types in bindings
- #950: Support dates and times output into arrow
- #893: Support for Arrow NULL columns