See DuckDB's changelog for all changes in DuckDB.

What's Changed in DuckDB-Python

• Make rel->query work with a read only connection by @evertlammerts in #471
• Ignore Polars dynamic predicates by @evertlammerts in #482
• Accept pathlib.Path, os.PathLike, bytes, and file-like objects in read_parquet/from_parquet by @evertlammerts in #489
• Unify arrow exports across all query result types by @evertlammerts in #495

Contributors

• @evertlammerts

This is a patch release for the v1.4 LTS line. See DuckDB's changelog for all changes in DuckDB.

What's changed in DuckDB-Python

• Fix a memory leak on every Python scalar UDF call.
• Fix data corruption when reading from fsspec filesystems concurrently (seek+read/write are now atomic).
• Fix incorrect results from Arrow/PyArrow filter pushdown when an OR predicate contains a dynamic filter (e.g. ORDER BY ... NULLS FIRST LIMIT n), reported in issue #460.
• Raise a clear error instead of segfaulting when None is passed to Relation.join.

See the DuckDB core release notes here: https://github.com/duckdb/duckdb/releases/tag/v1.5.3

What's Changed in DuckDB Python

• Export all symbols by @evertlammerts in #445
• Fix concjunction OR by @evertlammerts in #465
• Use recursive mutex to deal with GIL <-> internal lock deadlocks by @evertlammerts in #462
• Allow self-joining of Polars lazyframes by @evertlammerts in #466

Full Changelog: v1.5.2...v1.5.3

Contributors

• @evertlammerts

See the DuckDB core release notes here: https://github.com/duckdb/duckdb/releases/tag/v1.5.2

What's Changed in duckdb-python

• Type hints overhaul by @OutSquareCapital in #352
• Cache arrow schema for streaming types by @evertlammerts in #423
• Fix segfault on join with None by @evertlammerts in #422
• Fix stubs for path_or_buffer param by @evertlammerts in #425

Contributors

• @evertlammerts
• @OutSquareCapital

DuckDB core v1.5.1 Changelog: duckdb/duckdb@v1.5.0...v1.5.1

What's Changed

• Re-added basic support for the GEOMETRY type

This is the 1.5.0 release of DuckDB's Python bindings. For a list of changes in DuckDB core, have a look at the DuckDB release notes and the blogpost.

Breaking Changes

• Dropped Python 3.9 support. The minimum supported version is now Python 3.10.
• Removed deprecated duckdb.typing and duckdb.functional modules. These were deprecated in 1.4.0. Use duckdb.sqltypes and duckdb.func instead.
• Renamed column parameter to expression in relational API functions (e.g., min, max, sum, mean, etc.) to better reflect that these accept expressions, not just column names.
• Deprecated fetch_arrow_table() and fetch_record_batch() on connections and relations. Use the new to_arrow_table() and to_arrow_reader() methods instead.

New Features

• Polars LazyFrame projection and filter pushdown. DuckDB can now push down projections and filters when scanning Polars LazyFrames, including support for cast nodes and unstrict casts.
• Polars Int128 / UInt128 support.
• VARIANT type support — Python conversion, NumPy array wrapping, and type stubs.
• TIME_NS type support — nanosecond-precision time values across Python, NumPy, and Spark type systems.
• Profiling API — new get_profiling_info() and get_profiling_json() methods on connections, plus a refactored query_graph module with improved HTML visualization (dark mode, expandable phases, depth).
• to_arrow_table() and to_arrow_reader() — new methods on connections and relations as the preferred Arrow export API.

Performance

• __arrow_c_stream__ on relations — relations now export via the Arrow PyCapsule interface using PhysicalArrowCollector for zero-copy streaming.
• Unified Arrow stream scanning via __arrow_c_stream__, with filter pushdown only when pyarrow is present.
• Arrow schema caching to avoid repeated lookups during scanning.
• Arrow object type caching to avoid repeated detection.
• Empty params treated as None for .sql() — avoids unnecessary parameter binding overhead.
• Simplified GIL management for FetchRow.

Bug Fixes

• Fixed Python object leak in scalar UDFs — PyObject_CallObject return values are now properly stolen to avoid reference count leaks.
• Fixed reference cycle between connections and relations that could prevent garbage collection.
• Relations now hold a reference to their connection, preventing premature connection closure.
• Fixed fsspec race condition in the Python filesystem implementation.
• Fixed numeric conversion logic — improved handling of large integers (fallback to VARCHAR) and UNION types.
• pyarrow.dataset import is now optional — no longer fails if pyarrow is installed without the dataset module.
• Thrown a reasonable error when an Arrow array stream has already been consumed.

Build & Packaging

• jemalloc enabled on Linux x86_64 only (aligned with DuckDB core), removed as a separately bundled extension.
• MSVC runtime linked statically on Windows — eliminates the VS2019 workaround from duckdb/duckdb#17991.

DuckDB core v1.4.4 Changelog: duckdb/duckdb@v1.4.3...v1.4.4

What's Changed in the Python Extension

• fix polars tests by @evertlammerts in #218
• tests for string and binary views by @evertlammerts in #221
• Quote view names in unregister by @evertlammerts in #222
• Limit string nodes in Polars expressions to constant expressions by @evertlammerts in #225
• Escape identifiers in relation aggregations by @evertlammerts in #272
• Fix DECREF bug during interpreter shutdown by @evertlammerts in #275
• Support for Pandas 3.0.0 by @evertlammerts in #277
• Prepare for v1.4.4 by @evertlammerts in #280

Full Changelog: v1.4.3...v1.4.4

Contributors

• @evertlammerts

What's Changed

• Fix project metadata by @evertlammerts in #174
• Add filename_pattern to to_parquet Python API by @matthewbayer in #201
• add windows arm64 build by @evertlammerts in #211
• fix adbc test imports by @evertlammerts in #215
• add file_size_bytes to to_parquet by @nicornk in #204
• [minor][spark] Minor bugfixes by @Dharin-shah in #180

New Contributors

• @matthewbayer made their first contribution in #201
• @nicornk made their first contribution in #204

Full Changelog: v1.4.2...v1.4.3

Contributors

• @evertlammerts
• @nicornk
• @Dharin-shah
• @matthewbayer

This is a bug fix release for various issues discovered after we released v1.4.1.

Also see the DuckDB v1.4.2 Changelog.

What's Changed

• Add Python 3.14 support by @evertlammerts in #116
• Fix ADBC driver path resolution when importlib.util was not implicitly loaded by @henryharbeck in #135
• add targeted test workflow by @evertlammerts in #145
• Remove xfail annotations on adbc tests by @evertlammerts in #147
• fix config dict value typehint by @evertlammerts in #151
• Add df data and tz type columns back into the same loc after type con... by @evertlammerts in #150
• Enable pyarrow with python 3.14 by @evertlammerts in #152
• spark imports by @evertlammerts in #157
• Fix failing test due to changed error msg by @evertlammerts in #158
• Add explicit .pl(lazy=True) overload by @J-Meyers in #172
• Fix InsertRelation on attached database by @evertlammerts in #155

Full Changelog: v1.4.1...v1.4.2

Contributors

• @evertlammerts
• @J-Meyers
• @henryharbeck