DuckDB 1.1.0 “Eatoni” released with new features, SQL changes, and many performance boosts

The DuckDB team has announced the release of DuckDB version 1.1.0, code-named “Eatoni” after the Eaton's pintail (Anas eatoni), a dabbling duck found only on two remote island groups in the southern Indian Ocean. This update introduces several breaking SQL changes, improved community extensions, and support for the histogram function and variables in SQL.

Significant performance enhancements include dynamic filter pushdown from joins, automatic CTE materialization, and parallel streaming queries. Additionally, two new spatial features have been added: GeoParquet, an extension format for encoding vector geometries and metadata in Parquet files, and R-Tree, which supports creating R-Tree spatial indexes.

DuckDB 1.1.0 also includes numerous other features and improvements, further solidifying its capabilities in data management and analysis.