DuckDB 0.9.0 release notes

This preview release of DuckDB is named "Undulata" after the aptly named Yellow-billed duck native to Africa.

Note: Again, this release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

What's Changed

[Dev] Merge master into feature by @Tishj in https://github.com/duckdb/duckdb/pull/7535
Issue #7563: make_timestamptz by @hawkfish in https://github.com/duckdb/duckdb/pull/7597
Add support for nested laterals by @arhamchopra in https://github.com/duckdb/duckdb/pull/7528
Issue #7563: epoch_us(temporal) by @hawkfish in https://github.com/duckdb/duckdb/pull/7629
Fix lingering clang-tidy issues by @Mytherin in https://github.com/duckdb/duckdb/pull/7670
Add list_intersect, list_has_any, and list_has_all by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7518
Issue #7563: epoch_xs(temporal) by @hawkfish in https://github.com/duckdb/duckdb/pull/7648
Pivot - dynamically switch between using filtered aggregates or the new pivot operator by @Mytherin in https://github.com/duckdb/duckdb/pull/7688
Add wildcard to JSON Path by @lnkuiper in https://github.com/duckdb/duckdb/pull/7624
[Dev] Add optional build flag to disable assertions in debug mode by @Tishj in https://github.com/duckdb/duckdb/pull/7618
[DEV]: ICU C Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/7715
List_resize by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7401
Issue #7187: AsOf Join Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7607
Some minor CI changes by @samansmink in https://github.com/duckdb/duckdb/pull/7763
Binder coverage by @hawkfish in https://github.com/duckdb/duckdb/pull/7791
Vacuum Completely Deleted Row Groups by @Mytherin in https://github.com/duckdb/duckdb/pull/7794
Issue #7187: AsOf Coverage by @hawkfish in https://github.com/duckdb/duckdb/pull/7774
Implement FIELD_IDS for parquet writes by @lnkuiper in https://github.com/duckdb/duckdb/pull/7696
Optimize Regexp_matches to LIKE statements when possible by @Tmonster in https://github.com/duckdb/duckdb/pull/7264
Jemalloc configuration, more buffer allocator, and remove redundant string copying in parquet dictionary by @lnkuiper in https://github.com/duckdb/duckdb/pull/7697
Truncate Database File on Checkpoint by @Mytherin in https://github.com/duckdb/duckdb/pull/7824
LEFT JOIN ON TRUE support by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7821
Issue #7809: Segment Tree Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7831
C Data Interface: duckdb_arrow_scan and duckdb_arrow_array_scan by @angadn in https://github.com/duckdb/duckdb/pull/7570
Update Julia to 0.8.1 by @Mytherin in https://github.com/duckdb/duckdb/pull/7932
Add conn.interrupt() to DuckDB python API by @henrinikku in https://github.com/duckdb/duckdb/pull/7895
renaming part of extension build refactor PR by @samansmink in https://github.com/duckdb/duckdb/pull/7926
fix swapped x/y regression parameters by @MartinNowak in https://github.com/duckdb/duckdb/pull/7855
[Docs] Aggregate function README.md by @hawkfish in https://github.com/duckdb/duckdb/pull/7881
PhysicalPiecewiseMergeJoin improvement by @xuke-hat in https://github.com/duckdb/duckdb/pull/7832
Initial set of commits to add support for zOS (an IBM mainframe operating system) by @v1gnesh in https://github.com/duckdb/duckdb/pull/7805
test(nodejs): add test_all_types.test.ts by @Mause in https://github.com/duckdb/duckdb/pull/7740
Issue #7879: Missing JDBC TIMESTAMP_TZ by @hawkfish in https://github.com/duckdb/duckdb/pull/7922
Attempt to fix CI on Windows 32 and Python on Windows by @carlopi in https://github.com/duckdb/duckdb/pull/7961
Fix 7947 by @lnkuiper in https://github.com/duckdb/duckdb/pull/7963
test: patch test_7652 to skip on pyarrow<11 by @gforsyth in https://github.com/duckdb/duckdb/pull/7966
NodeJS: Add columns() method to get type info from prepared statement by @Maxxen in https://github.com/duckdb/duckdb/pull/7948
Fix: Don't free arrow children explicitly by @Maxxen in https://github.com/duckdb/duckdb/pull/7917
CSV Rejects table by @Maxxen in https://github.com/duckdb/duckdb/pull/7681
Issue #7809: Segment Tree Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7891
Add tpch benchmark run exclusively on parquet files by @Tmonster in https://github.com/duckdb/duckdb/pull/7519
Bidirectional check storage + minor CI fixes by @carlopi in https://github.com/duckdb/duckdb/pull/7955
[Swift] fix #7985 by @tcldr in https://github.com/duckdb/duckdb/pull/7993
Move @samansmink's extension_header_rename.patch by @carlopi in https://github.com/duckdb/duckdb/pull/8001
[Python] Properly use NumPy array stride when scanning object arrays. by @Tishj in https://github.com/duckdb/duckdb/pull/7964
CI - No longer run on PR synchronize, instead run on ready_for_review by @Mytherin in https://github.com/duckdb/duckdb/pull/8007
Parallel pipeline execution should call NextBatch on first batch by @bleskes in https://github.com/duckdb/duckdb/pull/7978
Micro-optimization for generating collation keys by @Krechals in https://github.com/duckdb/duckdb/pull/7983
Multiple assignment for UPDATE SET by @nickgerrets in https://github.com/duckdb/duckdb/pull/7968
CI job to move synchronized PRs to draft by @carlopi in https://github.com/duckdb/duckdb/pull/8010
[ADBC] ConnectionGetTableSchema and StatementSetSubstraitPlan Functions by @pdet in https://github.com/duckdb/duckdb/pull/7914
Issue #7852: Window Vectorisation by @hawkfish in https://github.com/duckdb/duckdb/pull/7996
Moving JDBC Linux x64 builds to CentOS 7 by @hannes in https://github.com/duckdb/duckdb/pull/7991
CI Draft - token is called GH_TOKEN by @Mytherin in https://github.com/duckdb/duckdb/pull/8016
Add support for materialized CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/7126
Reduce memory usage of Parquet writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/7995
CI auto draft: pass token via environment + avoid wrapping action by @carlopi in https://github.com/duckdb/duckdb/pull/8024
CI autodraft: use implicit variable [test] by @carlopi in https://github.com/duckdb/duckdb/pull/8027
remove duplicate pivots declare by @douenergy in https://github.com/duckdb/duckdb/pull/7992
Fix typo in fts indexing exception by @alexanderchiu in https://github.com/duckdb/duckdb/pull/8034
Fix issue 7988 by @samansmink in https://github.com/duckdb/duckdb/pull/8023
Delete DraftMe.yml by @Mytherin in https://github.com/duckdb/duckdb/pull/8048
Fix 3eb9ab34db1: Remove unneeded move by @carlopi in https://github.com/duckdb/duckdb/pull/8038
[CI] Skip many more CI jobs for pull requests, and add make coverage-check to run coverage locally by @Mytherin in https://github.com/duckdb/duckdb/pull/8046
Extension build configuration refactor by @samansmink in https://github.com/duckdb/duckdb/pull/7735
Compressed Materialization by @lnkuiper in https://github.com/duckdb/duckdb/pull/7644
[Relation] Add support for creating an empty ValueRelation by @Tishj in https://github.com/duckdb/duckdb/pull/7967
Join Order Optimizer has duplicate enumerations and lost some neighbors by @lokax in https://github.com/duckdb/duckdb/pull/7358
Fix CI wasm by @carlopi in https://github.com/duckdb/duckdb/pull/8057
[CI] More CI reduction and clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/8052
Restore auto-draft functionality by @carlopi in https://github.com/duckdb/duckdb/pull/8058
Move WebAssembly.yml to NightlyTests.yml by @carlopi in https://github.com/duckdb/duckdb/pull/8060
Unskip, attach HTTPFS test, and create HTTPState when the opener is not available by @pdet in https://github.com/duckdb/duckdb/pull/8012
CI fixes: Don't persist ccache for nightlies by @carlopi in https://github.com/duckdb/duckdb/pull/8075
Fix regression & fix draft mechanism by @carlopi in https://github.com/duckdb/duckdb/pull/8071
CI compliance feature branch by @carlopi in https://github.com/duckdb/duckdb/pull/8070
Fix python flaky test (potentially GET requests gets back 403) by @carlopi in https://github.com/duckdb/duckdb/pull/8074
[Arrow] Fix segfault in appending list data by @Tishj in https://github.com/duckdb/duckdb/pull/8042
Issue #7852: Window Vectorisation by @hawkfish in https://github.com/duckdb/duckdb/pull/8050
CONTRIBUTING.md by @carlopi in https://github.com/duckdb/duckdb/pull/8077
Add ORDER BY clause to query in test_bool.test by @Flogex in https://github.com/duckdb/duckdb/pull/8082
ART test and benchmark refactor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8055
Update plan cost runner script to remove 20% threshold for cardinality estimates by @Tmonster in https://github.com/duckdb/duckdb/pull/7989
Fix #8067 by @lnkuiper in https://github.com/duckdb/duckdb/pull/8090
ART prefix refactor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7930
Bump Substrait by @pdet in https://github.com/duckdb/duckdb/pull/8110
Merge feature into master by @Mytherin in https://github.com/duckdb/duckdb/pull/8136
Increase memory limit in test to prevent non-deterministic CI failures by @lnkuiper in https://github.com/duckdb/duckdb/pull/8138
UNNEST binder fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8111
Out-of-Core Hash Aggregate by @lnkuiper in https://github.com/duckdb/duckdb/pull/7931
Add Unittests for ODBC by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7875
Hive types by @lverdoes in https://github.com/duckdb/duckdb/pull/7674
CppCheck & CodeQL on master by @carlopi in https://github.com/duckdb/duckdb/pull/8113
Fix CI for Nodejs and OSX by @carlopi in https://github.com/duckdb/duckdb/pull/8148
Skip failing test on R on CI by @carlopi in https://github.com/duckdb/duckdb/pull/8161
Disable failing R tests for now, and disable test_arrow_progress on Windows by @Mytherin in https://github.com/duckdb/duckdb/pull/8155
Allow disabling of extension loading (through a CMake flag) and allow selectively disabling specific file systems by @Mytherin in https://github.com/duckdb/duckdb/pull/8152
Fix FTS + ATTACH by @lnkuiper in https://github.com/duckdb/duckdb/pull/8153
fix: cli parser issue by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/8107
integrate with julia tables by @aplavin in https://github.com/duckdb/duckdb/pull/7984
Add JoinReftype to Relational Joins (to add asof, positional, dependent joins) by @Tmonster in https://github.com/duckdb/duckdb/pull/7987
Adjust the logic for adding type dependencies to temp tables by @jwills in https://github.com/duckdb/duckdb/pull/8073
Add File filters to Logical Get / Physical Table Scan. by @Tmonster in https://github.com/duckdb/duckdb/pull/7986
Issue #8119: TO_TIMESTAMP Returns TIMESTAMP by @hawkfish in https://github.com/duckdb/duckdb/pull/8127
[Python] Start of DuckDB Spark API by @Tishj in https://github.com/duckdb/duckdb/pull/8083
Create NamingConvention.md, with @samansmink by @carlopi in https://github.com/duckdb/duckdb/pull/8166
Casts from and to BIT type by @nickgerrets in https://github.com/duckdb/duckdb/pull/7941
[Python] Add Value class to explicitly set type of prepared parameter by @Tishj in https://github.com/duckdb/duckdb/pull/8114
Use many linux image in several places by @samansmink in https://github.com/duckdb/duckdb/pull/8097
Update tests broken after conflicting PRs by @samansmink in https://github.com/duckdb/duckdb/pull/8168
Auto-generate FormatSerialize/FormatDeserialize code from JSON that defines the schema by @Mytherin in https://github.com/duckdb/duckdb/pull/8156
Odbc Lambda Removal by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8167
fix: support case-insensitive lookup in SHOW TABLES by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/8173
Bump duckdb-wasm, remove patch, fix NightlyTests.yml triggers by @carlopi in https://github.com/duckdb/duckdb/pull/8176
[Python] Add extra safeguards around join method by @Tishj in https://github.com/duckdb/duckdb/pull/8170
Bump ubuntu to 18 for linux extensions build by @samansmink in https://github.com/duckdb/duckdb/pull/8179
user CMAKE_CURRENT_SOURCE_DIR by @peterboncz in https://github.com/duckdb/duckdb/pull/8183
Auto-generate type serialization + make enum generation deterministic by @Mytherin in https://github.com/duckdb/duckdb/pull/8175
Fix #7863 - use LoadLibraryW to load extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/8186
[Python UDF] Disallow create_function as part of a transaction by @Tishj in https://github.com/duckdb/duckdb/pull/8169
Arrow C API test - initialize result to nullptr by @Mytherin in https://github.com/duckdb/duckdb/pull/8184
Issue #7969: Prefer Range Join by @hawkfish in https://github.com/duckdb/duckdb/pull/8092
add verbose option to generate_grammar.py by @douenergy in https://github.com/duckdb/duckdb/pull/8181
Make the Binder respect the max_expression_depth setting by @Tishj in https://github.com/duckdb/duckdb/pull/8188
build: upload libduckdb_static.a too by @Mause in https://github.com/duckdb/duckdb/pull/8197
Pragma platform by @carlopi in https://github.com/duckdb/duckdb/pull/8195
Issue #7595: AsOf Inequalities by @hawkfish in https://github.com/duckdb/duckdb/pull/8196
CI Job names to explicit platform they build for by @carlopi in https://github.com/duckdb/duckdb/pull/8202
ODBC Small Issues fix #7918 #7890 #7653 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8205
Enable vcpkg for extensions by @samansmink in https://github.com/duckdb/duckdb/pull/8210
Remove unnecessary dbplyr fill method by @mgirlich in https://github.com/duckdb/duckdb/pull/8211
Add union to test_all_types, and arrow and json R/W by @Mause in https://github.com/duckdb/duckdb/pull/7701
R: Avoid crash when finalizing by @krlmlr in https://github.com/duckdb/duckdb/pull/8207
Fix #8191 - build duckdb shell error with “DISABLE_UNITY=1” for link … by @zzachimed in https://github.com/duckdb/duckdb/pull/8192
Chore: Bump duckdb-wasm AND move to emscripten latest by @carlopi in https://github.com/duckdb/duckdb/pull/8220
Issue #7808: Partition Using PartitionedTupleData by @hawkfish in https://github.com/duckdb/duckdb/pull/8085
some extensions (like motherduck) take an interest in SET and PRAGMA by @peterboncz in https://github.com/duckdb/duckdb/pull/8226
Change join ref type to cross if join type is cross and join ref type is regular by @Tmonster in https://github.com/duckdb/duckdb/pull/8227
Issue #8217: Test Lead/Lag Framing by @hawkfish in https://github.com/duckdb/duckdb/pull/8233
ODBC: Reformat Diagnosics Function by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8237
ODBC: Fix for Issue #8190 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8223
fix typos and spelling errors in https://github.com/duckdb/duckdb/pull/8244
(julia) fix show for query result by @tbeason in https://github.com/duckdb/duckdb/pull/8256
CI: Fix typo in LinuxRelease.yml by @carlopi in https://github.com/duckdb/duckdb/pull/8267
Remove Node 15 from supported versions by @carlopi in https://github.com/duckdb/duckdb/pull/8251
Reduce colreaders by @ccfelius in https://github.com/duckdb/duckdb/pull/8248
Fix init value type in std::accumulate by @xuke-hat in https://github.com/duckdb/duckdb/pull/8275
Allow parser extensions to use PostgresParser by @ywelsch in https://github.com/duckdb/duckdb/pull/8254
Implement ROW_GROUP_SIZE_BYTES for Parquet writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/8221
use cmake_current_source_dir by @samansmink in https://github.com/duckdb/duckdb/pull/8278
fix(jdbc): result/prepped stmt metadata by @Mause in https://github.com/duckdb/duckdb/pull/8280
ART: inline row IDs into node pointers by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8112
Skip row group size test on vsize=2 by @Mytherin in https://github.com/duckdb/duckdb/pull/8292
Update duckdb-wasm in CI & fix order of operations by @carlopi in https://github.com/duckdb/duckdb/pull/8288
Issue #8086: Parallel Window Refactoring by @hawkfish in https://github.com/duckdb/duckdb/pull/8269
[RLE] Emit constant vectors when possible by @Tishj in https://github.com/duckdb/duckdb/pull/8250
Update R tests to run test_struct.R not on CRAN by @Tmonster in https://github.com/duckdb/duckdb/pull/8297
Always initialize variables used by ParallelCSVGlobalState::MaxThreads() by @ywelsch in https://github.com/duckdb/duckdb/pull/8295
[ODBC] Add Row-Wise Fetching and Bool-to-Char Tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8306
Print join_ref_type when explaining joins by @krlmlr in https://github.com/duckdb/duckdb/pull/8276
Fix handling of cross joins by @krlmlr in https://github.com/duckdb/duckdb/pull/8274
Remove dangerous overload of cpp11::warning() by @krlmlr in https://github.com/duckdb/duckdb/pull/8272
add to_base function by @Maxxen in https://github.com/duckdb/duckdb/pull/8122
Resolve the conflict between the CTE name and the referring table name. by @douenergy in https://github.com/duckdb/duckdb/pull/8302
Compression for the INT128 type by @nickgerrets in https://github.com/duckdb/duckdb/pull/8277
Fix some function json defs by @Mause in https://github.com/duckdb/duckdb/pull/8313
Exposing InterruptState in Sink Combine & Finalize by @samansmink in https://github.com/duckdb/duckdb/pull/8296
Add iceberg extension by @samansmink in https://github.com/duckdb/duckdb/pull/8317
Serialization - Add Format(De)Serialize to almost everything by @Mytherin in https://github.com/duckdb/duckdb/pull/8323
[Python] Add a top-level native python module by @Tishj in https://github.com/duckdb/duckdb/pull/8189
CI WebAssembly: Avoid eagerly '--recurse-submodules' by @carlopi in https://github.com/duckdb/duckdb/pull/8327
PR2 for zOS support by @v1gnesh in https://github.com/duckdb/duckdb/pull/7973
fix(python): restore version field by @Mause in https://github.com/duckdb/duckdb/pull/8338
Issue 8315: Window Null Order by @hawkfish in https://github.com/duckdb/duckdb/pull/8324
Swap arguments for atan2 function to atan2(y, x) by @szarnyasg in https://github.com/duckdb/duckdb/pull/8308
Add Black Python formatter by @Mause in https://github.com/duckdb/duckdb/pull/8335
[ADBC] Add support for ingestion mode by @pdet in https://github.com/duckdb/duckdb/pull/8349
feat: python scripts formatting by @Mause in https://github.com/duckdb/duckdb/pull/8354
[Python] Correctly handle pandas DataFrames when copy_on_write is set to True by @Tishj in https://github.com/duckdb/duckdb/pull/8348
[Arrow Appender] Clean up file/folder structure by @Tishj in https://github.com/duckdb/duckdb/pull/8289
[CI] Fix test failure introduced by #8348 by @Tishj in https://github.com/duckdb/duckdb/pull/8361
Pipeline scheduling issue by @samansmink in https://github.com/duckdb/duckdb/pull/8356
Workaround for failing vcpkg openssl install by @samansmink in https://github.com/duckdb/duckdb/pull/8362
Call pwrite/pread in a loop and reduce disk space usage of window_partition_paging.test_slow by @Mytherin in https://github.com/duckdb/duckdb/pull/8369
Add format serialization for BoundFunction/Aggregate/Window and LogicalGet by @Mytherin in https://github.com/duckdb/duckdb/pull/8365
Throw exception for encrypted Parquet files by @ccfelius in https://github.com/duckdb/duckdb/pull/8368
Small out-of-tree extension fixes/features by @samansmink in https://github.com/duckdb/duckdb/pull/8375
Path separator fix windows by @samansmink in https://github.com/duckdb/duckdb/pull/8345
Compare scalar functions by name/args/return instead of function object target by @Maxxen in https://github.com/duckdb/duckdb/pull/8364
[Python] Add support for +/- infinity datetime objects by @Tishj in https://github.com/duckdb/duckdb/pull/8294
Format serialization - add missing serialization logic for DelimJoin, AsOfJoin, CreateIndex and enums by @Mytherin in https://github.com/duckdb/duckdb/pull/8378
[CI Python] More 'copy_on_write' fixes by @Tishj in https://github.com/duckdb/duckdb/pull/8376
fix end of file handling for gzip files by @igorcalabria in https://github.com/duckdb/duckdb/pull/8386
Issue CI workflows by @lnkuiper in https://github.com/duckdb/duckdb/pull/8390
[CI] Fix nightly tests (sqllogictests, asof join out of disk space) by @Mytherin in https://github.com/duckdb/duckdb/pull/8385
use labels field instead of workflow for needs triage by @Mause in https://github.com/duckdb/duckdb/pull/8400
[Python] Remove PyObject * where possible by @Tishj in https://github.com/duckdb/duckdb/pull/8393
Fix CMake syntax on non defined variable by @carlopi in https://github.com/duckdb/duckdb/pull/8401
[RLE] Fix problem created by #8250 by @Tishj in https://github.com/duckdb/duckdb/pull/8391
[Arrow] Fix conversion from arrow -> duckdb for nested structs by @Tishj in https://github.com/duckdb/duckdb/pull/8383
[ADBC] Python Tests and Fix for Arrow Schema call. by @pdet in https://github.com/duckdb/duckdb/pull/8366
Use bot token for issue workflows and increase stale issue budget by @lnkuiper in https://github.com/duckdb/duckdb/pull/8404
Nitpick: change case of "stale" issue label by @lnkuiper in https://github.com/duckdb/duckdb/pull/8407
capi: duckdb_interrupt & duckdb_query_progress by @Virgiel in https://github.com/duckdb/duckdb/pull/8064
Bind the children of a STRUCT alias type. by @Tishj in https://github.com/duckdb/duckdb/pull/8389
[NanODBC] Fix run_nanodbc_tests.sh by @Tishj in https://github.com/duckdb/duckdb/pull/8388
ODBC: Add remaining tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8382
fix minor ci failure by @samansmink in https://github.com/duckdb/duckdb/pull/8411
Update bug_report.yml to ask a better master build question by @Mause in https://github.com/duckdb/duckdb/pull/8427
Fix capi streaming test - this is not deterministic if there are background threads by @Mytherin in https://github.com/duckdb/duckdb/pull/8429
bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/8394
read_csv_auto tests: Change 'delimiter' to 'delim' by @szarnyasg in https://github.com/duckdb/duckdb/pull/8409
[Arrow] Add ChunkScanState interface to preserve chunk-offset when scanning by @Tishj in https://github.com/duckdb/duckdb/pull/8307
Qualify macros only when called, and throw error on recursive macros by @lnkuiper in https://github.com/duckdb/duckdb/pull/8224
Add instructions for installing black and clang-format by @Mause in https://github.com/duckdb/duckdb/pull/8373
Get issue title safely in workflow by @lnkuiper in https://github.com/duckdb/duckdb/pull/8436
[ADBC] [Python] Adding extra tests and small fixes by @pdet in https://github.com/duckdb/duckdb/pull/8431
Set total_byte_size of Parquet row groups by @lnkuiper in https://github.com/duckdb/duckdb/pull/8405
Python TIMESTAMPTZ support by @pdet in https://github.com/duckdb/duckdb/pull/8089
Add "require noalternativeverify" to all FTS tests by @lnkuiper in https://github.com/duckdb/duckdb/pull/8448
Check for duplicate member tag names in serialization generation by @Maxxen in https://github.com/duckdb/duckdb/pull/8449
Issue #5610: Disallow Chained Frames by @hawkfish in https://github.com/duckdb/duckdb/pull/8442
Issue #8416: Pre-Gregorian Timestamps by @hawkfish in https://github.com/duckdb/duckdb/pull/8418
Issue #8399: ICU Epoch Offset by @hawkfish in https://github.com/duckdb/duckdb/pull/8415
Finish specialization of the LIST aggregate function by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8309
Add Java format config to clang-format by @Mause in https://github.com/duckdb/duckdb/pull/8355
List_slice adjusted NULL handling and added steps feature by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8087
DuckDB PySpark Types by @Tishj in https://github.com/duckdb/duckdb/pull/8165
Fix issue 8230 by @samansmink in https://github.com/duckdb/duckdb/pull/8450
Move all extensions to new build, remove legacy ci by @samansmink in https://github.com/duckdb/duckdb/pull/8465
[Dev] Update uncovered files by @Tishj in https://github.com/duckdb/duckdb/pull/8476
[Python Dev] Use pytest.mark.parametrize to make test logs easier to read in test_all_types.py by @Tishj in https://github.com/duckdb/duckdb/pull/8479
[C-API + CLI]

These notes run past the length kept in the archive. The rest is on the publisher’s page.