# DuckDB v2.0.0 — Release & Upgrade Intelligence
- **Product:** DuckDB (https://duckdb.org)
- **Version:** v2.0.0
- **Released:** Oct 21, 2026
- **Impact Score:** 7/10
- **Breaking Changes:** Source flagged
- **Canonical Analysis:** https://changelogs.us/duckdb/updates/v2.0.0/

## Executive Summary (TL;DR)
DuckDB v2.0.0. Source highlight: This release of DuckDB is named "Cyanoptera" after Spatula Cyanoptera, a species of duck found in western North and South America.

## Breaking Changes & Deprecations
- More missing includes breaking non-unity builds by @evertlammerts in https://github.com/duckdb/duckdb/pull/23837

## New Features
- Expand aggregate state export to work with lists (`StateListType`) and sort keys (`StateSortKey`), and add aggregate state export to `list`, `any_value/first/last`, `arg_min/arg_max`
- Add row group count to parquet RETURN_STATS
- Add `decimal_average` aggregate function
- Add `JSONBench` to the benchmark suite
- Add support for static linking C-API extensions
- Add `vertex_extract` function to get coordinates out of point-geometries

## Improvements
- Optimize single-key hash group partitioning performance
- Improve cache memory estimation on filepath cache object
- Improve connect integration
- Improve TPC-H dbgen progress reporting, ETA stability, and generation performance
- Improve TPC-DS dsdgen progress reporting and generation performance
- Improve pruning via string stats

## Bug Fixes
- Fix null sentinel for keys in dict vector (Arrow)
- fix out-of-bounds read in strict time parsing
- Dead node counting fixes
- Fix flaky `AsyncFileWriter` test
- [Variant] Fix crash for variant_extract on non-object shredded column
- Fix flaky `AsyncFileWriter` test