# DuckDB v0.9.0 — Release & Upgrade Intelligence
- **Product:** DuckDB (https://duckdb.org)
- **Version:** v0.9.0
- **Released:** Sep 26, 2023
- **Impact Score:** 5/10
- **Breaking Changes:** Not verified
- **Canonical Analysis:** https://changelogs.us/duckdb/updates/v0.9.0/

## Executive Summary (TL;DR)
DuckDB v0.9.0. Source highlight: This preview release of DuckDB is named "Undulata" after the aptly named Yellow-billed duck native to Africa.

## New Features
- [Dev] Merge master into feature
- Add support for nested laterals
- Add list_intersect, list_has_any, and list_has_all
- Add wildcard to JSON Path
- Add conn.interrupt() to DuckDB python API
- Initial set of commits to add support for zOS (an IBM mainframe operating system)

## Improvements
- Issue #7187: AsOf Join Performance
- Issue #7809: Segment Tree Performance
- PhysicalPiecewiseMergeJoin improvement
- Issue #7809: Segment Tree Performance
- General ART improvements and memory pressure reduction
- [ODBC] Error Management Improvement

## Bug Fixes
- Fix lingering clang-tidy issues
- [Dev] Add optional build flag to disable assertions in debug mode
- fix swapped x/y regression parameters
- Attempt to fix CI on Windows 32 and Python on Windows
- Fix 7947
- test: patch test_7652 to skip on pyarrow<11