Gems of DuckDB 2.0.0
The DuckDB 2.0.0 Python client now includes an appender for efficient bulk data insertion. This allows users to collect rows and write them in a single operation.
23 releases · 0 this month
The DuckDB 2.0.0 Python client now includes an appender for efficient bulk data insertion. This allows users to collect rows and write them in a single operation.
DuckDB 2.0.0 is a new long-term support release focused on new features. It includes support until at least October 2027 and introduces various breaking changes.
DuckDB introduced Agent Mode in its CLI to optimize query output for LLMs and AI agents. By removing visual borders and column padding, Agent Mode reduces token consumption by around 60% during automated queries.
DuckDB version 1.5.6 is now available, featuring bug fixes, performance improvements, and security patches. The release addresses issues with Parquet handling, window functions, and integer literal processing.
dbt v2 now ships with a native DuckDB adapter built on its Rust Fusion engine, enabling users to execute local SQL model transformations against DuckDB out of the box.
DuckDB released `duckdb-skills`, a plugin for Claude Code that allows AI tools to query local files, web URLs, and Iceberg tables directly via the DuckDB CLI.
DuckDB announced a feature freeze and released preview builds for DuckDB v2.0-alpha Cyanoptera across command-line and Python clients.
The upcoming DuckDB v2.0 introduces physical execution changes to run recursive CTEs faster. By explicitly assigning scopes and reusing pipeline executors, the engine avoids repeatedly paying for pipeline scheduling and operator setup across iterations.
Version 1.5.3.0 of the DuckDB Java driver introduces an alternative to the row-by-row JDBC ResultSet API, allowing applications to retrieve query results in columnar chunks. This update avoids the overhead of slicing columnar data into rows and reassembling it.
DuckDB v2.0 will completely replace its SQL parser. The update aims to improve how the database tokenizes, parses, and transforms SQL queries into internal abstract syntax trees.
The upcoming DuckDB v2.0 release will add four new scalar functions to its JSON extension: json_merge_patch_diff, json_deep_merge, json_normalize, and json_strip_nulls. These functions allow data pipelines to reconcile state and handle JSON updates directly in SQL.
This release of DuckDB is named "Variegata" after the paradise shelduck Tadorna Variegata, also known as the paradise duck, a species of Shelduck (a group of goose-like ducks), endemic to New Zealand.
The in-process SQL OLAP database.
| Release-notes page | Site | Feed |
|---|---|---|
| Changelog r.duckdb.org | r.duckdb.org | None |