Impact Score: 5/10
DuckDB: 0.2.5 Preview Release "Falcata"
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.5. Source highlight: This preview release of DuckDB is named "Falcata" after the Falcated Duck (Mareca falcata). Binary builds are listed below. Feedback is very welcome.
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 (1)
- #1408: Add blob support to C API
🔧 Bug Fixes & Patches (1)
- #1361: Aliases in the `HAVING` clause (fixes issue #1358)
📄 View Raw Release Notes (Original Developer Log)
This preview release of DuckDB is named "Falcata" after the Falcated Duck (Mareca falcata). Binary builds are listed below. Feedback is very welcome.
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 for details.
Major Changes:
Engine
- #1356: **Incremental Checkpointing**
- #1422: Optimize Top N Implementation
SQL
- #1406, #1372, #1387: Many, many new aggregate functions
- #1460: `QUANTILE` aggregate variant that takes a list of quantiles & #1346: Approximate Quantiles
- #1461: `JACCARD`, #1441 `LEVENSHTEIN` & `HAMMING` distance scalar function
- #1370: `FACTORIAL` scalar function and ! postfix operator
- #1363: `IS (NOT) DISTINCT FROM`
- #1385: `LIST_EXTRACT` to get a single element from a list
- #1361: Aliases in the `HAVING` clause (fixes issue #1358)
- #1355: Limit clause with non constant values
APIs:
- #1430 & #1424: **DuckDB WASM builds**
- #1419: Exporting the appender api to C
- #1408: Add blob support to C API
- #1432, #1459 & #1456: Progress Bar
- #1440: Detailed profiler.