We're releasing DuckDB version 1.4.0, codenamed “Andium”. This is an LTS release with 1 year of community support, which packs new features such as database encryption, the MERGE statement and Iceberg writes.

DuckDB

DuckDB 1.4.0 'Andium' introduces Long Term Support with 1 year community maintenance, database encryption using AES-256, MERGE statement for upsert operations, Iceberg write support, CLI progress bar with ETA, FILL window function for interpolation, and performance improvements including sorting rework and materialized CTEs. The release also includes macOS notarization and moves Python integration to a separate repository.

Announcing DuckDB 1.4.0

<p>Impressive release! The addition of AES-256 encryption, MERGE support, and Iceberg write integration shows DuckDB’s steady evolution from an in-process analytics engine to a serious production-ready database. LTS support is a great step toward enterprise adoption.</p>
