Impact Score: 5/10
DuckDB: 0.2.6 Preview Release "Jamaicensis"
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.6. Source highlight: This preview release of DuckDB is named "Jamaicensis" after the blue-billed Ruddy Duck (Oxyura jamaicensis). 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 (6)
- #1540: Add table functions that take a subquery parameter
- #1647: Add support for UTC offset timestamp parsing to regular timestamp conversion
- #1659: Add support for `USING` keyword in `DELETE` statement
- #1610: Add support for `CURRVAL`
- #1544: Add `SKIP` as an option to `READ_CSV` and `COPY`
- #1525: Add loadable extensions support
📄 View Raw Release Notes (Original Developer Log)
This preview release of DuckDB is named "Jamaicensis" after the [blue-billed Ruddy Duck (Oxyura jamaicensis)](https://en.wikipedia.org/wiki/Ruddy_duck). 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.
Also note: Due to changes in the internal storage (#1530), databases created with this release wil require somewhat more disk space. This is transient as we are working hard to finalise the on-disk storage format.
Major changes:
Engine
- #1666: External merge sort, #1580: Parallel scan of ordered result and #1561: Rework physical ORDER BY
- #1520 & #1574: Window function computation parallelism
- #1540: Add table functions that take a subquery parameter
- #1533: Using vectors, instead of column chunks as lists
- #1530: Store null values separate from main data in a Validity Segment
SQL
- #1568: Positional Reference Operator `#1` etc.
- #1671: `QUANTILE` variants and #1685: Temporal quantiles
- #1695: New Timestamp Types `TIMESTAMP_NS`, `TIMESTAMP_MS` and `TIMESTAMP_NS`
- #1647: Add support for UTC offset timestamp parsing to regular timestamp conversion
- #1659: Add support for `USING` keyword in `DELETE` statement
- #1638, #1663, #1621 & #1484: Many changes arount `ARRAY` syntax
- #1610: Add support for `CURRVAL`
- #1544: Add `SKIP` as an option to `READ_CSV` and `COPY`
APIs
- #1525: Add loadable extensions support
- #1711: Parallel Arrow Scans
- #1569: Map-style UDFs for Python API
- #1534: Extensible Replacement Scans & Automatic Pandas Scans and #1487: Automatically use parquet or CSV scan when using a table name that ends in `.parquet` or `.csv`
- #1649: Add a QueryRelation object that can be used to convert a query directly into a relation object, #1665: Adding from_query to python api
- #1550: Shell: Add support for Ctrl + arrow keys to linenoise, and make Ctrl+C terminate the current query instead of the process
- #1514: Using `ALTREP` to speed up string column transfer to R
- #1502: R: implementation of Rstudio connection-contract tab