Duckdb

This is a bug fix release for various issues discovered after we released 0.10.1. There are no new features, just bug fixes. Database files created by DuckDB v0.10.* or v0.9.* can be read by DuckDB v0.10.2.

SQL Modifications

This release has a number of bug fixes that change SQL semantics in a few edge cases:

* Nested Boolean Comparisons now have consistent NULL comparison semantics - https://github.com/duckdb/duckdb/pull/11496
* Structs with non-matching keys require explicit casts when compared or combined - https://github.com/duckdb/duckdb/pull/11396

What's Changed
* Bump julia version & fix release script for sub-versions > 9 by Mytherin in https://github.com/duckdb/duckdb/pull/11225
* Flatten Rewrite by maiadegraaf in https://github.com/duckdb/duckdb/pull/11223
* ORDER BY ColumnNumber with Collations by tiagokepe in https://github.com/duckdb/duckdb/pull/11139
* Fix differences to implementation for to_parquet, write_parquet, to_csv, write_csv, Expression.alias, DuckDBPyRelation.map by binste in https://github.com/duckdb/duckdb/pull/11135
* Issue template: Ask for MWEs by szarnyasg in https://github.com/duckdb/duckdb/pull/11192
* Cleaning up FSST: Remove unused AVX512 code by hannes in https://github.com/duckdb/duckdb/pull/11222
* Fix 11211 - correctly fill in string_t padding for bit type by Mytherin in https://github.com/duckdb/duckdb/pull/11231
* Fix 3391: Stop creating background threads if the thread constructor throws an exception by Mytherin in https://github.com/duckdb/duckdb/pull/11236
* R_CMD_CHECK: Pin to duckdb/duckdb-r 0ed106a71c by carlopi in https://github.com/duckdb/duckdb/pull/11245
* Add support for HEX(BLOB) by Mytherin in https://github.com/duckdb/duckdb/pull/11243
* Remove no_vector_verification in Map Subscript Test by maiadegraaf in https://github.com/duckdb/duckdb/pull/11242
* Update logos in README by szarnyasg in https://github.com/duckdb/duckdb/pull/11256
* Ignore user defined parameters that change names or types of csv columns in sniffer's prompt. by pdet in https://github.com/duckdb/duckdb/pull/11257
* [Python] Fix error caused by looking up a TypeCatalogEntry without an active transaction. by Tishj in https://github.com/duckdb/duckdb/pull/11255
* [Fix] Fuzzer issue in list_select by taniabogatsch in https://github.com/duckdb/duckdb/pull/11248
* [Parquet] Support for LZ4 Compression by hannes in https://github.com/duckdb/duckdb/pull/11220
* Fix 11254: Add missing includes to terminal by Mytherin in https://github.com/duckdb/duckdb/pull/11265
* Issue 10867: AsOf Predicate Pushdown by hawkfish in https://github.com/duckdb/duckdb/pull/11233
* Fix plan cost runner regression script by Tmonster in https://github.com/duckdb/duckdb/pull/11129
* Check if we need to throw any remaining errors at end of CSV scanning by pdet in https://github.com/duckdb/duckdb/pull/11276
* Allow duplicate names in json objects when ignore_errors is true by lnkuiper in https://github.com/duckdb/duckdb/pull/11271
* Do not surround JSON with quotes in sqlite shell output by lnkuiper in https://github.com/duckdb/duckdb/pull/11268
* add TRIM support to virtual filesystem, and implementation on linux by jkub in https://github.com/duckdb/duckdb/pull/11258
* Perform direct write operation if input data are larger than buffer size by quentingodeau in https://github.com/duckdb/duckdb/pull/11203
* Fuzzer fixes by lnkuiper in https://github.com/duckdb/duckdb/pull/11286
* Compile spatial also for rtools by carlopi in https://github.com/duckdb/duckdb/pull/11291
* allow injecting custom BufferManager implementation by jkub in https://github.com/duckdb/duckdb/pull/11215
* Default to RECORDS in JSON reader if more than one column is specified by lnkuiper in https://github.com/duckdb/duckdb/pull/11295
* Add support for materialized CTEs in INSERT/UPDATE/DELETE statements by kryonix in https://github.com/duckdb/duckdb/pull/10878
* Only throw exception if `je_mallctl` fails in DEBUG mode by lnkuiper in https://github.com/duckdb/duckdb/pull/11303
* Fixing casting issue in generators by hannes in https://github.com/duckdb/duckdb/pull/11304
* Rework `FileSystem::OpenFile` call, and add `FILE_FLAGS_NULL_IF_NOT_EXISTS` by Mytherin in https://github.com/duckdb/duckdb/pull/11297
* Fix potential UB when `list()` aggregate is used in combination with other arena using aggregate functions by Maxxen in https://github.com/duckdb/duckdb/pull/11306
* Fix 11293 - for ARRAY([subquery]) explicitly push the ORDER BY of the underlying subquery into the array aggregate by Mytherin in https://github.com/duckdb/duckdb/pull/11316
* Fix 11281: explicitly select column types of information_schema tables for all columns, even if they are always NULL by Mytherin in https://github.com/duckdb/duckdb/pull/11317
* Fixup py upload by carlopi in https://github.com/duckdb/duckdb/pull/11308
* Issue 11279: TIMESTAMP => TIMESTAMPTZ by hawkfish in https://github.com/duckdb/duckdb/pull/11320
* Fix null pointer exception when rolling back updates if the rollback was caused by an OOM by Mytherin in https://github.com/duckdb/duckdb/pull/11309
* Fix 11283 - report consistent foreign key constraint name in information_schema by Mytherin in https://github.com/duckdb/duckdb/pull/11318
* Fix 11294 - avoid applying Filter Pushdown optimization for UNION/EXCEPT without ALL by Mytherin in https://github.com/duckdb/duckdb/pull/11315
* Fix 10695 - handle ? prepared statement parameters correctly for POSITION(x IN y) by Mytherin in https://github.com/duckdb/duckdb/pull/11314
* Windows CLI - emit UTF8 directly using SetConsoleOutputCP(CP_UTF8) if possible by Mytherin in https://github.com/duckdb/duckdb/pull/11324
* Fix 11319: use modulo when computing day of the week in excel extension by Mytherin in https://github.com/duckdb/duckdb/pull/11328
* [CI] Fix bash syntax in TwineUpload by carlopi in https://github.com/duckdb/duckdb/pull/11333
* Fix 11284: avoid adding the same column multiple times to a primary key/unique constraint name list by Mytherin in https://github.com/duckdb/duckdb/pull/11325
* In ColumnData, limit scan to the current count in the column by Mytherin in https://github.com/duckdb/duckdb/pull/11329
* Issue 11269: DISTINCT Sorted Aggregates by hawkfish in https://github.com/duckdb/duckdb/pull/11321
* [Attach] Fix bug causing sequences to break attaching databases. by Tishj in https://github.com/duckdb/duckdb/pull/11327
* Flatten hash vector before combining list hashes by lnkuiper in https://github.com/duckdb/duckdb/pull/11340
* Make sniffer more consistent when nullpadding/ignore_errors are on by pdet in https://github.com/duckdb/duckdb/pull/11313
* fix(arrow): union buffer count & handle schema errors by Mause in https://github.com/duckdb/duckdb/pull/11326
* fix duckdb-r script by Tmonster in https://github.com/duckdb/duckdb/pull/11345
* Fix regression_test_runner.py by carlopi in https://github.com/duckdb/duckdb/pull/11346
* Issue 11234: IEJoin Scan Reset by hawkfish in https://github.com/duckdb/duckdb/pull/11347
* TPC-H: Use BIGINT for ID fields schema where required by the specification by szarnyasg in https://github.com/duckdb/duckdb/pull/11341
* Another round of polishing staged releases by carlopi in https://github.com/duckdb/duckdb/pull/11342
* CI: Remove issue labeling workflow by szarnyasg in https://github.com/duckdb/duckdb/pull/11355
* RE2 upgrade to version 2023-02-01 by hannes in https://github.com/duckdb/duckdb/pull/11252
* File System: Add `optional_ptr<FileOpener>` to various calls, and add support for attaching DuckDB files over S3 by Mytherin in https://github.com/duckdb/duckdb/pull/11343
* README: Display different logo for light/dark mode by szarnyasg in https://github.com/duckdb/duckdb/pull/11366
* Fix bug in duckdb_bind_blob by pfarndt in https://github.com/duckdb/duckdb/pull/11368
* Fix OSX CI by samansmink in https://github.com/duckdb/duckdb/pull/11379
* Enable clang-tidy on headers and fix all headers to conform to our clang-tidy rules by Mytherin in https://github.com/duckdb/duckdb/pull/11376
* Add logical_type to parameters of format_pg_type by Flogex in https://github.com/duckdb/duckdb/pull/11369
* Issue 10965: RESPECT IGNORE NULLS by hawkfish in https://github.com/duckdb/duckdb/pull/11372
* Fix building issues in WIN32, remove unnecessary modification. by kindred77 in https://github.com/duckdb/duckdb/pull/11356
* Zero-initialize aggregate states with destructors immediately after allocating by lnkuiper in https://github.com/duckdb/duckdb/pull/11360
* Update README.md by jingshi-ant in https://github.com/duckdb/duckdb/pull/11357
* Issue 10885: Negative Window RANGEs by hawkfish in https://github.com/duckdb/duckdb/pull/11390
* Issue 11377: Invertible TIMESTAMP_XXX Casts by hawkfish in https://github.com/duckdb/duckdb/pull/11392
* Update __init__.py To export "extract_statements" function by oomojola in https://github.com/duckdb/duckdb/pull/11394
* Internal 1657: Stricter STRUCT Casts by hawkfish in https://github.com/duckdb/duckdb/pull/11396
* allow set readonly on attached db by stephaniewang526 in https://github.com/duckdb/duckdb/pull/11397
* Give preference to FSSPEC defined FS by pdet in https://github.com/duckdb/duckdb/pull/11400
* Default serialize `optional_idx`, add `skip_default` option to `json_serialize_sql()` by Maxxen in https://github.com/duckdb/duckdb/pull/11405
* CI: Also label PRs as 'stale' and close them when there's no activity by szarnyasg in https://github.com/duckdb/duckdb/pull/11420
* fix(jdbc): 1-index getBytes() by Mause in https://github.com/duckdb/duckdb/pull/11421
* Remove redundant default descriptions by szarnyasg in https://github.com/duckdb/duckdb/pull/11415
* clang-tidy: enable `cppcoreguidelines-pro-type-const-cast` by Mytherin in https://github.com/duckdb/duckdb/pull/11414
* clang-tidy: enable `cppcoreguidelines-avoid-non-const-global-variables` by Mytherin in https://github.com/duckdb/duckdb/pull/11424
* Issue 11419: Quantile Order By by hawkfish in https://github.com/duckdb/duckdb/pull/11428
* [CSV Sniffer] Give preference to quoted candidates by pdet in https://github.com/duckdb/duckdb/pull/11418
* clang-tidy: enable `cppcoreguidelines-virtual-class-destructor` by Mytherin in https://github.com/duckdb/duckdb/pull/11437
* clang-tidy: enable `cppcoreguidelines-[interfaces-global-init|slicing|rvalue-reference-param-not-moved]` by Mytherin in https://github.com/duckdb/duckdb/pull/11435
* Fix 11393 - improve error message when trying to use a lateral join column in a table function that does not support it by Mytherin in https://github.com/duckdb/duckdb/pull/11436
* add readonly to duckdb_databases() by stephaniewang526 in https://github.com/duckdb/duckdb/pull/11429
* Fix missing opener propagation by quentingodeau in https://github.com/duckdb/duckdb/pull/11454
* Fix 11246: Use SetConsoleCP function to set input to UTF8 when reading by Mytherin in https://github.com/duckdb/duckdb/pull/11452
* CLI: Add support for ".edit" or "\e" by Mytherin in https://github.com/duckdb/duckdb/pull/11447
* Fix VS2022 Preview ClangCl build by bodand in https://github.com/duckdb/duckdb/pull/11456
* Remove an unnecessary line from bind_insert.cpp by huachaohuang in https://github.com/duckdb/duckdb/pull/11443
* [CI] Skip ccache for R.yml by carlopi in https://github.com/duckdb/duckdb/pull/11459
* Improve binding of CTEs by kryonix in https://github.com/duckdb/duckdb/pull/11399
* Move BindCreateIndex from Catalog to Binder by philippmd in https://github.com/duckdb/duckdb/pull/11402
* [Substrait-ADBC] Fix for substrait plan execution via ADBC by pdet in https://github.com/duckdb/duckdb/pull/11358
* Removing abort() from RE2 again because Google refuses to use exceptions by hannes in https://github.com/duckdb/duckdb/pull/11458
* Defer allocation in read_json by lnkuiper in https://github.com/duckdb/duckdb/pull/11378
* [ODBC] Add escape character to ParseStringFilter to support Power Query ('table_name' is escaped to 'table\_name') by guenp in https://github.com/duckdb/duckdb/pull/11432
* Bump to post-portfile change for duckdb_azure by carlopi in https://github.com/duckdb/duckdb/pull/11476
* Reduce memory usage of DELETE operations by Mytherin in https://github.com/duckdb/duckdb/pull/11470
* Use `optional_idx` in more places by Mytherin in https://github.com/duckdb/duckdb/pull/11466
* Revert "Move BindCreateIndex from Catalog to Binder" by Mytherin in https://github.com/duckdb/duckdb/pull/11478
* [Arrow] Throw on invalid STRUCT type by Tishj in https://github.com/duckdb/duckdb/pull/11464
* [Dev] Do not use CatalogEntry references inside Dependency objects. by Tishj in https://github.com/duckdb/duckdb/pull/11408
* Fix extension builds by carlopi in https://github.com/duckdb/duckdb/pull/11486
* [Fix] Throw BinderException for UNNEST expressions in WINDOW expressions by taniabogatsch in https://github.com/duckdb/duckdb/pull/11247
* Check for IUTF8 flag defined before setting it by patmaddox in https://github.com/duckdb/duckdb/pull/11488
* Fix 11445: correctly detect recursive aliases when using struct unnest by Mytherin in https://github.com/duckdb/duckdb/pull/11497
* Fix 11444: avoid using recursion in string -> list parsing by Mytherin in https://github.com/duckdb/duckdb/pull/11498
* Add serialization for `LogicalCopyDatabase` operator by Flogex in https://github.com/duckdb/duckdb/pull/11401
* add support in Julia appender for missing and nothing values by rdavis120 in https://github.com/duckdb/duckdb/pull/11508
* [Python] Produce `datetime.time` values when converting TIME columns to Pandas DataFrame by Tishj in https://github.com/duckdb/duckdb/pull/11468
* [Fix][ADBC] Implement required ADBCConnectionGetObjects schema by joellubi in https://github.com/duckdb/duckdb/pull/11446
* Add support for decimal modulo operation by Mytherin in https://github.com/duckdb/duckdb/pull/11506
* Move `CompressedMaterialization` inside of `StatisticsPropagator` by lnkuiper in https://github.com/duckdb/duckdb/pull/11495
* Bump stale bot version by szarnyasg in https://github.com/duckdb/duckdb/pull/11509
* Rework issue workflow by Mytherin in https://github.com/duckdb/duckdb/pull/11522
* [RE2] Add includes and remove potential throw from destructor by carlopi in https://github.com/duckdb/duckdb/pull/11513
* Issue 11292: Nested Boolean Compares by hawkfish in https://github.com/duckdb/duckdb/pull/11496
* [Dev] Initialize new buffers with garbage data if `DESTROY_UNPINNED_BLOCKS` is set by Tishj in https://github.com/duckdb/duckdb/pull/11270
* Fix timeout in async workflow by samansmink in https://github.com/duckdb/duckdb/pull/11525
* Move assertion in `json_scan.cpp` by lnkuiper in https://github.com/duckdb/duckdb/pull/11530
* Issue 11518: TryParseTime by hawkfish in https://github.com/duckdb/duckdb/pull/11519
* Fuzzer Bugfixes by Maxxen in https://github.com/duckdb/duckdb/pull/11544
* [CI] Fix CI failure on `C Enum Integrity Check` by Tishj in https://github.com/duckdb/duckdb/pull/11547
* [ICU] Use the correct lookup precedence for TimeZone settings by Tishj in https://github.com/duckdb/duckdb/pull/11546
* [CI] Move from default GITHUB_TOKEN to specific one by carlopi in https://github.com/duckdb/duckdb/pull/11556
* [CI] Fix Deploy step to execute only for duckdb organization by carlopi in https://github.com/duckdb/duckdb/pull/11553
* Rework `RadixPartitionHashTable` task assignment in source phase by lnkuiper in https://github.com/duckdb/duckdb/pull/11528
* Run new micro benchmarks in CI when they are added by Tmonster in https://github.com/duckdb/duckdb/pull/11532
* Rework `vector_hash` for ARRAYs by Maxxen in https://github.com/duckdb/duckdb/pull/11558
* [Dev] Add assertions around Uncompressed String storage by Tishj in https://github.com/duckdb/duckdb/pull/11267
* python: Add missing global options to write_csv by jzavala-gonzalez in https://github.com/duckdb/duckdb/pull/10382
* [Python] Fix issue with lists containing dictionaries of different sizes by Tishj in https://github.com/duckdb/duckdb/pull/11095
* [Dev][Python] Add nightly test to execute all sqllogic tests using the python package by Tishj in https://github.com/duckdb/duckdb/pull/11137
* Parquet Writer: Early out creating dictionary by lnkuiper in https://github.com/duckdb/duckdb/pull/11461
* ODBC driver should ignore "driver" and "trusted_connection" keywords in connection string by guenp in https://github.com/duckdb/duckdb/pull/11382
* [ODBC] Fix: Support loading UTF-8 encoded data with Power BI by guenp in https://github.com/duckdb/duckdb/pull/11423
* Draft permissions - bot does not have permission for drafting by Mytherin in https://github.com/duckdb/duckdb/pull/11575
* CI: Remove 'needs reproducible example' when 'reproduced' label is applied by szarnyasg in https://github.com/duckdb/duckdb/pull/11576
* Various fixes & clean-up around STRUCT UNNEST by Mytherin in https://github.com/duckdb/duckdb/pull/11580
* Update token by Mytherin in https://github.com/duckdb/duckdb/pull/11592
* Update issue template by szarnyasg in https://github.com/duckdb/duckdb/pull/11577
* [CI] Remove GITHUB_PAT variable from R-CMD-check by carlopi in https://github.com/duckdb/duckdb/pull/11593
* Respect read-only mode in dbgen and dsdgen by Mytherin in https://github.com/duckdb/duckdb/pull/11585
* Bump-back duckdb_azure to pre-lzma custom vcpkg-port by carlopi in https://github.com/duckdb/duckdb/pull/11595
* Correctly handle database names with quotes in USE statement by Mytherin in https://github.com/duckdb/duckdb/pull/11587
* Bump postgres version and build arrow also for windows by carlopi in https://github.com/duckdb/duckdb/pull/11604
* Support reading gzipped files in the test runner by chrisiou in https://github.com/duckdb/duckdb/pull/11600
* initializes unknown indexes on catalog lookup by Maxxen in https://github.com/duckdb/duckdb/pull/11551
* Fix Progress Bar for many large CSV Files + Adjustment to not store buffers from compressed files over single threaded scans by pdet in https://github.com/duckdb/duckdb/pull/11273
* CSV Rejects Tables 2.0 by pdet in https://github.com/duckdb/duckdb/pull/11512
* Fix topn placement by Tmonster in https://github.com/duckdb/duckdb/pull/11601
* Fix various issues found by oss-fuzz by Mytherin in https://github.com/duckdb/duckdb/pull/11613
* [ODBC] Fix: timestamps and times are parsed as dates by Power Query by guenp in https://github.com/duckdb/duckdb/pull/11610
* Fix various fuzzer issues, move fuzzer scripts into this repo, and expand `reduce_sql_statement` to improve test case reduction capabilities of fuzzer by Mytherin in https://github.com/duckdb/duckdb/pull/11622
* [Dev] Make the `extension_entries.hpp` generation script more modular by Tishj in https://github.com/duckdb/duckdb/pull/11623
* [Fix][ADBC] Don't filter system catalogs/schemas in ConnectionGetObjects by joellubi in https://github.com/duckdb/duckdb/pull/11618
* Add pyodide wheel building github action by cpcloud in https://github.com/duckdb/duckdb/pull/11531
* Move away from dynamic_cast to Cast<> infrastructure by carlopi in https://github.com/duckdb/duckdb/pull/11619
* Extension Metadata by carlopi in https://github.com/duckdb/duckdb/pull/11515
* [Dev] Regenerate query string for `IndexCatalogEntry`. by Tishj in https://github.com/duckdb/duckdb/pull/11462
* Upload pyodide by carlopi in https://github.com/duckdb/duckdb/pull/11626
* Add docker alpine build to check on builds by carlopi in https://github.com/duckdb/duckdb/pull/11490
* Add Vector Similarity Search (VSS) Extension by Maxxen in https://github.com/duckdb/duckdb/pull/11614
* Metadata fix by carlopi in https://github.com/duckdb/duckdb/pull/11629
* Fix extension config for arrow, remove patch from sqlite by carlopi in https://github.com/duckdb/duckdb/pull/11628
* [CSV Reader] Resets the buffer manager over recursive scans by pdet in https://github.com/duckdb/duckdb/pull/11631
* Make path to append_metadata.cmake relative to top-level CMakeLists.txt by Flogex in https://github.com/duckdb/duckdb/pull/11635
* [CSV Reader] Fixes an issue with conflicting strategies for buffer cleaning by pdet in https://github.com/duckdb/duckdb/pull/11630
* Fix more issues found by the fuzzer, extend SQL reduction further by Mytherin in https://github.com/duckdb/duckdb/pull/11642
* fix(jdbc): support non-string parameter types by Mause in https://github.com/duckdb/duckdb/pull/11646
* Few more fuzzer fixes by Mytherin in https://github.com/duckdb/duckdb/pull/11648
* Bump spatial by Maxxen in https://github.com/duckdb/duckdb/pull/11650
* Avoid performing Apple codesign on extensions by carlopi in https://github.com/duckdb/duckdb/pull/11652
* Filter out single relation predicates before join ordering by wangxiaoying in https://github.com/duckdb/duckdb/pull/11645
* Fix `last_value` in the `duckdb_sequences` metadata function by Tishj in https://github.com/duckdb/duckdb/pull/11465
* Limit batch insert threads based on available memory, similar to Parquet write by Mytherin in https://github.com/duckdb/duckdb/pull/11655
* [Vacuum] Fix serialization and Copy of the VacuumStatement by Tishj in https://github.com/duckdb/duckdb/pull/11656
* More index initialization by Maxxen in https://github.com/duckdb/duckdb/pull/11659
* Skip tests with the unzip keyword in python and disable unzip.test for 32bit systems by chrisiou in https://github.com/duckdb/duckdb/pull/11658
* Bump extension versions, remove patches by carlopi in https://github.com/duckdb/duckdb/pull/11662
* Accept a list of multiple nullstring values for CSV Files by pdet in https://github.com/duckdb/duckdb/pull/11616
* Include falloc to fix build on some Linux systems by zmbc in https://github.com/duckdb/duckdb/pull/11663
* Fix 11469 - make unnest parameters case-insensitive by Mytherin in https://github.com/duckdb/duckdb/pull/11667
* Fix 11467: correctly merge unnamed structs and structs in CombineEqualTypes by Mytherin in https://github.com/duckdb/duckdb/pull/11668
* Skip ADBC tests if python version is not 3.9 or higher by pdet in https://github.com/duckdb/duckdb/pull/11653
* Fix 11621 - correctly zero-initialize padding bits in bitpacking compression by Mytherin in https://github.com/duckdb/duckdb/pull/11671
* Fix 11542 - correctly check if a column data segment has updates, and clean up the updates by Mytherin in https://github.com/duckdb/duckdb/pull/11670
* Make UNION BY NAME also use ForceMaxLogicalType, similar to UNION by Mytherin in https://github.com/duckdb/duckdb/pull/11665
* Fix extension_version propagation for external extensions by carlopi in https://github.com/duckdb/duckdb/pull/11672
* Allow decimal type in CSV auto_type_candidates option by pdet in https://github.com/duckdb/duckdb/pull/11675
* Fix 11484: support constant indexes in ARRAY - e.g. `ARRAY(SELECT .. ORDER BY 1)` by Mytherin in https://github.com/duckdb/duckdb/pull/11674
* Improve hive type auto-casting so that it looks at all files instead of only the first file by Mytherin in https://github.com/duckdb/duckdb/pull/11676
* Fix 11669: deduplicate column names in pivot correctly by Mytherin in https://github.com/duckdb/duckdb/pull/11678
* Disable setting console pages by default, and add .utf8 setting by Mytherin in https://github.com/duckdb/duckdb/pull/11682
* bump vss, handle reverting append when index is unknown by Maxxen in https://github.com/duckdb/duckdb/pull/11681

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.10.1...v0.10.2

This is a bug fix release for various issues discovered after we released 0.10.0. There are no new features, just bug fixes. Database files created by DuckDB v0.10.0 or v0.9.* can be read by DuckDB v0.10.1.

What's Changed
* Remove `visualizer` leftovers by Y-- in https://github.com/duckdb/duckdb/pull/10642
* Add explicit numbering to C enums + various compilation/CI fixes by Mytherin in https://github.com/duckdb/duckdb/pull/10649
* Disable print method for CSV scanner for R build by hannes in https://github.com/duckdb/duckdb/pull/10650
* Fix 10548 for the DUCKDB_NO_THREADS case by carlopi in https://github.com/duckdb/duckdb/pull/10654
* Allow StorageExtension to extend DuckCatalog implementation in order to integration with observability system by bleskes in https://github.com/duckdb/duckdb/pull/10643
* Update storage info for v0.10.0 by szarnyasg in https://github.com/duckdb/duckdb/pull/10660
* Revamp duckdb-wasm extensions CI by carlopi in https://github.com/duckdb/duckdb/pull/10672
* [CI] Re-enable skipped test `window-rows-overflow.test` by Tishj in https://github.com/duckdb/duckdb/pull/10679
* Catch: prominently display skipped tests by Mytherin in https://github.com/duckdb/duckdb/pull/10669
* Update Julia to 0.10.0 by Mytherin in https://github.com/duckdb/duckdb/pull/10689
* Ingestion benchmark framework by Tmonster in https://github.com/duckdb/duckdb/pull/10341
* [ICU] Add casts from Timestamp_* to TimestampTZ by Tishj in https://github.com/duckdb/duckdb/pull/9539
* DISTINCT ON - greatly improve performance by rewriting ordered FIRST aggregate into arg_min_null by Mytherin in https://github.com/duckdb/duckdb/pull/10684
* Fix 10685 - support aliases in join clause by Mytherin in https://github.com/duckdb/duckdb/pull/10691
* Use assertThrows for throwing assertions in JDBC tests by peteraisher in https://github.com/duckdb/duckdb/pull/10448
* Casts: report error location in query for failed casts by Mytherin in https://github.com/duckdb/duckdb/pull/10694
* Fix duckdb spelling in _extension_deploy.yml by carlopi in https://github.com/duckdb/duckdb/pull/10717
* Fuzzer 1374: ARG_XXX By Decimal by hawkfish in https://github.com/duckdb/duckdb/pull/10728
* [Python] Rework the python regression test script by Tishj in https://github.com/duckdb/duckdb/pull/10715
* Removes static member string by TinyTinni in https://github.com/duckdb/duckdb/pull/10733
* Fuzzer 1372: Order Bind Failure by hawkfish in https://github.com/duckdb/duckdb/pull/10727
* Fuzzer 1380: To Weeks Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/10726
* Various fixes by carlopi in https://github.com/duckdb/duckdb/pull/10708
* Unittest does not satify assertion on MSVC/Debug by TinyTinni in https://github.com/duckdb/duckdb/pull/10738
* Fix OrderPreservationType issue of MATERIALIZED CTEs by kryonix in https://github.com/duckdb/duckdb/pull/10587
* Map creation fixes and refactoring by taniabogatsch in https://github.com/duckdb/duckdb/pull/10436
* Fuzzer 1383: NULL Range Arguments by hawkfish in https://github.com/duckdb/duckdb/pull/10723
* Fuzzer 1382: Window Stats Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/10725
* Comment on view columns by samansmink in https://github.com/duckdb/duckdb/pull/10710
* Union exclude by Tmonster in https://github.com/duckdb/duckdb/pull/10688
* move the logic for immediate_transaction_mode to the physical operator by peterboncz in https://github.com/duckdb/duckdb/pull/10739
* [C API] Small fix and more tests by taniabogatsch in https://github.com/duckdb/duckdb/pull/10748
* List_slice bug fix by maiadegraaf in https://github.com/duckdb/duckdb/pull/10747
* Enable azure autoload by samansmink in https://github.com/duckdb/duckdb/pull/10746
* Parquet writer - reduce memory usage of order-preserving write by Mytherin in https://github.com/duckdb/duckdb/pull/10756
* Refactor csv reader includes because of r path length limitations by hannes in https://github.com/duckdb/duckdb/pull/10658
* Arrow String View Type by pdet in https://github.com/duckdb/duckdb/pull/10481
* local_file_system.cpp: minor fix for macOS libproc code by barracuda156 in https://github.com/duckdb/duckdb/pull/10758
* Make unnamed_subquery naming predictable by Mytherin in https://github.com/duckdb/duckdb/pull/10765
* [Python] Fix overflow issue in PandasAnalyzer by Tishj in https://github.com/duckdb/duckdb/pull/10768
* Throw when trying to consume over 128 byte decimals by pdet in https://github.com/duckdb/duckdb/pull/10601
* CLI: Right-align numerics in markdown tables by Mytherin in https://github.com/duckdb/duckdb/pull/10767
* Fuzzer 1399: Window NULL RANGE by hawkfish in https://github.com/duckdb/duckdb/pull/10776
* [CSV Sniffer] Minor sniffer tweak to give preference to dialects that generate the least errors if ignore_errors = true by pdet in https://github.com/duckdb/duckdb/pull/10777
* Add large benchmark directory by Tmonster in https://github.com/duckdb/duckdb/pull/10763
* Improve UNPIVOT error messages, and allow expressions in unpivot by Mytherin in https://github.com/duckdb/duckdb/pull/10773
* Add a method UUID::FromUHugeint to generate a UUID from a uhugeint_t by Mytherin in https://github.com/duckdb/duckdb/pull/10771
* [CSV Reader] Add lock to buffer reset by pdet in https://github.com/duckdb/duckdb/pull/10791
* [WINDOWS] Add "/bigobj" that solves compile issue during debug by maiadegraaf in https://github.com/duckdb/duckdb/pull/10782
* fix: not over-call AllSecrets by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10807
* Update readme by szarnyasg in https://github.com/duckdb/duckdb/pull/10814
* [ODBC] Rework Connect to the ODBC driver and add functionality to set all DuckDB configurations in the Connection String by maiadegraaf in https://github.com/duckdb/duckdb/pull/10692
* Fix arrow conversion, map doesn't support large offset by yiyuanliu in https://github.com/duckdb/duckdb/pull/10796
* [CSV Reader] Spinlock over GetLine Error + New Strategy for dialect candidates by pdet in https://github.com/duckdb/duckdb/pull/10755
* Trivial fixes by carlopi in https://github.com/duckdb/duckdb/pull/10816
* Fix unicode handling in underscore of LIKE operator by Mytherin in https://github.com/duckdb/duckdb/pull/10821
* JDBC spurious CI failure - an exception being thrown in this test is a race condition by Mytherin in https://github.com/duckdb/duckdb/pull/10825
* Benchmark runner - allow files (e.g. CSV/Parquet) to be cached using the cache command by Mytherin in https://github.com/duckdb/duckdb/pull/10817
* Fix 10803 - correctly reclaim space of list indexes when columns are dropped by Mytherin in https://github.com/duckdb/duckdb/pull/10822
* [Upsert] `INSERT OR REPLACE` fixes by Tishj in https://github.com/duckdb/duckdb/pull/10789
* [Dev] Add an optional time out in seconds to `run_tests_one_by_one.py` by Tishj in https://github.com/duckdb/duckdb/pull/10744
* Maintain names in COLUMNS(*) expression, and allow aliasing multiple columns using {column} by Mytherin in https://github.com/duckdb/duckdb/pull/10774
* Disable AWS/Azure on Windows for now by Mytherin in https://github.com/duckdb/duckdb/pull/10827
* [Dev] Bump memory limit on batch_memory_usage.test_slow by carlopi in https://github.com/duckdb/duckdb/pull/10845
* Fix coverity apt-get by carlopi in https://github.com/duckdb/duckdb/pull/10838
* minor: FixedSizeBuffer::Pin move shared_ptr rather than copying by mapleFU in https://github.com/duckdb/duckdb/pull/10837
* ci: Upgrade workflows to actions/setup-pythonv5 by krlmlr in https://github.com/duckdb/duckdb/pull/10832
* Fuzzer 1389: ARG_XXX Decimal Casts by hawkfish in https://github.com/duckdb/duckdb/pull/10742
* Contributor guide: Fix new issue link by szarnyasg in https://github.com/duckdb/duckdb/pull/10836
* Changing source to src in relational_constraints query by Dtenwolde in https://github.com/duckdb/duckdb/pull/10848
* Fix: correctly calculate the range of build side for perfect hash join by gitccl in https://github.com/duckdb/duckdb/pull/10446
* [Python] Fix issue caused by deadlock between `thread.join()` and acquiring the GIL by Tishj in https://github.com/duckdb/duckdb/pull/10854
* [CSV Parser] 8-Byte Skipping instead of 1-Byte when possible by pdet in https://github.com/duckdb/duckdb/pull/10855
* Add components of the version to duckdb.hpp by ahuarte47 in https://github.com/duckdb/duckdb/pull/10840
* [CSV Sniffer] Tweaking header detection by pdet in https://github.com/duckdb/duckdb/pull/10714
* Check if directory exists before removing files in regression test runner by Tmonster in https://github.com/duckdb/duckdb/pull/10859
* [Extension] Add CatalogType to the list of functions generated in `extension_entries.hpp` by Tishj in https://github.com/duckdb/duckdb/pull/10597
* Regression test build side probe side by Tmonster in https://github.com/duckdb/duckdb/pull/10585
* [Arrow] Fix issue surrounding lifetime of dictionary arrays by Tishj in https://github.com/duckdb/duckdb/pull/10610
* Fix 10745 - correctly deal with empty float columns in floating point compression routines by Mytherin in https://github.com/duckdb/duckdb/pull/10863
* [Extensions] Build fixes by carlopi in https://github.com/duckdb/duckdb/pull/10860
* Fix MSVC linking issue with workaround by samansmink in https://github.com/duckdb/duckdb/pull/10865
* Reduce memory usage & avoid spilling to disk unnecessarily for order-preserving table creation/insertion by Mytherin in https://github.com/duckdb/duckdb/pull/10862
* pb/avoid GetSchema opening a transaction by peterboncz in https://github.com/duckdb/duckdb/pull/10740
* Support dollar-quoted string-constants in the CLI by Mytherin in https://github.com/duckdb/duckdb/pull/10879
* Shell: avoid printing "Error: " prefix if the error message already has a prefix (e.g. Binder Error:, Parser Error:, etc) by Mytherin in https://github.com/duckdb/duckdb/pull/10880
* Partially fix 10751: correctly catch exceptions in sqlite3_print_duckbox by Mytherin in https://github.com/duckdb/duckdb/pull/10881
* Reset `refresh` in CompressedFile::Close() by Maxxen in https://github.com/duckdb/duckdb/pull/10882
* [CSV Reader] Lock when getting progress by pdet in https://github.com/duckdb/duckdb/pull/10884
* [CSV Sniffer] Early out if things go wrong in dialect detection by pdet in https://github.com/duckdb/duckdb/pull/10872
* [CSV Reader] Fix for skipping mix of newline delimiters by pdet in https://github.com/duckdb/duckdb/pull/10864
* Parallelize format.py script by hatvik in https://github.com/duckdb/duckdb/pull/10646
* Remove Old PSQLODBC scripts by maiadegraaf in https://github.com/duckdb/duckdb/pull/10888
* Add update_odbc_path.py to ODBC bundle by maiadegraaf in https://github.com/duckdb/duckdb/pull/10895
* Improve Wasm.yml workflow by carlopi in https://github.com/duckdb/duckdb/pull/10899
* [Parquet] Fix 10829, write correct data page offset in the presence of dictionaries by hannes in https://github.com/duckdb/duckdb/pull/10890
* Table name binding does not fail for non-existent tables in DROP TABLE statements by NiclasHaderer in https://github.com/duckdb/duckdb/pull/10893
* Fix 10889 - correctly deal with compressed vectors in struct filterpushdown of ColumnSegment::FilterSelection by Mytherin in https://github.com/duckdb/duckdb/pull/10896
* CI: Disable julia nightly for now by Mytherin in https://github.com/duckdb/duckdb/pull/10905
* CLI - add support for rendering errors/matching brackets for square ([]) and curly ({}) brackets as well by Mytherin in https://github.com/duckdb/duckdb/pull/10904
* Storage: Fix an internal exception that could be triggered when deleting many rows and checkpointing repeatedly by Mytherin in https://github.com/duckdb/duckdb/pull/10897
* LIMIT/OFFSET clean-up by Mytherin in https://github.com/duckdb/duckdb/pull/10873
* Add ARRAY to test_all_types + IO and some clients by Maxxen in https://github.com/duckdb/duckdb/pull/10850
* Use M1 (ARM) OSX runners by hannes in https://github.com/duckdb/duckdb/pull/10670
* build: restore tarball build support by Mause in https://github.com/duckdb/duckdb/pull/10900
* Fix 10902 - allow more expressions to be used with an indirection without brackets (. or [], etc) by Mytherin in https://github.com/duckdb/duckdb/pull/10909
* feat(jdbc): fixed size array support by Mause in https://github.com/duckdb/duckdb/pull/10911
* Add regexp_split_to_table macro by szarnyasg in https://github.com/duckdb/duckdb/pull/10898
* [MetaTransaction] Add lock on modifying `all_transactions` and `transactions` by Tishj in https://github.com/duckdb/duckdb/pull/10799
* Issue 10809: RANGE Hint Corrections by hawkfish in https://github.com/duckdb/duckdb/pull/10828
* Enable the progress bar (without printing) in unittests by Mytherin in https://github.com/duckdb/duckdb/pull/10908
* [Python][Dev] Fix issue in `read_csv` related to the s3 extension by Tishj in https://github.com/duckdb/duckdb/pull/10690
* Add support for the C API duckdb_query function to the Julia api by rdavis120 in https://github.com/duckdb/duckdb/pull/10886
* Fix 10501 - in LocalFileSystem::Write split writes into batches of at most 2GB by Mytherin in https://github.com/duckdb/duckdb/pull/10912
* Correctly reset data chunk in RETURNING of DELETE by Mytherin in https://github.com/duckdb/duckdb/pull/10915
* bitstring_agg had a trigger-able assertion, [duckdb-fuzzer/1414] by hannes in https://github.com/duckdb/duckdb/pull/10918
* Shell: Remove IEE754 function from CLI by Mytherin in https://github.com/duckdb/duckdb/pull/10919
* Use correct index in string to nested cast error handling by Mytherin in https://github.com/duckdb/duckdb/pull/10920
* Batch memory manager - keep track of all used memory correctly and enforce that unflushed memory is correctly set to 0 when we are finished by Mytherin in https://github.com/duckdb/duckdb/pull/10922
* Fix 9975 - correctly open (and keep open) a transaction when checking if prepared statement needs to be rebound by Mytherin in https://github.com/duckdb/duckdb/pull/10923
* CLI - Insert spaces when copy-pasting tabs by Mytherin in https://github.com/duckdb/duckdb/pull/10924
* feat: exposing ssl ca cert path to httpfs by pvaezi in https://github.com/duckdb/duckdb/pull/10704
* Centralize dynamic cast check and disable on MacOS by Mytherin in https://github.com/duckdb/duckdb/pull/10925
* Checked Numeric Casts by hannes in https://github.com/duckdb/duckdb/pull/10870
* Avoid running numeric cast checks when CRASH_ON_ASSERT is enabled by Mytherin in https://github.com/duckdb/duckdb/pull/10942
* Set duckdb_api to 'python jupyter' if in Jupyter notebook by guenp in https://github.com/duckdb/duckdb/pull/10931
* Array fuzzer issue fixes by Maxxen in https://github.com/duckdb/duckdb/pull/10944
* Fix assertion trigger in FilterCombiner::AddTransitiveFilters by Mytherin in https://github.com/duckdb/duckdb/pull/10941
* Support recursive describe queries (i.e. DESCRIBE(DESCRIBE ..)) by Mytherin in https://github.com/duckdb/duckdb/pull/10945
* Avoid throwing null pointer exception in Window Segment Tree destructor by Mytherin in https://github.com/duckdb/duckdb/pull/10937
* Fix an issue where partitions were not correctly considered in bound window expression equality by Mytherin in https://github.com/duckdb/duckdb/pull/10939
* Fix for limit % with subquery on an empty table by Mytherin in https://github.com/duckdb/duckdb/pull/10946
* Correctly visit all expressions during lateral join decorrelation, particularly with nested lateral joins by Mytherin in https://github.com/duckdb/duckdb/pull/10936
* when you add the relation, make sure you call gettableIndexes() on th… by Tmonster in https://github.com/duckdb/duckdb/pull/10949
* Internal 1428: Interval Subtract Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/10957
* Fuzzer 1445: Trap MAKE_DATE/TIME Overflows by hawkfish in https://github.com/duckdb/duckdb/pull/10958
* Python.yml: Revert to macos-latest for OSX workflow by carlopi in https://github.com/duckdb/duckdb/pull/10970
* Purge queue refactor by taniabogatsch in https://github.com/duckdb/duckdb/pull/10594
* Change time from duckdb_time to duckdb_time_struct in duckdb_time_tz_struct by Giorgi in https://github.com/duckdb/duckdb/pull/10933
* Add require block_sizes 262144 on tests reading db files by carlopi in https://github.com/duckdb/duckdb/pull/10974
* [duckdb-fuzzer/1368] - overflow in bitstring_agg on hugeint & uhugei… by hannes in https://github.com/duckdb/duckdb/pull/10971
* Fix LIST->ARRAY TRY_CAST when list sizes mismatch by Maxxen in https://github.com/duckdb/duckdb/pull/10973
* Add a micro extended benchmark. by Tmonster in https://github.com/duckdb/duckdb/pull/10943
* [Dev] Move `TemporaryFileManager` and friends out of StandardBufferManager by Tishj in https://github.com/duckdb/duckdb/pull/10938
* [ODBC] Reorganize Directory Structure by maiadegraaf in https://github.com/duckdb/duckdb/pull/10979
* Internal 1385: Window Partition Collation by hawkfish in https://github.com/duckdb/duckdb/pull/10985
* Fuzzer 1471: Trap MAKE_DATE Overflows by hawkfish in https://github.com/duckdb/duckdb/pull/10987
* Range checks for ACOS by hannes in https://github.com/duckdb/duckdb/pull/10972
* improve CheckBoundaryValues in TopN by xuke-hat in https://github.com/duckdb/duckdb/pull/10955
* CSV tests - use __TEST_DIR__ to prevent leaking file by Mytherin in https://github.com/duckdb/duckdb/pull/10991
* Autoload INET and ICU (and add back sqlite and postgres as autoloadable) by carlopi in https://github.com/duckdb/duckdb/pull/10948
* Fuzzer 1468: Window RANGE Types by hawkfish in https://github.com/duckdb/duckdb/pull/10990
* Fuzzer 1446: Quantile Hugeint Interpolation by hawkfish in https://github.com/duckdb/duckdb/pull/10983
* Override git hash / git version by carlopi in https://github.com/duckdb/duckdb/pull/10977
* [Storage] Only call FinalizeOptimisticWriter after storage merge has succeeded by Mytherin in https://github.com/duckdb/duckdb/pull/10998
* Add MetaTransaction::GetTransaction to threadsan suppressions (false positive) by Mytherin in https://github.com/duckdb/duckdb/pull/11001
* Various fixes: CMake + generated extension_entries.hpp checks by carlopi in https://github.com/duckdb/duckdb/pull/10994
* Nightly Wasm build fix by taniabogatsch in https://github.com/duckdb/duckdb/pull/10993
* Fix return null constant in array_slice and other array issues by Maxxen in https://github.com/duckdb/duckdb/pull/10992
* Add correct table bindings for window relations. by Tmonster in https://github.com/duckdb/duckdb/pull/10997
* Clean up ExecutorTask and simplify waiting for all tasks to be cancelled by Mytherin in https://github.com/duckdb/duckdb/pull/11005
* Various JSON thread sanitizer fixes by Mytherin in https://github.com/duckdb/duckdb/pull/11004
* Fix warnings in ALP and logical_insert by carlopi in https://github.com/duckdb/duckdb/pull/11008
* Check IsLoaded() before importing cached item by Tmonster in https://github.com/duckdb/duckdb/pull/11007
* Issue 10995: ICU VARCHAR TIMETZ by hawkfish in https://github.com/duckdb/duckdb/pull/11002
* Fix 10982 - only update total rows of row group collection after we finish appending to prevent other readers from attempting to initialize scans on in-progress appends by Mytherin in https://github.com/duckdb/duckdb/pull/11011
* [Nightly] Block size nightly test changes by taniabogatsch in https://github.com/duckdb/duckdb/pull/11010
* ATTACH with reserved names (temp/main) by Mytherin in https://github.com/duckdb/duckdb/pull/11020
* Fix various tests for vector_size = 2 by Mytherin in https://github.com/duckdb/duckdb/pull/11027
* [CI] Create a bigger table in interrupt test by Mytherin in https://github.com/duckdb/duckdb/pull/11025
* Issue 10995: TIMETZ DST Fix by hawkfish in https://github.com/duckdb/duckdb/pull/11024
* Fixup LinuxRelease.yml release: unittester was not invoked correctly by carlopi in https://github.com/duckdb/duckdb/pull/11022
* In DatabaseInstance destructor - destroy TaskScheduler first by Mytherin in https://github.com/duckdb/duckdb/pull/11021
* Refactor ATTACH options by taniabogatsch in https://github.com/duckdb/duckdb/pull/11016
* Fix 11033: don't reset arena allocator in between calls to streaming window expression by Mytherin in https://github.com/duckdb/duckdb/pull/11039
* Avoid checking LastModifiedTime for remote files in object cache by Mytherin in https://github.com/duckdb/duckdb/pull/11034
* [Block Size Nightly] Enable more block size nightly tests by taniabogatsch in https://github.com/duckdb/duckdb/pull/11036
* Add missing pipeline dependencies in recursive CTE by kryonix in https://github.com/duckdb/duckdb/pull/11043
* Use batch limit only when limit + offset are small constants by Mytherin in https://github.com/duckdb/duckdb/pull/11035
* Add New CSV Error for Invalid Unicode by pdet in https://github.com/duckdb/duckdb/pull/10984
* [FIX] Lambda bug in subqueries by taniabogatsch in https://github.com/duckdb/duckdb/pull/11046
* [Swift] performance optimisations by tcldr in https://github.com/duckdb/duckdb/pull/11052
* add concat_ws to spark API by nicornk in https://github.com/duckdb/duckdb/pull/11051
* feat(jdbc): expose comments via jdbc methods by Mause in https://github.com/duckdb/duckdb/pull/11031
* [CI / Tests] Disable CSV sniffer test for smaller vector sizes and reduce block-size nightly runtime by taniabogatsch in https://github.com/duckdb/duckdb/pull/11055
* [CSV Sniffer] Consider date/timestamp formats from the user when sniffing by pdet in https://github.com/duckdb/duckdb/pull/11057
* Extend the "Contents of view were altered" error with more information by Tishj in https://github.com/duckdb/duckdb/pull/11064
* [Python] Add some numeric and string functions to spark API by mariotaddeucci in https://github.com/duckdb/duckdb/pull/11067
* [ODBC] Allow multiple statements to be executed using SQLExecDirect by maiadegraaf in https://github.com/duckdb/duckdb/pull/11038
* [CSV Reader] Apply projection on over buffer values. by pdet in https://github.com/duckdb/duckdb/pull/11056
* Python: use short paths for Windows by Mytherin in https://github.com/duckdb/duckdb/pull/11068
* Fix 10752: Add support for Parquet encryption on Windows by Mytherin in https://github.com/duckdb/duckdb/pull/11069
* [Python] Code Quality - PEP8 Compliant + only relevant imports by mariotaddeucci in https://github.com/duckdb/duckdb/pull/11070
* [CI] Add patch argument to patch the extension's sources before building by krlmlr in https://github.com/duckdb/duckdb/pull/10831
* fix(jdbc): support fractional seconds in getTime by Mause in https://github.com/duckdb/duckdb/pull/10707
* Fix 11071 - correctly report progress when scanning multiple Parquet files by Mytherin in https://github.com/duckdb/duckdb/pull/11072
* Add ipv6 inet + minor fixes by carlopi in https://github.com/duckdb/duckdb/pull/11073
* Implement IPv6 support in the inet extension. by troycurtisjr in https://github.com/duckdb/duckdb/pull/10839
* [CI] Add step to verify C API enum integrity. by Tishj in https://github.com/duckdb/duckdb/pull/10664
* Issue 10995: TIMETZ DST Fix by hawkfish in https://github.com/duckdb/duckdb/pull/11079
* Check Nested Types for UTF-8 Correctness by pdet in https://github.com/duckdb/duckdb/pull/11086
* Add `scope` column to `duckdb_settings` by Tishj in https://github.com/duckdb/duckdb/pull/11017
* Partitioned write - flush batches periodically (every 500K rows) instead of only writing when all data has been gathered by Mytherin in https://github.com/duckdb/duckdb/pull/10976
* [Python] Add `extract_statements` and the Statement class by Tishj in https://github.com/duckdb/duckdb/pull/10891
* [Python] Improve performance of conversion to Numpy/Pandas for nested lists by Tishj in https://github.com/duckdb/duckdb/pull/10826
* Fix an InternalException caused by DICTIONARY_VECTOR inside `map_from_entries` by Tishj in https://github.com/duckdb/duckdb/pull/11091
* Fix 11084 - fixes an issue with the Parquet writer when writing vectors of lists with repeated list elements (as can be generated through a join) by Mytherin in https://github.com/duckdb/duckdb/pull/11094
* Add callbacks for newly added connections, and allow extensions to rebind queries as a result of planning failures by Mytherin in https://github.com/duckdb/duckdb/pull/11096
* Fuzzer 2376: INTERVAL Muliply Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/11100
* Make test/sql/copy/csv/test_limit_spinlock.test a slowtest by pdet in https://github.com/duckdb/duckdb/pull/11088
* Fix 11063 - avoid throwing exception in InClauseRewriter by Mytherin in https://github.com/duckdb/duckdb/pull/11090
* Add a hint on how to resolve lockups when using ninja. by troycurtisjr in https://github.com/duckdb/duckdb/pull/11074
* Fix LocalFileSystem::Read/Write, update location after read/write some data by yiyuanliu in https://github.com/duckdb/duckdb/pull/11105
* run_tests_one_by_one - add a default timeout of 1 hour by Mytherin in https://github.com/duckdb/duckdb/pull/11104
* [Fix] Aliases in subqueries by taniabogatsch in https://github.com/duckdb/duckdb/pull/11103
* [CSV Scan] Implement ignore_erros for Dates/Timestamps/Decimals by pdet in https://github.com/duckdb/duckdb/pull/11083
* Fix TaskScheduler deadlock on NumberOfThreads by Tishj in https://github.com/duckdb/duckdb/pull/11093
* Fix return null constant in list_resize and list_aggr by maiadegraaf in https://github.com/duckdb/duckdb/pull/11111
* Add rowsort to more tests for queries that don't have a defined order by Mytherin in https://github.com/duckdb/duckdb/pull/11110
* Do not extract filters that cannot be hyper edges (Join Order Optimizer) by Tmonster in https://github.com/duckdb/duckdb/pull/11108
* Add Dictionary vector verification by Mytherin in https://github.com/duckdb/duckdb/pull/11114
* [Dev][Python] Make `test_httpfs.py` error test more lenient by Tishj in https://github.com/duckdb/duckdb/pull/11125
* Fix `ConstantVector::Reference` for dictionary arrays by Maxxen in https://github.com/duckdb/duckdb/pull/11136
* Disable jemalloc for ARM distributions and clean up when closing DB by lnkuiper in https://github.com/duckdb/duckdb/pull/11130
* Case senstivity issue secret manager by samansmink in https://github.com/duckdb/duckdb/pull/11128
* Bump az aw vcpkg by samansmink in https://github.com/duckdb/duckdb/pull/11127
* Fix broken micro benchmarks so they can be run weekly by Tmonster in https://github.com/duckdb/duckdb/pull/11113
* Refactor OSX.yml, now inputs can be provided by carlopi in https://github.com/duckdb/duckdb/pull/11133
* Merge main into feature by Tishj in https://github.com/duckdb/duckdb/pull/11141
* Revert "Merge main into feature" by Mytherin in https://github.com/duckdb/duckdb/pull/11145
* Fix upload assets script by carlopi in https://github.com/duckdb/duckdb/pull/11144
* Bump spatial by Maxxen in https://github.com/duckdb/duckdb/pull/11132
* Fix upload assets OSX/2 by carlopi in https://github.com/duckdb/duckdb/pull/11148
* Add more vector type verification tests/settings by Mytherin in https://github.com/duckdb/duckdb/pull/11138
* Allow for customization of catalog lookup behavior for different catalog types by Mytherin in https://github.com/duckdb/duckdb/pull/11151
* [Python][Arrow] Don't deduplicate column names when outputting to Arrow by Tishj in https://github.com/duckdb/duckdb/pull/11160
* More Array and Union fixes by Maxxen in https://github.com/duckdb/duckdb/pull/11161
* Refactor upload logic (towards staged releases) by carlopi in https://github.com/duckdb/duckdb/pull/11156
* Fuzzer 2490: Generate NULL TIMESTAMPTZ by hawkfish in https://github.com/duckdb/duckdb/pull/11143
* Add folder parameter to upload logic and upload also twine artifacts by carlopi in https://github.com/duckdb/duckdb/pull/11169
* CI: Find mirror issues among all issues, not just open issues by szarnyasg in https://github.com/duckdb/duckdb/pull/11170
* Fix `TupleDataCollection` serialization of dictionary vectors containing nested data by lnkuiper in https://github.com/duckdb/duckdb/pull/11174
* Allow overriding of git describe also in scripts (via OVERRIDE_GIT_DESCRIBE environment variable) by carlopi in https://github.com/duckdb/duckdb/pull/11179
* Python staged releases: centralized staged upload by carlopi in https://github.com/duckdb/duckdb/pull/11187
* Fix RevertAppendInternal by Mytherin in https://github.com/duckdb/duckdb/pull/11177
* TwineUpload: Add awscli dependency + minor rework by carlopi in https://github.com/duckdb/duckdb/pull/11193
* Fix issue in copy constructor of ExtraDropSecretInfo by samansmink in https://github.com/duckdb/duckdb/pull/11190
* Unify CSV/JSON and Parquet Batch Writing Code - and fix memory management issues in CSV/JSON writing by Mytherin in https://github.com/duckdb/duckdb/pull/11188
* More conservative dummy list entry estimation by Maxxen in https://github.com/duckdb/duckdb/pull/11185
* retry on 500 error by samansmink in https://github.com/duckdb/duckdb/pull/11184
* Fix warning on unused utf_type by carlopi in https://github.com/duckdb/duckdb/pull/11198
* Remove outdated duckdb-node related scripts by carlopi in https://github.com/duckdb/duckdb/pull/11180
* Add StagedUpload.yml by carlopi in https://github.com/duckdb/duckdb/pull/11189
* Improving CSV Casting error message by pdet in https://github.com/duckdb/duckdb/pull/11183
* Improve conversion error message in Parquet reader by Mytherin in https://github.com/duckdb/duckdb/pull/11199
* Fix thread sanitizer issues by Mytherin in https://github.com/duckdb/duckdb/pull/11200
* Internal 1564: Range Join DISTINCT by hawkfish in https://github.com/duckdb/duckdb/pull/11205
* small fix secret autoloading, bump azure by samansmink in https://github.com/duckdb/duckdb/pull/11182
* CSV reader - suggest enabling null_padding and ignore_errors in case of missing columns by Mytherin in https://github.com/duckdb/duckdb/pull/11201
* CI: Create/label mirror issue job should list all internal issues by szarnyasg in https://github.com/duckdb/duckdb/pull/11204
* [Python] Add `IS NULL` / `IS NOT NULL` support to Expression API by cmdlineluser in https://github.com/duckdb/duckdb/pull/11175
* Remove old assertions in SegmentTree by Mytherin in https://github.com/duckdb/duckdb/pull/11208
* [lambda] Fix for list_reduce giving the wrong result by maiadegraaf in https://github.com/duckdb/duckdb/pull/11171
* [Dev] Fix various issues discovered by 11137 by Tishj in https://github.com/duckdb/duckdb/pull/11210
* [Dev] Fix py override describe by carlopi in https://github.com/duckdb/duckdb/pull/11209
* Sanitize CSV Newline identifier for writing CSV files by pdet in https://github.com/duckdb/duckdb/pull/11106
* Fix persistent secret file permissions by samansmink in https://github.com/duckdb/duckdb/pull/11172
* Retry Binding Prior To Execution by Mytherin in https://github.com/duckdb/duckdb/pull/11149
* Avoid copying LogicalType in FlatVector::SetNull. by yiyuanliu in https://github.com/duckdb/duckdb/pull/11214
* Review of CI on tags + add R extensions CI to InvokeCI.yml by carlopi in https://github.com/duckdb/duckdb/pull/11212
* Fix python and apply patches + bump extensions by carlopi in https://github.com/duckdb/duckdb/pull/11217
* Disable jemalloc on arm in Python package as well by Mytherin in https://github.com/duckdb/duckdb/pull/11218

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.10.0...v0.10.1

This release of DuckDB is named "Fusca" after the [Velvet Scooter](https://en.wikipedia.org/wiki/Velvet_scoter) native to Europe.

Note: The on-disk storage format is **backwards-compatible** with the 0.9 releases of DuckDB. For details, please see the [release announcement blog post](https://duckdb.org/2024/02/13/announcing-duckdb-0100.html).

Also note that we've dropped' the "Preview" designation with this release. DuckDB has matured quite a bit since we started creating releases back in 2019, and it is no longer appropriate.

What's Changed
* feat(jdbc): support uuid param type by Mause in https://github.com/duckdb/duckdb/pull/9164
* Bump ADBC to v0.7 by pdet in https://github.com/duckdb/duckdb/pull/9185
* Add support for parquet key-value metadata by Maxxen in https://github.com/duckdb/duckdb/pull/9126
* Default to JSON type if objects have an inconsistent structure by lnkuiper in https://github.com/duckdb/duckdb/pull/9086
* Add `schema` parameter to `read_parquet` by lnkuiper in https://github.com/duckdb/duckdb/pull/9123
* [Python] Add the ability to provide a list of files to `read_csv` by Tishj in https://github.com/duckdb/duckdb/pull/8977
* Issue 7672: TIMESTAMP_XX to DATE by hawkfish in https://github.com/duckdb/duckdb/pull/9279
* N-ary lambdas, and indexes as lambda parameters by taniabogatsch in https://github.com/duckdb/duckdb/pull/8851
* Feature: Fixed size list nested type (ARRAY) by Maxxen in https://github.com/duckdb/duckdb/pull/8983
* Fix unused warning by Maxxen in https://github.com/duckdb/duckdb/pull/9318
* Internal 215: Window EXCLUDE Functionality by hawkfish in https://github.com/duckdb/duckdb/pull/9220
* Add `json_serialize_plan`, json_serialize_sql tweaks by Maxxen in https://github.com/duckdb/duckdb/pull/9230
* Add create statement support to fuzzer by Tmonster in https://github.com/duckdb/duckdb/pull/9011
* Fix for issue 8108: Random() in lambda by maiadegraaf in https://github.com/duckdb/duckdb/pull/9353
* Fix Lambda Serialization by taniabogatsch in https://github.com/duckdb/duckdb/pull/9323
* Allow file_row_number with parquet schema option by samansmink in https://github.com/duckdb/duckdb/pull/9290
* CSV - Always run sniffer by default by pdet in https://github.com/duckdb/duckdb/pull/9250
* [Python Dev] Import items lazily by Tishj in https://github.com/duckdb/duckdb/pull/8741
* Array fixes + make validity more lazy by Maxxen in https://github.com/duckdb/duckdb/pull/9400
* Lambda performance revamp by taniabogatsch in https://github.com/duckdb/duckdb/pull/9395
* [Python] Support replacement scan on `connection.table(<name>)` method by Tishj in https://github.com/duckdb/duckdb/pull/9427
* [Dev] Fix failure in Format Check CI job by carlopi in https://github.com/duckdb/duckdb/pull/9516
* Fix parquet serialization by Maxxen in https://github.com/duckdb/duckdb/pull/9485
* Support gcs:// and r2:// URLs to read data from GCS and R2 by chrisiou in https://github.com/duckdb/duckdb/pull/9388
* Don't reset validity target count by Maxxen in https://github.com/duckdb/duckdb/pull/9565
* Merge into feature by carlopi in https://github.com/duckdb/duckdb/pull/9583
* Additional list functions by cryoEncryp in https://github.com/duckdb/duckdb/pull/8907
* [Python] Support `Optional[...]` in DuckDBPyType by Tishj in https://github.com/duckdb/duckdb/pull/8658
* C-API: support streaming arrow query by Virgiel in https://github.com/duckdb/duckdb/pull/8642
* Add ToString and Print method for JoinRelationSetManager and Fix JoinNode Print by Light-City in https://github.com/duckdb/duckdb/pull/9040
* Removed artificial `HUGEINT` minimum by nickgerrets in https://github.com/duckdb/duckdb/pull/9441
* Parquet Encryption by lnkuiper in https://github.com/duckdb/duckdb/pull/9392
* Internal 330: Quantile Performance by hawkfish in https://github.com/duckdb/duckdb/pull/9461
* CAPI: Make it possible to create enum types by alnkesq in https://github.com/duckdb/duckdb/pull/8788
* 5614 database invalidated by Tmonster in https://github.com/duckdb/duckdb/pull/9513
* Add support for proper scoping (catalog + schema) to custom types by Mytherin in https://github.com/duckdb/duckdb/pull/9622
* Internal 576: strptime strftime infinities by hawkfish in https://github.com/duckdb/duckdb/pull/9615
* ATTACH IF NOT EXISTS by Mytherin in https://github.com/duckdb/duckdb/pull/9627
* Small benchmark changes by taniabogatsch in https://github.com/duckdb/duckdb/pull/9638
* add option for keep_alive setting by samansmink in https://github.com/duckdb/duckdb/pull/9648
* Add "getenv" function to shell which can be used to read environment variables, and allow functions to be used in SET statements/PRAGMA statements by Mytherin in https://github.com/duckdb/duckdb/pull/9651
* Julia release by Mytherin in https://github.com/duckdb/duckdb/pull/9670
* In set operations ORDER BY columns refer to the first set operation in SQL - so the reference is not ambiguous by Mytherin in https://github.com/duckdb/duckdb/pull/9658
* Replace old logos by szarnyasg in https://github.com/duckdb/duckdb/pull/9674
* Fix dbgen/dsdgen when using custom catalog and schema by ywelsch in https://github.com/duckdb/duckdb/pull/9686
* [Arrow] Properly use the parent's `array.offset` in many places in the scan by Tishj in https://github.com/duckdb/duckdb/pull/9661
* Update issue template with API/extension repositories by szarnyasg in https://github.com/duckdb/duckdb/pull/9693
* [Python] Fix lossy `datetime.timedelta` to INTERVAL conversion by Tishj in https://github.com/duckdb/duckdb/pull/9688
* Issue template: Report vulnerabilities via dedicated channel by szarnyasg in https://github.com/duckdb/duckdb/pull/9711
* Fix 9601: Call correct method in duckdb_pending_execution_is_finished by Mytherin in https://github.com/duckdb/duckdb/pull/9728
* Merge Feature Into Main by Mytherin in https://github.com/duckdb/duckdb/pull/9726
* feat(c): add functions for determining statement/return types by Mause in https://github.com/duckdb/duckdb/pull/9430
* Issue 9673: ICU DST Truncation by hawkfish in https://github.com/duckdb/duckdb/pull/9705
* Deserialize header fields by carlopi in https://github.com/duckdb/duckdb/pull/9687
* fix: restore support for windows network paths by Mause in https://github.com/duckdb/duckdb/pull/9725
* Constant time attach path lookup and locking to ensure unique file handles by taniabogatsch in https://github.com/duckdb/duckdb/pull/9671
* [ART] WAL serialization, automatic checkpointing, decoupling catalog and storage, index names by taniabogatsch in https://github.com/duckdb/duckdb/pull/9339
* Fix expanding structs in queries with ORDER BY by taniabogatsch in https://github.com/duckdb/duckdb/pull/9481
* Only emit batch indices valid within the current pipeline by ywelsch in https://github.com/duckdb/duckdb/pull/9702
* Fix 9717: Correctly set null statistics of children of structs by Mytherin in https://github.com/duckdb/duckdb/pull/9733
* Fixes to warning and rendering of bar() by carlopi in https://github.com/duckdb/duckdb/pull/9734
* Don't show "blabla" as part of syntax error by mlafeldt in https://github.com/duckdb/duckdb/pull/9746
* Fix 9742: correctly catch empty ROW case in UPDATE by Mytherin in https://github.com/duckdb/duckdb/pull/9744
* Explicitly attach duckdb file type by taniabogatsch in https://github.com/duckdb/duckdb/pull/9747
* For ATTACH - Resolve extension prefix before determining the name so "sqlite:file.db" is again correctly aliased as "file" instead of "sqlite:file" by Mytherin in https://github.com/duckdb/duckdb/pull/9753
* Wasm: Add wasm_threads as a class of built extensions by carlopi in https://github.com/duckdb/duckdb/pull/9735
* Remove index joins by taniabogatsch in https://github.com/duckdb/duckdb/pull/9751
* Support EXCEPT ALL and INTERSECT ALL by hannes in https://github.com/duckdb/duckdb/pull/9636
* Add nightly deploy script by samansmink in https://github.com/duckdb/duckdb/pull/9761
* update vcpkg by samansmink in https://github.com/duckdb/duckdb/pull/9759
* Close s3 filehandle on destruction by samansmink in https://github.com/duckdb/duckdb/pull/9758
* add list of collations that are required to determine equality. by Tmonster in https://github.com/duckdb/duckdb/pull/9757
* Apply fix for patching vcpkg in extension workflow by samansmink in https://github.com/duckdb/duckdb/pull/9767
* Internal 766: SkipList Coin Toss by hawkfish in https://github.com/duckdb/duckdb/pull/9772
* Support reading large decimals into doubles in the Parquet reader by Mytherin in https://github.com/duckdb/duckdb/pull/9770
* ATTACH - Always run ExtractExtensionPrefix also if a name is provided by Mytherin in https://github.com/duckdb/duckdb/pull/9771
* Issue 9762: Interval Fractional Seconds by hawkfish in https://github.com/duckdb/duckdb/pull/9773
* Internal 716: Summarize approx_unique BIGINT by hawkfish in https://github.com/duckdb/duckdb/pull/9774
* Issue 9755: TIMESTAMP_XX DOUBLE Parts by hawkfish in https://github.com/duckdb/duckdb/pull/9769
* Add support for COPY FROM DATABASE statement by Mytherin in https://github.com/duckdb/duckdb/pull/9765
* chore: move links duckdblabs -> duckdb by dpprdan in https://github.com/duckdb/duckdb/pull/9779
* Detect FreeBSD platform by szarnyasg in https://github.com/duckdb/duckdb/pull/9782
* Extention template: Enable DuckDB-Wasm extensions by carlopi in https://github.com/duckdb/duckdb/pull/9356
* Version: add info on v0.9.2 by carlopi in https://github.com/duckdb/duckdb/pull/9788
* [JDBC] Sync all methods from a statement that interact with a query result by pdet in https://github.com/duckdb/duckdb/pull/9659
* format_bytes rework, moving from decimal multipliers to binary ones by carlopi in https://github.com/duckdb/duckdb/pull/9736
* Make FORCE CHECKPOINT abort transactions of concurrently running queries by Mytherin in https://github.com/duckdb/duckdb/pull/9790
* Bugfix/9768 by nbc in https://github.com/duckdb/duckdb/pull/9791
* Cleanup raw pointers from transaction manager by Mytherin in https://github.com/duckdb/duckdb/pull/9237
* Partially fix 4182 - write distinct stats for string dictionary columns by Mytherin in https://github.com/duckdb/duckdb/pull/9518
* fix(python): minimal changes to support compiling for python 3.12 by Mause in https://github.com/duckdb/duckdb/pull/9797
* Implement 2534 - add parquet_file_metadata function that supports scanning top-level file metadata by Mytherin in https://github.com/duckdb/duckdb/pull/9793
* Correctly clean up database path when an error is thrown in attach by Mytherin in https://github.com/duckdb/duckdb/pull/9792
* Fix cotangent(0.0): should also throw OutOfRange by carlopi in https://github.com/duckdb/duckdb/pull/9799
* Call `BindSchemaOrCatalog` when binding functions so that we can qualify functions with only a database as well by Mytherin in https://github.com/duckdb/duckdb/pull/9810
* Fix 9739 - UNIQUE USING INDEX is not supported by Mytherin in https://github.com/duckdb/duckdb/pull/9809
* Fix 8596 - use ConstructConstantFromExpression for PIVOT IN list by Mytherin in https://github.com/duckdb/duckdb/pull/9813
* Fix 8500 - if we encounter any ambiguity while binding a function with a parameter we rebind during execution by Mytherin in https://github.com/duckdb/duckdb/pull/9814
* Remove watchOS from CI tests by carlopi in https://github.com/duckdb/duckdb/pull/9820
* Fix 9262 - avoid checking exclusion/replace list when extracting table names by Mytherin in https://github.com/duckdb/duckdb/pull/9812
* LIST to VARCHAR cast fix by taniabogatsch in https://github.com/duckdb/duckdb/pull/9819
* Fix 9806 - when an overflow is detected during filter pushdown the pushdown should be halted, instead of claiming the result is always false by Mytherin in https://github.com/duckdb/duckdb/pull/9816
* Parquet: Include column key-value metadata in `parquet_metadata` function by Mytherin in https://github.com/duckdb/duckdb/pull/9798
* Add duckdb_optimizers function by Mytherin in https://github.com/duckdb/duckdb/pull/9815
* Internal 805: Summarize NULL Percentage by hawkfish in https://github.com/duckdb/duckdb/pull/9822
* Add s3a s3n protocols for httpfs by samansmink in https://github.com/duckdb/duckdb/pull/9817
* S3: Add more details to error on multipart upload by carlopi in https://github.com/duckdb/duckdb/pull/9826
* CI fixes by Mytherin in https://github.com/duckdb/duckdb/pull/9827
* [Python] Pandas Analyzer no longer trips up when the `pandas_analyze_sample` would only let it find nulls. by Tishj in https://github.com/duckdb/duckdb/pull/9811
* Create streaming result from a prepared statement. by Giorgi in https://github.com/duckdb/duckdb/pull/9802
* Clear all updates during checkpoint by Mytherin in https://github.com/duckdb/duckdb/pull/9829
* Fix 9825 - disable adding transitive filters for <> in filter combiner by Mytherin in https://github.com/duckdb/duckdb/pull/9832
* [Upsert] Do not require ON CONFLICT clause on INSERT OR REPLACE in some situations. by Tishj in https://github.com/duckdb/duckdb/pull/9730
* Issue 9631: Time/Interval Hours by hawkfish in https://github.com/duckdb/duckdb/pull/9643
* feat(c): support creating nested values in C API by Mause in https://github.com/duckdb/duckdb/pull/9438
* For EXPORT DATABASE - always write forward slashes in COPY statements by Mytherin in https://github.com/duckdb/duckdb/pull/9833
* Make checking the database path atomic again by turning db_paths into a bloom filter instead of a source of truth by Mytherin in https://github.com/duckdb/duckdb/pull/9828
* Issue 9785: Missing Interval Parts by hawkfish in https://github.com/duckdb/duckdb/pull/9796
* Issue604 Support collations during IN/NOT IN operations. by StarveZhou in https://github.com/duckdb/duckdb/pull/9724
* Reset expression before returning binder error by taniabogatsch in https://github.com/duckdb/duckdb/pull/9821
* Fix: Undefined behaviour in Bitpacking compression by nickgerrets in https://github.com/duckdb/duckdb/pull/9844
* Add ORDER BY to List_Select test by maiadegraaf in https://github.com/duckdb/duckdb/pull/9847
* CSV Sniffer Function by pdet in https://github.com/duckdb/duckdb/pull/9522
* Expand Progress API by pdet in https://github.com/duckdb/duckdb/pull/9531
* Fix 8095: Adjust the LG_PAGE parameter in jemalloc to accommodate the 64KB PAGE SIZE in aarch64 Linux systems. by vincent-chang in https://github.com/duckdb/duckdb/pull/9642
* Improve error message for index limitations by szarnyasg in https://github.com/duckdb/duckdb/pull/9862
* Fix empty box in explain analyze statement by chrisiou in https://github.com/duckdb/duckdb/pull/9860
* [Python] No longer scan `datetime.datetime.max` as infinity by Tishj in https://github.com/duckdb/duckdb/pull/9848
* Move Wasm logic to inside CMake by carlopi in https://github.com/duckdb/duckdb/pull/9830
* Fix s3fs close issue by samansmink in https://github.com/duckdb/duckdb/pull/9846
* Fix TSAN issue related to db_paths_lock by Mytherin in https://github.com/duckdb/duckdb/pull/9868
* Fix 9863 - avoid moving constants for DATE - DATE subtractions by Mytherin in https://github.com/duckdb/duckdb/pull/9874
* Disable progress bar test by Mytherin in https://github.com/duckdb/duckdb/pull/9875
* add FROM to `InitialKeywords` vector in autocomplete extension by hamilton in https://github.com/duckdb/duckdb/pull/9877
* [Optimizer] regexp_matches fix InternalException caused by NULL by Tishj in https://github.com/duckdb/duckdb/pull/9872
* [ADBC Test] Prevent segfault in test by Tishj in https://github.com/duckdb/duckdb/pull/9871
* Fix progress test by properly initialising variables by pdet in https://github.com/duckdb/duckdb/pull/9882
* Capitalize URL in httpfs extension flags by szarnyasg in https://github.com/duckdb/duckdb/pull/9884
* Mark BufferPool getters const by Y-- in https://github.com/duckdb/duckdb/pull/9885
* make BufferPool members protected by jkub in https://github.com/duckdb/duckdb/pull/9886
* Parquet: Support more physical types of time columns with time zone by hannes in https://github.com/duckdb/duckdb/pull/9895
* docs(capi): add tests for prepared statement streaming by Mause in https://github.com/duckdb/duckdb/pull/9892
* Fix deadlock in LockClients when checkpointing multiple databases, and avoid locking all clients for regular checkpoints by Mytherin in https://github.com/duckdb/duckdb/pull/9898
* Disable copy constructor of connection by Mytherin in https://github.com/duckdb/duckdb/pull/9899
* Add TableCatalogEntry to bind info by Mytherin in https://github.com/duckdb/duckdb/pull/9896
* Issue 9869: Strptime Week Start by hawkfish in https://github.com/duckdb/duckdb/pull/9890
* Fix 9867 - correctly propagate relation name in COLUMNS expression by Mytherin in https://github.com/duckdb/duckdb/pull/9904
* Fix progress bar (again) by pdet in https://github.com/duckdb/duckdb/pull/9905
* Safeguard uses of ColumnDefinition::DefaultValue by Tishj in https://github.com/duckdb/duckdb/pull/9842
* Various CI fixes by Mytherin in https://github.com/duckdb/duckdb/pull/9903
* [ADBC] Add support for windows. by pdet in https://github.com/duckdb/duckdb/pull/9357
* Fix 8905 - make duckdb_rows_changed work with both new and deprecated results by Mytherin in https://github.com/duckdb/duckdb/pull/9907
* ART duckdb versions test requires 64-bit system by taniabogatsch in https://github.com/duckdb/duckdb/pull/9906
* Internal 751: Shared Window Partition by hawkfish in https://github.com/duckdb/duckdb/pull/9839
* Issue 9887: ISO Format Directives by hawkfish in https://github.com/duckdb/duckdb/pull/9910
* Fix: string to integer cast by nickgerrets in https://github.com/duckdb/duckdb/pull/9581
* [Test] Make `test_progress_bar.cpp` output more verbose by Tishj in https://github.com/duckdb/duckdb/pull/9916
* Refactor and fix ART concurrency tests to avoid spurious CI failures by taniabogatsch in https://github.com/duckdb/duckdb/pull/9919
* Write old (empty) index_pointers to table metadata for forwards compatibility with v0.9.2 by Mytherin in https://github.com/duckdb/duckdb/pull/9923
* User agent in http header by elefeint in https://github.com/duckdb/duckdb/pull/9632
* Add support for vacuuming partial deletes during CHECKPOINT by Mytherin in https://github.com/duckdb/duckdb/pull/9931
* JDBC: DuckDBNative - Close Shared Object InputStream Properly by brianwyka in https://github.com/duckdb/duckdb/pull/9933
* Fix ATTACH of foreign key by taniabogatsch in https://github.com/duckdb/duckdb/pull/9932
* [DependencyManager] Rework internals of the DependencyManager by Tishj in https://github.com/duckdb/duckdb/pull/9715
* Internal 873: Empty Aggregate Frames by hawkfish in https://github.com/duckdb/duckdb/pull/9936
* Add support for right_semi and right_anti. PR 2 by Tmonster in https://github.com/duckdb/duckdb/pull/9897
* httpfs: fix null pointer dereference in AWSEnvironmentCredentialsProvider by mlafeldt in https://github.com/duckdb/duckdb/pull/9953
* Limit initial combine capacity in RadixPartitionedHashTable by lnkuiper in https://github.com/duckdb/duckdb/pull/9946
* [Python][Dev] Switch to using `pyproject.toml` when building and running CI. by Tishj in https://github.com/duckdb/duckdb/pull/9944
* Issue9795 min/max doesn't use collation by StarveZhou in https://github.com/duckdb/duckdb/pull/9855
* [Arrow][UDF] Properly support `side_effects` parameter for Arrow UDFs. by Tishj in https://github.com/duckdb/duckdb/pull/9959
* JDBC - Appender for Decimal by Jens-H in https://github.com/duckdb/duckdb/pull/9568
* [Fix] No duplicates in list_intersect by taniabogatsch in https://github.com/duckdb/duckdb/pull/9947
* [Python] Fix the ability to provide `pandas_analyze_sample_size` in the config dictionary to `connect` by Tishj in https://github.com/duckdb/duckdb/pull/9961
* [SQLLogicTest] Expected error message is no longer optional for `statement error` by Tishj in https://github.com/duckdb/duckdb/pull/9962
* fix offset type in list_casts and array_casts. by yiyuanliu in https://github.com/duckdb/duckdb/pull/9972
* Issue 9978: Approximate Quantile Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/9985
* fix regexp_replace bug by alitrack in https://github.com/duckdb/duckdb/pull/9938
* chore: Remove dead code by krlmlr in https://github.com/duckdb/duckdb/pull/9992
* Internal 898: Totally Ordered Intervals by hawkfish in https://github.com/duckdb/duckdb/pull/9994
* Swift Readme.md small fix by atacan in https://github.com/duckdb/duckdb/pull/9977
* Issue 9956: Alternative TIME Casts by hawkfish in https://github.com/duckdb/duckdb/pull/9984
* Make IEJoin code more clear by xuke-hat in https://github.com/duckdb/duckdb/pull/9973
* Parallel Checkpointing by Mytherin in https://github.com/duckdb/duckdb/pull/9999
* [Fix] ambiguous lambda parameters by taniabogatsch in https://github.com/duckdb/duckdb/pull/9974
* [Python][Dev] Disable test causing issues on Python3.7 by Tishj in https://github.com/duckdb/duckdb/pull/10005
* Shell: Many improvements/fixes to multi-line mode, enable multi-line mode by default by Mytherin in https://github.com/duckdb/duckdb/pull/10015
* Increase CLI history's max length to 1000 by szarnyasg in https://github.com/duckdb/duckdb/pull/10006
* [Fix] nullptr dereference when analyzing nested types by taniabogatsch in https://github.com/duckdb/duckdb/pull/10004
* Improving error message when trying to open a locked database by hannes in https://github.com/duckdb/duckdb/pull/9988
* fix(function): fix ceil function by sundy-li in https://github.com/duckdb/duckdb/pull/10014
* fix read parquet progress and read csv progress. by yiyuanliu in https://github.com/duckdb/duckdb/pull/10013
* [Python][StreamQueryResult] Fix memory ownership issues in StreamQueryResult::FetchRaw by Tishj in https://github.com/duckdb/duckdb/pull/9968
* Revert to old method of computing terminal size as new method does not play nice with lldb by Mytherin in https://github.com/duckdb/duckdb/pull/10026
* Issue 9762: Interval Fractional Parts by hawkfish in https://github.com/duckdb/duckdb/pull/9954
* Fix 9380 and 9738 by lnkuiper in https://github.com/duckdb/duckdb/pull/9990
* Fix array subquery by chenzl25 in https://github.com/duckdb/duckdb/pull/10025
* Issue 4545: Windowed Distinct Aggregates by hawkfish in https://github.com/duckdb/duckdb/pull/9754
* add rowsort to test by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10036
* The `UHUGEINT` type by nickgerrets in https://github.com/duckdb/duckdb/pull/8635
* build(python): fix python pkg version by Mause in https://github.com/duckdb/duckdb/pull/10049
* Add support for FixedPointDeclimals v0.5 by mcmcgrath13 in https://github.com/duckdb/duckdb/pull/10039
* DuckDB Secrets by samansmink in https://github.com/duckdb/duckdb/pull/10042
* Improve progress bar for Aggregation and limit threads for large data sizes by lnkuiper in https://github.com/duckdb/duckdb/pull/9989
* Internal 940: GCC Window Distinct by hawkfish in https://github.com/duckdb/duckdb/pull/10054
* Fix 10058: correctly handle unicode literals in regexp optimizer by Mytherin in https://github.com/duckdb/duckdb/pull/10061
* Update database_size.hpp by rjatwal in https://github.com/duckdb/duckdb/pull/10072
* enable overriding per-query working-memory target. by jkub in https://github.com/duckdb/duckdb/pull/9544
* fix(c): fix duckdb_create_union_type by Mause in https://github.com/duckdb/duckdb/pull/10097
* Call InitialCleanup in PendingQuery(SQLStatement) by ywelsch in https://github.com/duckdb/duckdb/pull/10083
* Removing useless variables by ywgrit in https://github.com/duckdb/duckdb/pull/10082
* [WIP] Support dot notation for JSON by ankrgyl in https://github.com/duckdb/duckdb/pull/9499
* Refactor deploy script for extensions by samansmink in https://github.com/duckdb/duckdb/pull/10063
* Add list_reduce lambda function by maiadegraaf in https://github.com/duckdb/duckdb/pull/9909
* Handle s3_endpoint that includes path by tom-s-powell in https://github.com/duckdb/duckdb/pull/9918
* Update year in license file to 2024 by szarnyasg in https://github.com/duckdb/duckdb/pull/10103
* Not including stdlib for just size_t, stddef is smaller header by hannes in https://github.com/duckdb/duckdb/pull/10104
* Bump iceberg extension version by samansmink in https://github.com/duckdb/duckdb/pull/10102
* Internal 783: ICU DatePart Serializers by hawkfish in https://github.com/duckdb/duckdb/pull/10055
* CI: Add backlink to original issue when its status changes by szarnyasg in https://github.com/duckdb/duckdb/pull/10111
* Streamline handling issues that come with PRs fixing them by szarnyasg in https://github.com/duckdb/duckdb/pull/10116
* Fix ParquetScanMaxThreads. by yiyuanliu in https://github.com/duckdb/duckdb/pull/10113
* test(python): fix blind catches by Mause in https://github.com/duckdb/duckdb/pull/10118
* CI: Create separate job for handling 'PR submitted' label by szarnyasg in https://github.com/duckdb/duckdb/pull/10119
* Lazy WAL creation by taniabogatsch in https://github.com/duckdb/duckdb/pull/10086
* [BREAKING] Modify implicit casting rules to differentiate between string literals and VARCHAR columns, and disable implicit casting to VARCHAR for many types by Mytherin in https://github.com/duckdb/duckdb/pull/10115
* For parsed expressions and table references - serialize query location, and obtain query location for more properties in transformer by Mytherin in https://github.com/duckdb/duckdb/pull/10130
* Checksum WAL entries by Mytherin in https://github.com/duckdb/duckdb/pull/10126
* Display unnamed structs as tuples instead of as structs with empty keys by Mytherin in https://github.com/duckdb/duckdb/pull/10134
* Fix 10008 - disallow parameters in DEFAULT clause, and remove unsupported SQLite code for handling parameters in shell by Mytherin in https://github.com/duckdb/duckdb/pull/10135
* Issue 10140: NULL Constant Lists by hawkfish in https://github.com/duckdb/duckdb/pull/10142
* feat(py): support python 3.12 by Mause in https://github.com/duckdb/duckdb/pull/10144
* fix create_function python stub by yiyuanliu in https://github.com/duckdb/duckdb/pull/10132
* fix(py): don't use jemalloc on windows by Mause in https://github.com/duckdb/duckdb/pull/10145
* Build manylinux_2_28 arm python wheels by samansmink in https://github.com/duckdb/duckdb/pull/10137
* Slightly improve performance of the `first` aggregate function by lnkuiper in https://github.com/duckdb/duckdb/pull/9957
* Add csv & parquet write functions and toPandas to experimental PySpark API by TomBurdge in https://github.com/duckdb/duckdb/pull/9672
* Add handling for duckdb-wasm extensions in extension-upload-from-nightly by carlopi in https://github.com/duckdb/duckdb/pull/9883
* Add some pg session function to pg_catalog by goldmedal in https://github.com/duckdb/duckdb/pull/10156
* Fix CSE elimination for window functions with bind data. Fixes 10124 by How-u-doing in https://github.com/duckdb/duckdb/pull/10152
* feat(py): Py3.12 support for Windows by Mause in https://github.com/duckdb/duckdb/pull/10159
* Py3.12 Windows nightly fixes by Mause in https://github.com/duckdb/duckdb/pull/10160
* Serialization for scalar functions nextval and currval by ywelsch in https://github.com/duckdb/duckdb/pull/10146
* Pushdown filters into semi and anti joins by Tmonster in https://github.com/duckdb/duckdb/pull/10110
* Issue 9950: Ordered Aggregate Performance by hawkfish in https://github.com/duckdb/duckdb/pull/10045
* `uhugeint_t`/`hugeint_t` operator changes by nickgerrets in https://github.com/duckdb/duckdb/pull/10117
* add regexp_escape function by chrisiou in https://github.com/duckdb/duckdb/pull/10044
* Infrastructure: truncate not always available in CI, use dd by carlopi in https://github.com/duckdb/duckdb/pull/10162
* JSON S3 optimization by samansmink in https://github.com/duckdb/duckdb/pull/10151
* Remove chunk collection from reservoir sampler by Tmonster in https://github.com/duckdb/duckdb/pull/10038
* Fix 10074 - for materialized CTEs the final result names are not influenced by the aliases. Only the names of the CTE itself are influenced by the aliases. by Mytherin in https://github.com/duckdb/duckdb/pull/10163
* [Python] Fix issue in DataFrame construction where non-deduplicated names were being used mistakenly by Tishj in https://github.com/duckdb/duckdb/pull/10165
* Fix 10141 - Correctly handle recursive and nested types that refer to other types in CREATE TYPE by Mytherin in https://github.com/duckdb/duckdb/pull/10164
* Suspend duckdb shell on Ctrl+Z by gsauthof in https://github.com/duckdb/duckdb/pull/10172
* Fix 9456 and improve Deliminator by lnkuiper in https://github.com/duckdb/duckdb/pull/9993
* Temporary Memory Manager by lnkuiper in https://github.com/duckdb/duckdb/pull/10147
* Issue 10138: Finite Temporal Helpers by hawkfish in https://github.com/duckdb/duckdb/pull/10157
* Internal 425: TIMETZ Functions by hawkfish in https://github.com/duckdb/duckdb/pull/10107
* Fix 10057: report correct error message when binding an aliased column fails by Mytherin in https://github.com/duckdb/duckdb/pull/10176
* Allow unquoted keywords to be used in DETACH by Mytherin in https://github.com/duckdb/duckdb/pull/10175
* Implement FILE_SIZE_BYTES by lnkuiper in https://github.com/duckdb/duckdb/pull/9920
* [Parquet] Fix 10148, allow reading large byte arrays into small decimals for stats by hannes in https://github.com/duckdb/duckdb/pull/10183
* Throw binder error when returning list has no columns by Tmonster in https://github.com/duckdb/duckdb/pull/10184
* Fix missing move by samansmink in https://github.com/duckdb/duckdb/pull/10186
* [BREAKING] Implicit cast rules for integer literals, and parameterized ANY for binding by Mytherin in https://github.com/duckdb/duckdb/pull/10194
* Handle 0-list maps (erroring out) and add test-case by carlopi in https://github.com/duckdb/duckdb/pull/10187
* Internal 1001: SEM Test Determinism by hawkfish in https://github.com/duckdb/duckdb/pull/10197
* More work towards Custom Indexes by Maxxen in https://github.com/duckdb/duckdb/pull/10032
* Collations are not yet properly serialized, remove enable_verification by carlopi in https://github.com/duckdb/duckdb/pull/10206
* fix: reject creation of persistent secrets when allow_persistent_secrets=false for storage backends other than local_file by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10199
* prevent physical nested loop join with multiple conditions on semi an… by Tmonster in https://github.com/duckdb/duckdb/pull/10190
* chore: add `const` to BaseSecret and KeyValueSecret copy ctrs, fix compilation error by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10182
* Allow DESCRIBE/SHOW/SUMMARIZE to be used as a subquery by Mytherin in https://github.com/duckdb/duckdb/pull/10210
* Internal 1042: 2023d Time Zones by hawkfish in https://github.com/duckdb/duckdb/pull/10215
* fix: fix a bug where free_space was incorrectly calculated when flushing partial blocks by gitccl in https://github.com/duckdb/duckdb/pull/10220
* Support more PG information_schema views by goldmedal in https://github.com/duckdb/duckdb/pull/10222
* Fix Issue 10122: wrong result in IEJoin by xuke-hat in https://github.com/duckdb/duckdb/pull/10123
* Internal 861: Aggregation Absorb API by hawkfish in https://github.com/duckdb/duckdb/pull/9971
* Better Cardinality estimates for right and left semi/anti joins by Tmonster in https://github.com/duckdb/duckdb/pull/9976
* Open JSON files lock-free if there are many by lnkuiper in https://github.com/duckdb/duckdb/pull/10188
* Bitpacking compression for the `UHUGEINT` type by nickgerrets in https://github.com/duckdb/duckdb/pull/10195
* fix: drop secret if exists on non-existing secret should not cause ex by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10217
* Replace 'embedded' with 'in-process' in the Python package description by szarnyasg in https://github.com/duckdb/duckdb/pull/10232
* In .mode json in the shell use standard float output method by Mytherin in https://github.com/duckdb/duckdb/pull/10229
* Remove duplicate columns in `PhysicalHashJoin` by lnkuiper in https://github.com/duckdb/duckdb/pull/10203
* Out-of-tree extensions for R Windows by samansmink in https://github.com/duckdb/duckdb/pull/10204
* [Python] Output unnamed structs as `tuple` in `fetchone/many/all` methods by Tishj in https://github.com/duckdb/duckdb/pull/10174
* Internal 1022: Window TIME RANGE by hawkfish in https://github.com/duckdb/duckdb/pull/10181
* fix(capi): add basic TIME_TZ support by Mause in https://github.com/duckdb/duckdb/pull/10207
* Lambda scoping by taniabogatsch in https://github.com/duckdb/duckdb/pull/10150
* Add batch functionality by osidekyle in https://github.com/duckdb/duckdb/pull/10011
* Make FILE_SIZE_BYTES test more lenient by lnkuiper in https://github.com/duckdb/duckdb/pull/10234
* Allow SQLNULL to be bound in VALUES list by Mytherin in https://github.com/duckdb/duckdb/pull/10238
* Sequence clean-up - move all sequence access through a SequenceData entry that is concurrency safe by Mytherin in https://github.com/duckdb/duckdb/pull/10236
* Remove duplicate join conditions by lnkuiper in https://github.com/duckdb/duckdb/pull/10235
* UNPIVOT - maintain original types and throw a better exception if type matching is not possible by Mytherin in https://github.com/duckdb/duckdb/pull/10240
* Correctly account for ORDER BY in ColumnLifetimeAnalyzer optimization pass by Mytherin in https://github.com/duckdb/duckdb/pull/10242
* CSV Parser 2.0 by pdet in https://github.com/duckdb/duckdb/pull/10209
* COPY - allow copy_file_name to be formatted as identifier by Mytherin in https://github.com/duckdb/duckdb/pull/10246
* remove C-style cast in compression module by gitccl in https://github.com/duckdb/duckdb/pull/10256
* Allow dsdgen to be interrupted by user by elefeint in https://github.com/duckdb/duckdb/pull/10262
* Upgrade the schema of `pg_proc` to PostgreSQL 16 by goldmedal in https://github.com/duckdb/duckdb/pull/10248
* chore: improvements to duckdb_api / user_agent by elefeint in https://github.com/duckdb/duckdb/pull/10226
* Issue 10249: Window Clause Casing by hawkfish in https://github.com/duckdb/duckdb/pull/10259
* Fix issue 10254 by lnkuiper in https://github.com/duckdb/duckdb/pull/10265
* Store unqualified macro parameters, qualify before binding by lnkuiper in https://github.com/duckdb/duckdb/pull/10266
* Fix 9384 by lnkuiper in https://github.com/duckdb/duckdb/pull/10267
* Fixes 10212: Correctly account for non-flat vectors in ListColumnData::Skip by Mytherin in https://github.com/duckdb/duckdb/pull/10268
* Enable intercepting file copy extension after binding by Maxxen in https://github.com/duckdb/duckdb/pull/10255
* [Dev][Util] Have `unittest` respect the `--start-offset` parameter when used alongside `-l` by Tishj in https://github.com/duckdb/duckdb/pull/10277
* Issue 10272: DATE + INTERVAL by hawkfish in https://github.com/duckdb/duckdb/pull/10274
* Fix 10279 - correctly use unsigned integers in delta decoding to wrap overflows as specified by the spec by Mytherin in https://github.com/duckdb/duckdb/pull/10288
* Add parse_path(), parse_dirname() and parse_filename() functions by chrisiou in https://github.com/duckdb/duckdb/pull/10208
* [Compression] ALP Compression (float/double) by lkuffo in https://github.com/duckdb/duckdb/pull/9635
* Add function for non-bias-corrected kurtosis by david-cortes in https://github.com/duckdb/duckdb/pull/9545
* fix the problem of fetching wrong data when using bitpacking compression by gitccl in https://github.com/duckdb/duckdb/pull/10291
* [Python] Compatibility with `pandas==2.2.0` by Tishj in https://github.com/duckdb/duckdb/pull/10290
* Avoid re-rendering the progress bar if the percentage has not changed by Mytherin in https://github.com/duckdb/duckdb/pull/10284
* Adapt further for z/OS by v1gnesh in https://github.com/duckdb/duckdb/pull/10297
* CSV Parser Optimizations: Pre-computed skip list. Simpler state machine transition. Flip state machine states and transitions. by pdet in https://github.com/duckdb/duckdb/pull/10258
* Explicitly cast FTS column to VARCHAR by lnkuiper in https://github.com/duckdb/duckdb/pull/10299
* Add table macro_definition to duckdb_functions() by lnkuiper in https://github.com/duckdb/duckdb/pull/10301
* [CSV Parser] Fix regression with dialect detection on quoted values. by pdet in https://github.com/duckdb/duckdb/pull/10307
* Improve bitpacking skip performance + better testing of FetchRow by samansmink in https://github.com/duckdb/duckdb/pull/10295
* Fix 10308 - allow describe/summarize as prepared statement, and fix issue with describe/summarize with ctes by Mytherin in https://github.com/duckdb/duckdb/pull/10311
* CSV Reader making null padding Parallel by default by pdet in https://github.com/duckdb/duckdb/pull/10306
* Remove spinlock for closing JSON files by lnkuiper in https://github.com/duckdb/duckdb/pull/10300
* Fix NumericLimits<hugeint_t>::Minimum() * 0 case by xuke-hat in https://github.com/duckdb/duckdb/pull/10319
* C API updates by taniabogatsch in https://github.com/duckdb/duckdb/pull/10317
* Add create_sort_key function by Mytherin in https://github.com/duckdb/duckdb/pull/10321
* SQLLogicTestRunner - Make mode command work in loops, and add mode no_output by Mytherin in https://github.com/duckdb/duckdb/pull/10328
* Escape all ASCII control characters in duckbox rendering by Mytherin in https://github.com/duckdb/duckdb/pull/10327
* Fix Failing Nightly Swift test by Tmonster in https://github.com/duckdb/duckdb/pull/10320
* Basic struct filter pushdown by Maxxen in https://github.com/duckdb/duckdb/pull/10314
* Improve the check for glob in sniff_csv function. by gabihodoroaga in https://github.com/duckdb/duckdb/pull/10243
* Add an icon to the duckdb.exe shell executable by renevdzee in https://github.com/duckdb/duckdb/pull/9656
* [Arrow] Support scanning REE (Run End Encoded) Arrow arrays by Tishj in https://github.com/duckdb/duckdb/pull/9836
* [Compression] Fix Handling of -0.0 in ALP by lkuffo in https://github.com/duckdb/duckdb/pull/10335
* Split jdbc tests by Mause in https://github.com/duckdb/duckdb/pull/10338
* Set interrupted flag after pushing an error to prevent race condition where the InterruptException could end up being the top-level error by Mytherin in https://github.com/duckdb/duckdb/pull/10337
* [Python] Fix bug in conversion of INTERVAL to `datetime.timedelta` by Tishj in https://github.com/duckdb/duckdb/pull/10339
* Update Postgres and SQLite extensions by Mytherin in https://github.com/duckdb/duckdb/pull/10310
* Limit the number of threads used to scan distinct aggregates by lnkuiper in https://github.com/duckdb/duckdb/pull/10318
* Fail Regression test when difference in cardinalities is detected by Tmonster in https://github.com/duckdb/duckdb/pull/10340
* pin ccache action version by samansmink in https://github.com/duckdb/duckdb/pull/10344
* test_all_types.py: Formatting according to black 24 by carlopi in https://github.com/duckdb/duckdb/pull/10353
* Allow NULL bytes in ART indexes by Mytherin in https://github.com/duckdb/duckdb/pull/10325
* Ensure version numbers passed to Windows .rc file are numbers by Mytherin in https://github.com/duckdb/duckdb/pull/10358
* Feature: Digit separators in numeric literals by Maxxen in https://github.com/duckdb/duckdb/pull/10343
* Autocomplete small improvements by carlopi in https://github.com/duckdb/duckdb/pull/10370
* Fix: correctly set list size of dictionary vector by gitccl in https://github.com/duckdb/duckdb/pull/10369
* Check black version in script/format.py by carlopi in https://github.com/duckdb/duckdb/pull/10354
* Change extension_directory default by carlopi in https://github.com/duckdb/duckdb/pull/10359
* feat(jdbc): setBytes by Mause in https://github.com/duckdb/duckdb/pull/10365
* [Block Size] CI test for 16KB block size and related code changes by taniabogatsch in https://github.com/duckdb/duckdb/pull/9967
* CI: Add workflow to check new issues for code formatting by szarnyasg in https://github.com/duckdb/duckdb/pull/10149
* Add additional STRUCT expansion tests by taniabogatsch in https://github.com/duckdb/duckdb/pull/10373
* Fix MATERIALIZED CTE issue 10260 by kryonix in https://github.com/duckdb/duckdb/pull/10386
* Add table_sample to TableStatistics (currently saved as nullptr) by Tmonster in https://github.com/duckdb/duckdb/pull/10378
* [Python][Dev] Use `duckdb_cursor` to avoid unintentionally sharing catalogs and registered objects by Tishj in https://github.com/duckdb/duckdb/pull/10388
* Extension metadata: detecting the platform by carlopi in https://github.com/duckdb/duckdb/pull/10329
* Add missing checkpoints in test by Maxxen in https://github.com/duckdb/duckdb/pull/10389
* Remove Python function signature (in test) by carlopi in https://github.com/duckdb/duckdb/pull/10399
* Avoid requiring expected error message on original sqlite tests by carlopi in https://github.com/duckdb/duckdb/pull/10392
* Case insensitive extensions install & load by carlopi in https://github.com/duckdb/duckdb/pull/10380
* Platform detection: Fix thread sanitizer job passing absolute path by carlopi in https://github.com/duckdb/duckdb/pull/10398
* [CSV Reader] Implicit Casting and Projection Pushdown by pdet in https://github.com/duckdb/duckdb/pull/10390
* CI: Fix workflow to check new issues for code formatting by using heredoc by szarnyasg in https://github.com/duckdb/duckdb/pull/10403
* Rework Exception Internals by Mytherin in https://github.com/duckdb/duckdb/pull/10410
* avoid copying in the for loop when there is a const by zhouzilong2020 in https://github.com/duckdb/duckdb/pull/10418
* Fix drop secret bug by samansmink in https://github.com/duckdb/duckdb/pull/10185
* Issue template: Ask about testing with the nightly build (instead of 'main') by szarnyasg in https://github.com/duckdb/duckdb/pull/10405
* [CSV Reader] Use array instead of unordered_map in projection pushdown by pdet in https://github.com/duckdb/duckdb/pull/10411
* [C-API] Add duckdb_appender_column_type by maiadegraaf in https://github.com/duckdb/duckdb/pull/10401
* Fix results for anti joins on empty tables by Tmonster in https://github.com/duckdb/duckdb/pull/10413
* Don't write Chimp/Patas files anymore & deprecate patas and chimp by Mytherin in https://github.com/duckdb/duckdb/pull/10423
* Small secret manager refactor by samansmink in https://github.com/duckdb/duckdb/pull/10421
* [Python][Dev] Skip pyarrow `test_struct_filter_pushdown` on python3.8 by Tishj in https://github.com/duckdb/duckdb/pull/10419
* Add `read_text` and `read_blob` table functions by Maxxen in https://github.com/duckdb/duckdb/pull/10376
* Rework FunctionSideEffects to FunctionStability - allow NOW() to be pushed down by Mytherin in https://github.com/duckdb/duckdb/pull/10426
* Remove dev logging on local_extension_repo creation by carlopi in https://github.com/duckdb/duckdb/pull/10424
* GH Workflows: Create CI job for Coverity scan by moshekaplan in https://github.com/duckdb/duckdb/pull/10433
* Issue 10224: FIRST ORDER BY by hawkfish in https://github.com/duckdb/duckdb/pull/10347
* Coverity Scan: Project name is DuckDB by Mytherin in https://github.com/duckdb/duckdb/pull/10447
* Multiline mode: add continuation prompt rendering by Mytherin in https://github.com/duckdb/duckdb/pull/10425
* Python: fix exception hierarchy, and also catch std::exception by Mytherin in https://github.com/duckdb/duckdb/pull/10420
* Fix bug with full file download by samansmink in https://github.com/duckdb/duckdb/pull/10429
* Add cloudflare invalidation to nightly deploy script by samansmink in https://github.com/duckdb/duckdb/pull/10430
* fix(py): fix building python binding from cmake by Mause in https://github.com/duckdb/duckdb/pull/10445
* [CSV] Bug Fix related to quoted values starting with empty values by pdet in https://github.com/duckdb/duckdb/pull/10438
* Add COMMENT ON statement by samansmink in https://github.com/duckdb/duckdb/pull/10372
* CLI: Highlighting for continuation tokens by Mytherin in https://github.com/duckdb/duckdb/pull/10453
* Issue 10224: ORDERED FIRST Rewrite by hawkfish in https://github.com/duckdb/duckdb/pull/10457
* add support for date, time, timestamp types to the Julia appender api by rdavis120 in https://github.com/duckdb/duckdb/pull/10449
* Bugfix/10441 correctly validate second colon in jdbc url parameter in Java client. by peteraisher in https://github.com/duckdb/duckdb/pull/10442
* [Execution] Parallel StreamQueryResult by Tishj in https://github.com/duckdb/duckdb/pull/10245
* [Julia][Dev] Improve README by Tishj in https://github.com/duckdb/duckdb/pull/10464
* Linenoise Code Cleanup by Mytherin in https://github.com/duckdb/duckdb/pull/10461
* [Bug Fix] [CSV Sniffing] Removing double quotes in header by pdet in https://github.com/duckdb/duckdb/pull/10462
* [Add Test] [CSV Parser] Type Detection on columns with null values by pdet in https://github.com/duckdb/duckdb/pull/10465
* Unconnected fixes by carlopi in https://github.com/duckdb/duckdb/pull/10467
* CLI: Only show continuation bytes while editing the query by Mytherin in https://github.com/duckdb/duckdb/pull/10470
* [CSV Reader] [Add Test] Quoted Values impacting the column sniffing. by pdet in https://github.com/duckdb/duckdb/pull/10472
* GzipFS - use unique_ptr instead of new/delete by Mytherin in https://github.com/duckdb/duckdb/pull/10474
* Group together index instantiation parameters into a struct, pass options map as well. by Maxxen in https://github.com/duckdb/duckdb/pull/10471
* Patch to build on Windows ARM 64 by hannes in https://github.com/duckdb/duckdb/pull/10479
* [Bug Fix] [CSV Reader] Fix to using null_padding in conjunction to one of the multifile reader options by pdet in https://github.com/duckdb/duckdb/pull/10473
* More linenoise/CLI improvements by Mytherin in https://github.com/duckdb/duckdb/pull/10480
* Add documentation example for Julia appender api. by rdavis120 in https://github.com/duckdb/duckdb/pull/10475
* Linenoise: add support for many more alt command sequences by Mytherin in https://github.com/duckdb/duckdb/pull/10493
* Use `CMAKE_CURRENT_BINARY_DIR` in CMakeLists by Flogex in https://github.com/duckdb/duckdb/pull/10484
* Avoid setting `DUCKDB_NORMALIZED_VERSION` to an empty string by SChakravorti21 in https://github.com/duckdb/duckdb/pull/10492
* Tag memory that is allocated through the buffer manager, and add `duckdb_memory()` function by Mytherin in https://github.com/duckdb/duckdb/pull/10496
* Linenoise: Disable automatic auto-complete rendering by default for now by Mytherin in https://github.com/duckdb/duckdb/pull/10498
* Fix edge case in RANGE for dates/timestamps when start=end by Mytherin in https://github.com/duckdb/duckdb/pull/10499
* Fix for auto-complete on empty words so behavior is consistent with previous DuckDB by Mytherin in https://github.com/duckdb/duckdb/pull/10502
* Nested Array Validity Fixes + `RowOperations` by Maxxen in https://github.com/duckdb/duckdb/pull/10483
* Keep file extension for temporary files by Maxxen in https://github.com/duckdb/duckdb/pull/10459
* bundle-library: Add optional Makefile target by carlopi in https://github.com/duckdb/duckdb/pull/10507
* Fix 10363 - prefer selecting entire rows over SQL value functions by Mytherin in https://github.com/duckdb/duckdb/pull/10505
* [CSV Reader] Avoid unnecessary writes to temporary file when reading in limited memory cases by pdet in https://github.com/duckdb/duckdb/pull/10509
* [Dev] Fix ASAN thread limit exceeded issue in CI by Tishj in https://github.com/duckdb/duckdb/pull/10510
* [Dev] Cancel tasks in EndQueryInternal by Tishj in https://github.com/duckdb/duckdb/pull/10512
* Export stack trace as part of extra exception info if DUCKDB_DEBUG_STACKTRACE is defined (DEBUG_STACKTRACE cmake variable) by Mytherin in https://github.com/duckdb/duckdb/pull/10514
* feat: make SecretEntry copyable so we don't lose the underlying BaseSecret obj for non-CatalogSet secrets by stephaniewang526 in https://github.com/duckdb/duckdb/pull/10518
* fix(py): json type in description field by Mause in https://github.com/duckdb/duckdb/pull/10521
* Decorrelation and parallelization of recursive and materialized CTEs by kryonix in https://github.com/duckdb/duckdb/pull/10357
* Keep track of view names and aliases separately so we can distinguish between explicitly provided aliases by the user and names returned by the view, and block usage of view if names changed by Mytherin in https://github.com/duckdb/duckdb/pull/10500
* Tweak `TemporaryMemoryManager` by lnkuiper in https://github.com/duckdb/duckdb/pull/10503
* On *nix, return `errno` in IOException extra_info by philippmd in https://github.com/duckdb/duckdb/pull/10529
* Use null cast instead of reinterpret for NULL -> JSON by lnkuiper in https://github.com/duckdb/duckdb/pull/10526
* [Python] Fix various small issues by Tishj in https://github.com/duckdb/duckdb/pull/10533
* [CSV Reader] NullPadding Tests by pdet in https://github.com/duckdb/duckdb/pull/10530
* Linenoise: make ENTER behave more similarly to other CLI clients - Ctrl+X can now be used to enter newlines at the cursor position by Mytherin in https://github.com/duckdb/duckdb/pull/10527
* [Python][Dev] Add `PYTHON_EDITABLE_BUILD` to Makefile by Tishj in https://github.com/duckdb/duckdb/pull/10488
* Reset git status before applying patches in out-of-tree build by Mytherin in https://github.com/duckdb/duckdb/pull/10534
* Fix 10486 - allow out-of-order struct casting by Mytherin in https://github.com/duckdb/duckdb/pull/10537
* Make ClientContext available during attach by ywelsch in https://github.com/duckdb/duckdb/pull/10531
* feat(jdbc): setDate by Mause in https://github.com/duckdb/duckdb/pull/10408
* Fix unused variable warning/error by carlopi in https://github.com/duckdb/duckdb/pull/10542
* [Dev]: ICU 2024a TimeZones by hawkfish in https://github.com/duckdb/duckdb/pull/10544
* Path utility fixes by Maxxen in https://github.com/duckdb/duckdb/pull/10538
* Support struct_extract and unnest for unnamed structs by Mytherin in https://github.com/duckdb/duckdb/pull/10541
* [Dev] Fix isses in parallel Checkpoint by Tishj in https://github.com/duckdb/duckdb/pull/10525
* More `TemporaryMemoryManager` tweaks by lnkuiper in https://github.com/duckdb/duckdb/pull/10549
* Add order to tests by Flogex in https://github.com/duckdb/duckdb/pull/10536
* Require at least 1 argument when calling ListZip during bind by Tmonster in https://github.com/duckdb/duckdb/pull/10485
* Benchmark runner: check for errors also if no result is specified by Mytherin in https://github.com/duckdb/duckdb/pull/10554
* [CSV Reader] [Bug Fix] Nightly CI Segfaults by pdet in https://github.com/duckdb/duckdb/pull/10551
* Fix for test/sql/copy/file_size_bytes_large.test_slow test by pdet in https://github.com/duckdb/duckdb/pull/10552
* Simplify binary-search in FindRunIndex by felipecrv in https://github.com/duckdb/duckdb/pull/10487
* Remove query profiler history and add hooks for certain events in the ClientContext by Mytherin in https://github.com/duckdb/duckdb/pull/10504
* [CSV Reader] Reset state on quoted/escaped when applying projection pushdown by pdet in https://github.com/duckdb/duckdb/pull/10557
* CommitState::WriteCatalogEntry refactor by carlopi in https://github.com/duckdb/duckdb/pull/10555
* [CSV Reader] Fix 9952 and race condition on error handler by pdet in https://github.com/duckdb/duckdb/pull/10558
* Fix a few tests failing non-deterministically with ALTERNATIVE_VERIFY=1 by carlopi in https://github.com/duckdb/duckdb/pull/10560
* unittester: if test-dir is provided avoid deleting it by carlopi in https://github.com/duckdb/duckdb/pull/10564
* Allow DuckDB execution without implicit main thread by ywelsch in https://github.com/duckdb/duckdb/pull/10548
* Fix 10528 - disallow parsing exponents for integers in strict parsing mode by Mytherin in https://github.com/duckdb/duckdb/pull/10559
* [Python] Fix issues related to handling of Python exceptions by Tishj in https://github.com/duckdb/duckdb/pull/10563
* [Python] Fix crash caused by `fetch_record_batch` by Tishj in https://github.com/duckdb/duckdb/pull/10565
* [Dev] Skip some tests on ALTERNATIVE_VERIFY by Tishj in https://github.com/duckdb/duckdb/pull/10567
* [Python][Dev] Test does not throw HTTPException by Tishj in https://github.com/duckdb/duckdb/pull/10568
* [Export] Fix export of user-defined types by Tishj in https://github.com/duckdb/duckdb/pull/10569
* Fix heap buffer overflow in VARCHAR -> TIME trycast by Tishj in https://github.com/duckdb/duckdb/pull/10571
* [Dev][CI] Add --no-exit to run_tests_one_by_one by carlopi in https://github.com/duckdb/duckdb/pull/10572
* Handle also branch with no threads enabled by carlopi in https://github.com/duckdb/duckdb/pull/10573
* Deduplicate code dealing with deduplication of column names by Tishj in https://github.com/duckdb/duckdb/pull/10532
* Bump spatial by Maxxen in https://github.com/duckdb/duckdb/pull/10580
* extension_distribution.yml: Pass DUCKDB_PLATFORM by carlopi in https://github.com/duckdb/duckdb/pull/10582
* chore(jdbc): correct datetime delta by Mause in https://github.com/duckdb/duckdb/pull/10584
* Fix Nested Array TupleData Serialization by Maxxen in https://github.com/duckdb/duckdb/pull/10513
* Do not replace filters that evaluate to always true by Tmonster in https://github.com/duckdb/duckdb/pull/10553
* [Dev] Fix triggered assertion in `SortedAggregateState::FlushChunks` caused by a small STANDARD_VECTOR_SIZE by Tishj in https://github.com/duckdb/duckdb/pull/10202
* [Tester] Add `--require <name>` by Tishj in https://github.com/duckdb/duckdb/pull/10579
* Add Support Options page by szarnyasg in https://github.com/duckdb/duckdb/pull/10598
* Use all threads to read multiple parquet files. by Tmonster in https://github.com/duckdb/duckdb/pull/10590
* [CSV-Reader] Fix on finalize for projection pushdown + nullpadding by pdet in https://github.com/duckdb/duckdb/pull/10596
* [Julia] Remove `DataFrame` from Project.toml by Tishj in https://github.com/duckdb/duckdb/pull/10605
* [CSV Reader] [Bug Fix] Make CSV Results hold the buffers they depend on by pdet in https://github.com/duckdb/duckdb/pull/10589
* minor secret manager fix by samansmink in https://github.com/duckdb/duckdb/pull/10600
* Point error message to stable link by carlopi in https://github.com/duckdb/duckdb/pull/10592
* Fix issue in aggregate HT where a task could be blocked and never be unblocked if the aggregation was interrupted early due to e.g. a limit by Mytherin in https://github.com/duckdb/duckdb/pull/10604
* Memory tracking - explicitly zero-initialize memory tracking arrays by Mytherin in https://github.com/duckdb/duckdb/pull/10606
* [Dev] Bump extensions & apply patches by carlopi in https://github.com/duckdb/duckdb/pull/10603
* Secret folder by carlopi in https://github.com/duckdb/duckdb/pull/10607
* JDBC: Skip combine test run because 10338 by hannes in https://github.com/duckdb/duckdb/pull/10616
* Fix for SQL value functions when there is an alias specified by Mytherin in https://github.com/duckdb/duckdb/pull/10611
* delay secret storage initialization by samansmink in https://github.com/duckdb/duckdb/pull/10612

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.9.2...v0.10.0

This is a bug fix release for various issues discovered after we released 0.9.1. There are no new features, just bug fixes. Database files created by DuckDB v0.9.0 or v0.9.1 can be read by DuckDB v0.9.2 (i.e. v0.9.2 is backwards compatible with both v0.9.0 and 0.9.1 and vice versa).

What's Changed
* [Dev] Fix Wasm.yml by carlopi in https://github.com/duckdb/duckdb/pull/9303
* [Dev] Fix Wasm.yml, hardcoding extension config to latest duckdb-wasm by carlopi in https://github.com/duckdb/duckdb/pull/9307
* Fix R CMD check script by Tmonster in https://github.com/duckdb/duckdb/pull/9326
* [Dev] Remove unused tools/wasm folder by carlopi in https://github.com/duckdb/duckdb/pull/9328
* [ODBC] SQLColAttribute fix by maiadegraaf in https://github.com/duckdb/duckdb/pull/9316
* Fix typo by shreeve in https://github.com/duckdb/duckdb/pull/9313
* [Dev] Trigger R.yml only only if there are changes to R.yml itself by carlopi in https://github.com/duckdb/duckdb/pull/9304
* Add thread limit to test by lnkuiper in https://github.com/duckdb/duckdb/pull/9305
* fix typing_extensions ImportError in experimental spark api by Mause in https://github.com/duckdb/duckdb/pull/9346
* HTTPFS: Move from HTTPException to base class IOException by carlopi in https://github.com/duckdb/duckdb/pull/9351
* fix for System.Data.ODBC GetSchema() by bucweat in https://github.com/duckdb/duckdb/pull/9336
* Removes some static global variables by TinyTinni in https://github.com/duckdb/duckdb/pull/9310
* Bump Julia to 0.9.1 by Mytherin in https://github.com/duckdb/duckdb/pull/9354
* [Optimizer] Fix transitive filter issue by Tishj in https://github.com/duckdb/duckdb/pull/9337
* Julia - v0.9 by Mytherin in https://github.com/duckdb/duckdb/pull/9359
* fix time_bucket_tz(day): don't truncate input to a day boundary in https://github.com/duckdb/duckdb/pull/9320
* Increase the minimum cmake version to 3.5 by taniabogatsch in https://github.com/duckdb/duckdb/pull/9364
* [PyArrow] Fix bug in timestamp pushdown by Tishj in https://github.com/duckdb/duckdb/pull/9377
* Satisfy GCC's LTO checks by krlmlr in https://github.com/duckdb/duckdb/pull/9386
* New generate_query_graph tool. by Tmonster in https://github.com/duckdb/duckdb/pull/9212
* Fix LIST aggregate prepare statement exception by taniabogatsch in https://github.com/duckdb/duckdb/pull/9370
* [Python] Throw explicit error for misuse of `execute` by Tishj in https://github.com/duckdb/duckdb/pull/9394
* update R CMD workflow to apply patches in .github/patches/duckdb-r by Tmonster in https://github.com/duckdb/duckdb/pull/9412
* [UnionVerify] Properly deal with SelectionVectors by Tishj in https://github.com/duckdb/duckdb/pull/9409
* [ART] Improve error message for zero bytes in BLOBs by taniabogatsch in https://github.com/duckdb/duckdb/pull/9415
* Enable serialization of LogicalCopyToFile by Maxxen in https://github.com/duckdb/duckdb/pull/9418
* Nits for storage and Python API comments by szarnyasg in https://github.com/duckdb/duckdb/pull/9414
* Issue 9416: Windowed Peer Functions by hawkfish in https://github.com/duckdb/duckdb/pull/9425
* [Python] Adjust `relation.df()` to output microsecond precision for `DATE` types. by Tishj in https://github.com/duckdb/duckdb/pull/9362
* [Python] Support PEP 563 by Tishj in https://github.com/duckdb/duckdb/pull/9385
* Fix 8185 - avoid infinite recursion in AddTransitiveFilters by Mytherin in https://github.com/duckdb/duckdb/pull/9440
* Fix 9447: SIGSEGV when executing read_csv() query for struct with empty VARCHAR by ryderblue in https://github.com/duckdb/duckdb/pull/9448
* Fuzzer 1294: Non-Constant NULL Format by hawkfish in https://github.com/duckdb/duckdb/pull/9450
* GitHub Actions bot: Prune search space with '--search' by szarnyasg in https://github.com/duckdb/duckdb/pull/9445
* Issue 9396: AsOf Inequality Optimisation by hawkfish in https://github.com/duckdb/duckdb/pull/9449
* Add bot for the 'Needs Documentation' label by szarnyasg in https://github.com/duckdb/duckdb/pull/9444
* Fix field ids in LogicalCopyToFile:Deserialize by Maxxen in https://github.com/duckdb/duckdb/pull/9424
* [Export Database] Produce up-to-date query for ViewCatalogEntry by Tishj in https://github.com/duckdb/duckdb/pull/9375
* include csv_rejects_table headers for amalgamation by Maxxen in https://github.com/duckdb/duckdb/pull/9454
* feat(jdbc): result streaming by Mause in https://github.com/duckdb/duckdb/pull/9437
* [Arrow] Add support for dictionary's in child arrays (i.e list of ENUM) by Tishj in https://github.com/duckdb/duckdb/pull/9331
* Detect AppleClang in cmake, add defines for `DUCKDB_MAJOR/MINOR/PATCH_VERSION` by Maxxen in https://github.com/duckdb/duckdb/pull/9457
* [Dev] Fix build for extension-upload-wasm to fix (avoiding manual copy) by carlopi in https://github.com/duckdb/duckdb/pull/9467
* Fix 9459 - remove unused qualified name parsing by Mytherin in https://github.com/duckdb/duckdb/pull/9472
* Add license to Swift client by szarnyasg in https://github.com/duckdb/duckdb/pull/9446
* Issue 8937: Window Order Collation by hawkfish in https://github.com/duckdb/duckdb/pull/9477
* adding System.Data.ODBC testing to Windows.yml CI. by bucweat in https://github.com/duckdb/duckdb/pull/9372
* fix(jdbc): support decimal arrays by Mause in https://github.com/duckdb/duckdb/pull/9489
* Needs documentation workflow: Use correct event by szarnyasg in https://github.com/duckdb/duckdb/pull/9464
* Needs documentation label: Add PR number in backlink by szarnyasg in https://github.com/duckdb/duckdb/pull/9491
* Fix 9399 by lnkuiper in https://github.com/duckdb/duckdb/pull/9411
* Enable option to skip building duckdb shell in extension distribution CI by Maxxen in https://github.com/duckdb/duckdb/pull/9483
* fix confusing variable name by SkyFan2002 in https://github.com/duckdb/duckdb/pull/9503
* Add MySQL Scanner Aliases + Enable Autoloading by Mytherin in https://github.com/duckdb/duckdb/pull/9505
* Fix 9498: Amalgamation to properly define DUCKDB_VERSION by carlopi in https://github.com/duckdb/duckdb/pull/9500
* Issue 582: Greenland TimeZone Change by hawkfish in https://github.com/duckdb/duckdb/pull/9508
* [Union] Fix issue with keyword/quoted UNION member names. by Tishj in https://github.com/duckdb/duckdb/pull/9432
* Dev: Avoid adding name_extension for extensions with DONT_LINK by carlopi in https://github.com/duckdb/duckdb/pull/9496
* Implement array-based JDBC ResultSet by elefeint in https://github.com/duckdb/duckdb/pull/8972
* Fix 9360, fix 9466: grab a lock before creating directories to fix race condition on Windows in partitioned write by Mytherin in https://github.com/duckdb/duckdb/pull/9473
* Internal 582: Remove utc_offset Dependency by hawkfish in https://github.com/duckdb/duckdb/pull/9521
* [ART] Don't allow index creation in readonly mode by taniabogatsch in https://github.com/duckdb/duckdb/pull/9527
* Remove redundant class by ccfelius in https://github.com/duckdb/duckdb/pull/9511
* Hive partitioning: Fix preprocessing of CreateDirectories by carlopi in https://github.com/duckdb/duckdb/pull/9535
* fix: check for IsRowId before accessing column name by stephaniewang526 in https://github.com/duckdb/duckdb/pull/9542
* Commit drop of index memory by taniabogatsch in https://github.com/duckdb/duckdb/pull/9540
* [Catalog] Fix locking issues + identify problem in MappingValue by Tishj in https://github.com/duckdb/duckdb/pull/9523
* JDBC - Add append method for LocalDateTime by Jens-H in https://github.com/duckdb/duckdb/pull/9435
* Use run_tests_one_by_one to fix CI by Mytherin in https://github.com/duckdb/duckdb/pull/9570
* pin run-vcpkg action version by samansmink in https://github.com/duckdb/duckdb/pull/9579
* Add rowsort to test_window_order_collate.test by carlopi in https://github.com/duckdb/duckdb/pull/9574
* Fix exploding Delim Joins by Tmonster in https://github.com/duckdb/duckdb/pull/9564
* HivePartition: Add also lock on partition_state by carlopi in https://github.com/duckdb/duckdb/pull/9576
* Fix typo by lnkuiper in https://github.com/duckdb/duckdb/pull/9587
* [C-API] fix duckdb_parameter_name declaration by suketa in https://github.com/duckdb/duckdb/pull/9566
* Fix incorrect template specialization by jhammer in https://github.com/duckdb/duckdb/pull/9529
* fix(jdbc): allow use of nested result values after close by Mause in https://github.com/duckdb/duckdb/pull/9592
* Allow pausing pipeline in NextBatch call by ywelsch in https://github.com/duckdb/duckdb/pull/9562
* Optimize performance of jaccard function by ucasfl in https://github.com/duckdb/duckdb/pull/9560
* [Python] Add missing default values to stubs of aggregate functions. by Tishj in https://github.com/duckdb/duckdb/pull/9595
* Fix symbol leakage check by Mytherin in https://github.com/duckdb/duckdb/pull/9604
* Issue: 8867 Fix: remove unused variables for logical_root. by Light-City in https://github.com/duckdb/duckdb/pull/8866
* CI: Add job for 'needs maintainer approval' PR tag by szarnyasg in https://github.com/duckdb/duckdb/pull/8853
* Ci: Fix trigger of 'needs maintainer approval' job by szarnyasg in https://github.com/duckdb/duckdb/pull/9610
* fix(jdbc): combine jar publish steps by Mause in https://github.com/duckdb/duckdb/pull/9484
* Increment postgres_scanner version by Mytherin in https://github.com/duckdb/duckdb/pull/9504
* Improve linear probing performance of `GroupedAggregateHashTable` by lnkuiper in https://github.com/duckdb/duckdb/pull/9575
* Expose InterruptState in NextBatch by ywelsch in https://github.com/duckdb/duckdb/pull/9606
* [Arrow] Support LargeString and LargeList by Tishj in https://github.com/duckdb/duckdb/pull/9471
* Issue 9589: Prefer strict TIMESTAMPs by hawkfish in https://github.com/duckdb/duckdb/pull/9600
* Fix issue with streaming query results by samansmink in https://github.com/duckdb/duckdb/pull/9619
* bump extension versions as prep for 0.9.2 by samansmink in https://github.com/duckdb/duckdb/pull/9621
* feat: duckdb_api and custom_user_agent options by elefeint in https://github.com/duckdb/duckdb/pull/9603
* Revert "fix(jdbc): combine jar publish steps" by Mause in https://github.com/duckdb/duckdb/pull/9620
* Read JSON bugfix by lnkuiper in https://github.com/duckdb/duckdb/pull/9623
* Fix 9548 - Throw a more clear error when using parameters inside of the source of a top-level PIVOT statement by Mytherin in https://github.com/duckdb/duckdb/pull/9626
* Add SQL:2016 listagg by renevdzee in https://github.com/duckdb/duckdb/pull/9613
* Bump spatial by Maxxen in https://github.com/duckdb/duckdb/pull/9633
* [ODBC] Reorganize the SQLColAttribute Tests by maiadegraaf in https://github.com/duckdb/duckdb/pull/9580
* Fix 9584: Correctly bail-out on committing appends of 0 rows, which can happen in certain edge cases by Mytherin in https://github.com/duckdb/duckdb/pull/9640
* Add log(b,x) function by hannes in https://github.com/duckdb/duckdb/pull/9637
* allow dbgen to be interrupted by user by elefeint in https://github.com/duckdb/duckdb/pull/9624
* Fix httpfs CI by samansmink in https://github.com/duckdb/duckdb/pull/9649
* fix 9232 by samansmink in https://github.com/duckdb/duckdb/pull/9647
* Shell: Set `globalDb` to `NULL` after closing database by Flogex in https://github.com/duckdb/duckdb/pull/9655
* Fix 9308 - avoid pruning plan for ANTI join with filter that is always true by Mytherin in https://github.com/duckdb/duckdb/pull/9654
* Serialize decimal quantiles by carlopi in https://github.com/duckdb/duckdb/pull/9653
* Partial revert of 9624: test seemed to cause some memory leaks in CI by carlopi in https://github.com/duckdb/duckdb/pull/9660

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.9.1...v0.9.2

This is a bug fix release for various issues discovered after we released 0.9.0. There are no new features, just bug fixes. Database files created by DuckDB v0.9.0 can be read by DuckDB v0.9.1 (i.e. v0.9.1 is backwards compatible with v0.9.0 and vice versa).


What's Changed
* Fix missing header in nightly GCC build by Maxxen in https://github.com/duckdb/duckdb/pull/9109
* Add scripts for cancelling/rerunning workflows by Mytherin in https://github.com/duckdb/duckdb/pull/9120
* Update R-CMD-Check workflow by Tmonster in https://github.com/duckdb/duckdb/pull/9128
* CSV error message fix by pdet in https://github.com/duckdb/duckdb/pull/9132
* Throw SerializationException instead of InternalException by Maxxen in https://github.com/duckdb/duckdb/pull/9130
* Radix HT: Get max_threads from config instead of system by lnkuiper in https://github.com/duckdb/duckdb/pull/9129
* Wrapping CSV State Machine by pdet in https://github.com/duckdb/duckdb/pull/9131
* [CSV] Properly skip new lines mid csv file by pdet in https://github.com/duckdb/duckdb/pull/9139
* [PythonDev] Rework `duckdb_cursor` fixture in pytest by Tishj in https://github.com/duckdb/duckdb/pull/9140
* Update logo in README by szarnyasg in https://github.com/duckdb/duckdb/pull/9147
* Bump uncovered lines by carlopi in https://github.com/duckdb/duckdb/pull/9102
* Python: Uniform DuckDB SQL version to v0.X.Y by carlopi in https://github.com/duckdb/duckdb/pull/9095
* [PythonDev] Don't dereference None when creating pandas dataframe by Tishj in https://github.com/duckdb/duckdb/pull/9127
* fix: fix some typo by shizuocheng in https://github.com/duckdb/duckdb/pull/9156
* [Swift] fix row count and index mapping by tcldr in https://github.com/duckdb/duckdb/pull/9149
* Run Single-Threaded CSV Parser when only one thread is available by pdet in https://github.com/duckdb/duckdb/pull/9148
* [ODBC] Add missing fields to SQLColAttribute by maiadegraaf in https://github.com/duckdb/duckdb/pull/9146
* Merge main into feature by Mause in https://github.com/duckdb/duckdb/pull/9163
* [Python] Pyarrow integer filter pushdown bug fix by Tishj in https://github.com/duckdb/duckdb/pull/9155
* [CSV] Be sure to run header detection even if a header is defined by the user by pdet in https://github.com/duckdb/duckdb/pull/9168
* Avoid (Try)AutoLoad logic if extension already loaded by carlopi in https://github.com/duckdb/duckdb/pull/9177
* Fix fuzzer exclusion by Tmonster in https://github.com/duckdb/duckdb/pull/9103
* [PythonDev] Fix duckdb-internal/418 by Tishj in https://github.com/duckdb/duckdb/pull/9184
* chore: skip arrow union tests on pyarrow<11 by gforsyth in https://github.com/duckdb/duckdb/pull/9186
* Fix issue related to `map()` and Dictionary Vectors. by Tishj in https://github.com/duckdb/duckdb/pull/9046
* Issue 9183: Arbitrary ASOF Conditions by hawkfish in https://github.com/duckdb/duckdb/pull/9188
* Add instructions for jdk installed via brew by nicku33 in https://github.com/duckdb/duckdb/pull/9192
* Fix nits in API comments by szarnyasg in https://github.com/duckdb/duckdb/pull/8768
* Internal 445: Destruct All Aggregates by hawkfish in https://github.com/duckdb/duckdb/pull/9202
* Don't initialize data chunk in ExpressionExecutor if it's just a BoundReferenceExpression by lnkuiper in https://github.com/duckdb/duckdb/pull/9213
* [ODBC] Add info to fatal error in compiler by maiadegraaf in https://github.com/duckdb/duckdb/pull/9218
* Rewrite filter remover arrow test by lnkuiper in https://github.com/duckdb/duckdb/pull/9217
* [ODBC] Add Unittests to Windows CI Run by maiadegraaf in https://github.com/duckdb/duckdb/pull/9216
* Add missing parameter defaults for `create_function` in `duckdb-stubs` by earwig in https://github.com/duckdb/duckdb/pull/9224
* Several fixes related to vector_size=2 nightly build by pdet in https://github.com/duckdb/duckdb/pull/9166
* Avoid keeping read-only transactions stored in `old_transactions` by Mytherin in https://github.com/duckdb/duckdb/pull/9236
* Fix reusable workflow for OOTE building by samansmink in https://github.com/duckdb/duckdb/pull/9229
* [Parquet] Implement reading byte stream split encoded data by adamreeve in https://github.com/duckdb/duckdb/pull/9240
* Bug report template: ask for imports to be included by szarnyasg in https://github.com/duckdb/duckdb/pull/9197
* Remove bundled sqlite, does not seem to be used anywhere by hannes in https://github.com/duckdb/duckdb/pull/9245
* update azure extension by samansmink in https://github.com/duckdb/duckdb/pull/9243
* Fix 8413: Avoid pushing collations to non-varchar columns, and cleanup around PushCollation by Mytherin in https://github.com/duckdb/duckdb/pull/9242
* Fix 8624 - allow changing of schema and search_path parameters even if configuration is locked by Mytherin in https://github.com/duckdb/duckdb/pull/9244
* [ODBC] SQLColAttribte: More tests by maiadegraaf in https://github.com/duckdb/duckdb/pull/9200
* Fix for creating ephemeral schema on readonly by nicku33 in https://github.com/duckdb/duckdb/pull/9261
* Wasm extensions Makefile changes by carlopi in https://github.com/duckdb/duckdb/pull/9269
* Fix 9241 - avoid pushing filters through DISTINCT ON by Mytherin in https://github.com/duckdb/duckdb/pull/9270
* Fix 7880 part 1 - rebind expression during alias replacement instead of copying the already bound expression by Mytherin in https://github.com/duckdb/duckdb/pull/9274
* ICU: Remove unused variables by carlopi in https://github.com/duckdb/duckdb/pull/9275
* Fix 9252 - avoid overwriting start value as part of INCREMENT BY in sequence creation by Mytherin in https://github.com/duckdb/duckdb/pull/9272
* [Python] Add back `value_counts` by Tishj in https://github.com/duckdb/duckdb/pull/9278
* [SparkAPI] Add `read.json` and `read.parquet` + some unhappy path testing by Tishj in https://github.com/duckdb/duckdb/pull/9276
* [Arrow][Dev] Make each produced Array own its own memory. by Tishj in https://github.com/duckdb/duckdb/pull/9254
* Properly register all JSON cast functions so the binder can disambiguate by lnkuiper in https://github.com/duckdb/duckdb/pull/9209
* [Dev] Fix `test_map_vector_types.test` by Tishj in https://github.com/duckdb/duckdb/pull/9277
* Issue 9280: Parquet TIME_TZ Reading by hawkfish in https://github.com/duckdb/duckdb/pull/9283
* Update iceberg extension by samansmink in https://github.com/duckdb/duckdb/pull/9284
* Fix prepare statement issue by taniabogatsch in https://github.com/duckdb/duckdb/pull/9288
* [Arrow] Fix issue with scanning of UNION of STRUCTS by Tishj in https://github.com/duckdb/duckdb/pull/9291
* Remove nodejs client by hannes in https://github.com/duckdb/duckdb/pull/9287
* Clear cached buffers before emitting next chunk by pdet in https://github.com/duckdb/duckdb/pull/9295
* [Dev] Restore _extension_client_tests.yml syntax by carlopi in https://github.com/duckdb/duckdb/pull/9300
* Fix MacOS exception catching by carlopi in https://github.com/duckdb/duckdb/pull/9286
* Unify replacement scan filename parsing by lnkuiper in https://github.com/duckdb/duckdb/pull/9273
* Extension install fixes by carlopi in https://github.com/duckdb/duckdb/pull/9294
* Re-add windows extension builds for R by hannes in https://github.com/duckdb/duckdb/pull/9302

This preview release of DuckDB is named "Undulata" after the aptly named [Yellow-billed duck](https://en.wikipedia.org/wiki/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](https://duckdb.org/docs/sql/statements/export) for details.

What's Changed
* [Dev] Merge master into feature by Tishj in https://github.com/duckdb/duckdb/pull/7535
* Issue 7563: make_timestamp[tz](microseconds) 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] Add support for named parameters in prepared statements by Tishj in https://github.com/duckdb/duckdb/pull/7113
* Fix issue 8422: date_part('isodow', timestamptz) to return correct iso day numbers. by robert-manchester in https://github.com/duckdb/duckdb/pull/8432
* remove static loading extensions for node/python/r dev builds by samansmink in https://github.com/duckdb/duckdb/pull/8473
* Add geomean macro by szarnyasg in https://github.com/duckdb/duckdb/pull/8471
* Bump duckdb-wasm to 9f2f87b by carlopi in https://github.com/duckdb/duckdb/pull/8470
* CI: Change clang-format version to 11 by maiadegraaf in https://github.com/duckdb/duckdb/pull/8474
* Add list_reverse function by maiadegraaf in https://github.com/duckdb/duckdb/pull/8477
* R: dbplyr_fill0() no longer exists by krlmlr in https://github.com/duckdb/duckdb/pull/8480
* General ART improvements and memory pressure reduction by taniabogatsch in https://github.com/duckdb/duckdb/pull/8437
* [Arrow (Dev)] Refactor arrow scan internals by Tishj in https://github.com/duckdb/duckdb/pull/8430
* Expose lto and llvm folder compilation flags by carlopi in https://github.com/duckdb/duckdb/pull/8357
* Documenting R release process by hannes in https://github.com/duckdb/duckdb/pull/8081
* Remove assertion on empty linked list by taniabogatsch in https://github.com/duckdb/duckdb/pull/8502
* Fix total_cardinality is zero will result in undefined-behavior by zhouliqi in https://github.com/duckdb/duckdb/pull/8506
* Issue 8512: Negative Time Intervals by hawkfish in https://github.com/duckdb/duckdb/pull/8515
* Rework Metadata Storage by Mytherin in https://github.com/duckdb/duckdb/pull/8513
* Issue 8086: Window Work Stealing by hawkfish in https://github.com/duckdb/duckdb/pull/8491
* Add android ifdefs by Mause in https://github.com/duckdb/duckdb/pull/8526
* Fuzzer 590: MAKE_TIMESTAMPTZ Extreme Paranoia by hawkfish in https://github.com/duckdb/duckdb/pull/8514
* R: Update duckplyr tests by krlmlr in https://github.com/duckdb/duckdb/pull/8482
* R: Add test for disconnect behavior by krlmlr in https://github.com/duckdb/duckdb/pull/8483
* [ADBC] Addings more tests and small fixes. by pdet in https://github.com/duckdb/duckdb/pull/8478
* Refactoring the Join Order Optimizer by Tmonster in https://github.com/duckdb/duckdb/pull/8468
* [Dev] Fix CI failure caused by 7113 by Tishj in https://github.com/duckdb/duckdb/pull/8533
* fix query hang in Jetbrains programs (IntelliJ, DataGrip, etc) by Mause in https://github.com/duckdb/duckdb/pull/8511
* Add PendingExecutionResult::ALL_TASKS_BLOCKED by samansmink in https://github.com/duckdb/duckdb/pull/8497
* [R] Fix retention of time component of TIMESTAMPS when converting time zones 8547 by ateucher in https://github.com/duckdb/duckdb/pull/8548
* Add "field ID's" to new serialization by Maxxen in https://github.com/duckdb/duckdb/pull/8536
* Fix 3170: Get old value when update on rows with big row_id by zippond in https://github.com/duckdb/duckdb/pull/8520
* Silence warnings on thread sanitizer for CanHave[No]Null by carlopi in https://github.com/duckdb/duckdb/pull/8552
* Issue 6027: Explicit ROW_GROUP_SIZE no longer breaks IMPORT/EXPORT round-trip by jmeulemans in https://github.com/duckdb/duckdb/pull/8559
* fix: remove unused ForwardRef import by Mause in https://github.com/duckdb/duckdb/pull/8543
* [Python] Enable use of CUBE / ROLLUP in `groups` parameter of DuckDBPyRelation aggregate methods. by Tishj in https://github.com/duckdb/duckdb/pull/8510
* Adding explicit errors for cascade/set null/set default by hannes in https://github.com/duckdb/duckdb/pull/8572
* Throw exception on type error in JsonDeserializer by Maxxen in https://github.com/duckdb/duckdb/pull/8291
* Remove packaging for Python 3.6 by carlopi in https://github.com/duckdb/duckdb/pull/8577
* Fix gcc weird behaviour around template deduction (8533) by carlopi in https://github.com/duckdb/duckdb/pull/8576
* Fix: Remove undefined behaviour in frame-of-reference bitpacking by nickgerrets in https://github.com/duckdb/duckdb/pull/8569
* Issue 8461: Null Hive Typing by hawkfish in https://github.com/duckdb/duckdb/pull/8540
* [Python] Don't clog the `tools/pythonpkg/duckdb` folder on build by Tishj in https://github.com/duckdb/duckdb/pull/8534
* Add Mold Linker Support for Linux by douenergy in https://github.com/duckdb/duckdb/pull/8517
* Fuzzer 572: Lead Lag Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/8538
* Fuzzer 668: Window List NULLs by hawkfish in https://github.com/duckdb/duckdb/pull/8557
* Update R readme to add instructions on how to load the httpfs extension by Tmonster in https://github.com/duckdb/duckdb/pull/8567
* [ADBC] Finish ADBC spec compliance by Tishj in https://github.com/duckdb/duckdb/pull/8417
* fix(8412): forbid topn optimization when there are scalar subquery in limit or offset clause by Reminiscent in https://github.com/duckdb/duckdb/pull/8519
* R: Update duckplyr tests by krlmlr in https://github.com/duckdb/duckdb/pull/8608
* R: Allow microsecond precision for timestamps by krlmlr in https://github.com/duckdb/duckdb/pull/8597
* R: Fix core dump when failing to evaluate ALTREP query by krlmlr in https://github.com/duckdb/duckdb/pull/8600
* Fuzzer 583: Orders Nary Aggregates by hawkfish in https://github.com/duckdb/duckdb/pull/8598
* Add register functions for AggregateFunction used by extensions by ttanay in https://github.com/duckdb/duckdb/pull/8607
* R: Full support of lists and structs in R by krlmlr in https://github.com/duckdb/duckdb/pull/8503
* R: Avoid leaking format specifiers in `cpp11::stop()` calls by krlmlr in https://github.com/duckdb/duckdb/pull/8614
* [R] Add ADBC integration with the adbcdrivermanager package by paleolimbot in https://github.com/duckdb/duckdb/pull/8172
* fix(8441): some filter expressions can not be pushed down by Reminiscent in https://github.com/duckdb/duckdb/pull/8532
* format.py: add checks (and suggestion) to install needed tools by carlopi in https://github.com/duckdb/duckdb/pull/8629
* R: Fix warning on mismatched integer comparison by carlopi in https://github.com/duckdb/duckdb/pull/8626
* Rename branch from master to main by hannes in https://github.com/duckdb/duckdb/pull/8639
* Second round of branch renames by hannes in https://github.com/duckdb/duckdb/pull/8643
* Fix: Unimplemented type for TryAddOperator by nickgerrets in https://github.com/duckdb/duckdb/pull/8566
* typo by hannes in https://github.com/duckdb/duckdb/pull/8644
* Wrap ALTREP methods with BEGIN_CPP11 and END_CPP11 by krlmlr in https://github.com/duckdb/duckdb/pull/8647
* Fix test_csv_httpfs.test_slow by carlopi in https://github.com/duckdb/duckdb/pull/8637
* [Python] Add support for `datetime64` columns with a time-unit that is not `ns` by Tishj in https://github.com/duckdb/duckdb/pull/8620
* PR3 for zOS by v1gnesh in https://github.com/duckdb/duckdb/pull/8625
* [Dev] Add explicit expected error for `test/sql/storage/multiple_clients_checkpoint_pending_updates.test` by Tishj in https://github.com/duckdb/duckdb/pull/8654
* Extension sha256: Avoid full copies by updating sha context by carlopi in https://github.com/duckdb/duckdb/pull/8636
* Expose window functions in the Python API by jarandaf in https://github.com/duckdb/duckdb/pull/8568
* Issue 2827: Julian Day Parts by hawkfish in https://github.com/duckdb/duckdb/pull/8523
* Issue 8659: Non-Invertible Casts by hawkfish in https://github.com/duckdb/duckdb/pull/8661
* Fix CI failure with test/sql/copy/s3/glob_s3_paging.test_slow by samansmink in https://github.com/duckdb/duckdb/pull/8670
* ADBC: Use new(std::nothrow) + check on null by carlopi in https://github.com/duckdb/duckdb/pull/8676
* Issue 8674: Interrupt Work Stealing by hawkfish in https://github.com/duckdb/duckdb/pull/8679
* Add fix for substrait CI failure by pdet in https://github.com/duckdb/duckdb/pull/8545
* fix cpp11 issue in r api by hannes in https://github.com/duckdb/duckdb/pull/8664
* [Dev] Fix sporadically failing test `window-rows-overflow.test` by Tishj in https://github.com/duckdb/duckdb/pull/8678
* [Dev] Use our parquet writer in `test_filter_pushdown_2145 ` test instead by Tishj in https://github.com/duckdb/duckdb/pull/8694
* fix: typo in comment by SkyFan2002 in https://github.com/duckdb/duckdb/pull/8696
* CI: skip test/fuzzer/sqlsmith/window-rows-overflow.test by carlopi in https://github.com/duckdb/duckdb/pull/8693
* Makefile extension config by carlopi in https://github.com/duckdb/duckdb/pull/8692
* Remove deprecated experimental_parallel_csv configuration option by szarnyasg in https://github.com/duckdb/duckdb/pull/8669
* [Dev] Fix CI failure related to pandas and timezones by Tishj in https://github.com/duckdb/duckdb/pull/8665
* Fix for 3789, separate updates into storage backends individually by hannes in https://github.com/duckdb/duckdb/pull/8618
* [Internals] Fix key/value name in MAP produced by `map_entries` by Tishj in https://github.com/duckdb/duckdb/pull/8460
* C-API: Fix `duckdb_arrow_scan` API by k-anshul in https://github.com/duckdb/duckdb/pull/8653
* [PythonDev] Fix failing `test_statement_bind.py` test by Tishj in https://github.com/duckdb/duckdb/pull/8711
* Issue 3409: Time TZ Storage by hawkfish in https://github.com/duckdb/duckdb/pull/8650
* [Parquet] Fall back to VARCHAR for unsupported types in EXPORT DATABASE by Tishj in https://github.com/duckdb/duckdb/pull/8710
* [Parquet reader] support reading small decimals with DBP encoding by samansmink in https://github.com/duckdb/duckdb/pull/8715
* When projecting to the R client, use `GetName` instead of `ToString()` by Tmonster in https://github.com/duckdb/duckdb/pull/8717
* Custom indexes: Step 0 by Maxxen in https://github.com/duckdb/duckdb/pull/8367
* Add reusable workflows for out-of-tree extensions by samansmink in https://github.com/duckdb/duckdb/pull/8714
* feat(jdbc): read struct, map, and unions by Mause in https://github.com/duckdb/duckdb/pull/8686
* Slight refactor to silence a gcc13 warning by hannes in https://github.com/duckdb/duckdb/pull/8727
* Change parquet_write_memory_limit.test_slow to not preserve order by lnkuiper in https://github.com/duckdb/duckdb/pull/8746
* [Python] Pandas 2.1.0 update by Tishj in https://github.com/duckdb/duckdb/pull/8738
* bump codecov by Maxxen in https://github.com/duckdb/duckdb/pull/8751
* Order Describe table with column id by pdet in https://github.com/duckdb/duckdb/pull/8729
* CSV Read: move buffer initialisation to thread local by pdet in https://github.com/duckdb/duckdb/pull/8672
* Distinct/order modifier column deduplication by lnkuiper in https://github.com/duckdb/duckdb/pull/8748
* Autoloading mechanism for extensions by samansmink in https://github.com/duckdb/duckdb/pull/8732
* duckspark, implement createOrReplaceTempView by hannes in https://github.com/duckdb/duckdb/pull/8759
* Extension load tests: fix-up b014b6919 by carlopi in https://github.com/duckdb/duckdb/pull/8775
* Apply patches and bump extensions by carlopi in https://github.com/duckdb/duckdb/pull/8765
* Fuzzer 936: Sort Key Exceptions by hawkfish in https://github.com/duckdb/duckdb/pull/8773
* CSV Sniffer - State Machine by pdet in https://github.com/duckdb/duckdb/pull/8253
* [Dev] Untangle some really obfuscated code in `ReorderTableEntries` by Tishj in https://github.com/duckdb/duckdb/pull/8707
* Use manylinux_2_24 image for Linux aarch64 Python builds by Mause in https://github.com/duckdb/duckdb/pull/8770
* Radix Partitioned Hash Table Rework by lnkuiper in https://github.com/duckdb/duckdb/pull/8475
* Issue 7809: Parallel Partition Sorting by hawkfish in https://github.com/duckdb/duckdb/pull/8593
* Add the ability to access file_path in FileOpener by stephaniewang526 in https://github.com/duckdb/duckdb/pull/8484
* CAPI: Make it possible to create struct types by alnkesq in https://github.com/duckdb/duckdb/pull/8455
* Serialization pt 3: mega follow-up by Maxxen in https://github.com/duckdb/duckdb/pull/8752
* Remove patches and bump dependecies (aws & iceberg) by carlopi in https://github.com/duckdb/duckdb/pull/8777
* [Python] DuckDB -> Pandas | NULL -> `str` becomes None instead of 'NaN' by Tishj in https://github.com/duckdb/duckdb/pull/8745
* [PythonDev] Add timeout to `test_multithread.py` by Tishj in https://github.com/duckdb/duckdb/pull/8747
* Bump uncovered_files.csv by carlopi in https://github.com/duckdb/duckdb/pull/8790
* Avoid rounding down buffer block sizes to uint32_t by lnkuiper in https://github.com/duckdb/duckdb/pull/8785
* Duckdb wasm loadable fixes by carlopi in https://github.com/duckdb/duckdb/pull/8766
* [Dev] Handle SKIP_EXTENSIONS as early return in duckdb_extension_load by carlopi in https://github.com/duckdb/duckdb/pull/8781
* Fix R ci by Tmonster in https://github.com/duckdb/duckdb/pull/8783
* Switching to twine token and remove cleanup job by hannes in https://github.com/duckdb/duckdb/pull/8792
* Moving R client out of main source tree by hannes in https://github.com/duckdb/duckdb/pull/8793
* Re-add pypi-cleanup script and use pypi-cleanup package for deleting dev packages by Mytherin in https://github.com/duckdb/duckdb/pull/8795
* Fix 8797: Fix off-by-one in varchar -> list conversion code causing out-of-bounds access by Mytherin in https://github.com/duckdb/duckdb/pull/8799
* Add "ends_with" as an alias of "suffix" by holdenmatt in https://github.com/duckdb/duckdb/pull/8807
* [Dev] Pass explicitly USE_MERGED_VCPKG_MANIFEST by carlopi in https://github.com/duckdb/duckdb/pull/8806
* 7412 add sha256 scalar function by jdnvn in https://github.com/duckdb/duckdb/pull/8723
* Extension docs by carlopi in https://github.com/duckdb/duckdb/pull/8784
* Fix Python Release Clean-up: need to install requests module by Mytherin in https://github.com/duckdb/duckdb/pull/8811
* Very minor fixes of CI problems by carlopi in https://github.com/duckdb/duckdb/pull/8809
* Fix "Too many open files" issues by lnkuiper in https://github.com/duckdb/duckdb/pull/8812
* Add `list_cosine_similarity`, `list_distance`, `list_inner_product` by Maxxen in https://github.com/duckdb/duckdb/pull/8750
* Towards stable storage of indexes and the ART by taniabogatsch in https://github.com/duckdb/duckdb/pull/8703
* JSON bugfixes by lnkuiper in https://github.com/duckdb/duckdb/pull/8810
* Issue template: Ask contributors to avoid using screenshots in issue reports by szarnyasg in https://github.com/duckdb/duckdb/pull/8829
* [PythonDev] Remove version lock on `adbc_driver_manager` by Tishj in https://github.com/duckdb/duckdb/pull/8725
* Internal 215: Serial Unordered Scans by hawkfish in https://github.com/duckdb/duckdb/pull/8824
* [Generated Column] Return stringified generated expression in `duckdb_columns` by Tishj in https://github.com/duckdb/duckdb/pull/8835
* Extension API: Allow autoloading of extensions dependencies & use it for duckdb_aws by carlopi in https://github.com/duckdb/duckdb/pull/8839
* Remove references to duckdb_query_graph by szarnyasg in https://github.com/duckdb/duckdb/pull/8826
* DuckDB-Wasm fixes related to (auto)loadable extensions by carlopi in https://github.com/duckdb/duckdb/pull/8827
* Revert "Use manylinux_2_24 image for Linux aarch64 Python builds" by Mause in https://github.com/duckdb/duckdb/pull/8849
* fix(nodejs): thread safety between node instances in single process by Mause in https://github.com/duckdb/duckdb/pull/8862
* fix: remove TODO's in Node docs by Mause in https://github.com/duckdb/duckdb/pull/8861
* Switch over to new Serialization Framework by Mytherin in https://github.com/duckdb/duckdb/pull/8863
* Fixes to error messages: An error occurred ... by carlopi in https://github.com/duckdb/duckdb/pull/8855
* Attempt at fixing OSX Extensions Release nightly build failures by carlopi in https://github.com/duckdb/duckdb/pull/8847
* Internal 164: Single Partition Sorting by hawkfish in https://github.com/duckdb/duckdb/pull/8791
* [Python] Add `Expression` class by Tishj in https://github.com/duckdb/duckdb/pull/8469
* Partial Blocks for Index Serialization by taniabogatsch in https://github.com/duckdb/duckdb/pull/8825
* Update create_package.py for new extension defines by Mause in https://github.com/duckdb/duckdb/pull/8870
* Wasm extension signing by carlopi in https://github.com/duckdb/duckdb/pull/8881
* DuckDB-Wasm workflow: Fix syntax by carlopi in https://github.com/duckdb/duckdb/pull/8883
* Expose SeekPosition in HTTPFS by Maxxen in https://github.com/duckdb/duckdb/pull/8876
* DuckDB-Wasm workflow: fixes by carlopi in https://github.com/duckdb/duckdb/pull/8885
* DuckDB-Wasm workflow: Pass on token and secret by carlopi in https://github.com/duckdb/duckdb/pull/8886
* Use lock when accessing the http metadata cache by pdet in https://github.com/duckdb/duckdb/pull/8882
* DuckDB-Wasm workflow: Uncomment line by carlopi in https://github.com/duckdb/duckdb/pull/8887
* Rework Storage of Deletions - Allow for lazy loading and incremental re-writing of deletions by Mytherin in https://github.com/duckdb/duckdb/pull/8869
* Fix for 8440 by pdet in https://github.com/duckdb/duckdb/pull/8879
* Issue 8316: Time Cast Statistics by hawkfish in https://github.com/duckdb/duckdb/pull/8888
* Sqlite commands fixes by Tmonster in https://github.com/duckdb/duckdb/pull/8848
* Fuzzer 838: Julian DATE Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/8677
* Remove support for NodeJS 10 by Mause in https://github.com/duckdb/duckdb/pull/8872
* DuckDB-Wasm workflow: Add credentials explicitly by carlopi in https://github.com/duckdb/duckdb/pull/8889
* fix some nodejs tests in some envs by jraymakers in https://github.com/duckdb/duckdb/pull/8774
* Fix link in extension/README.md by isaacbrodsky in https://github.com/duckdb/duckdb/pull/8904
* [Fix] Verification that CSV File exceed line sizes. by pdet in https://github.com/duckdb/duckdb/pull/8892
* Add R CMD Check workflow back for duckdb src PRs by Tmonster in https://github.com/duckdb/duckdb/pull/8845
* DuckDB-Wasm workflow: moving to official repo by carlopi in https://github.com/duckdb/duckdb/pull/8918
* Fix 8895: Reading .csv.zst files depends on parquet extension (check… by carlopi in https://github.com/duckdb/duckdb/pull/8906
* ART fixes - no more empty buffers and correctly serializing parsed expressions by taniabogatsch in https://github.com/duckdb/duckdb/pull/8912
* fix(jdbc): uniform exception handling by Mause in https://github.com/duckdb/duckdb/pull/8685
* Wrap failing shell-test so it is not tested on windows. by Tmonster in https://github.com/duckdb/duckdb/pull/8923
* Fix R CMD BUILD script. by Tmonster in https://github.com/duckdb/duckdb/pull/8921
* Point to R package repo for new issues by krlmlr in https://github.com/duckdb/duckdb/pull/8919
* [Dev] Only emit ConstantVectors when `scan_vector` is invoked by Tishj in https://github.com/duckdb/duckdb/pull/8916
* [Dev] Fix signing scripts so they can be called from arbitrary locations by carlopi in https://github.com/duckdb/duckdb/pull/8935
* Detect Header columns with nullpadding by pdet in https://github.com/duckdb/duckdb/pull/8915
* [Parquet | ExportDatabase] Deal with unsupported parquet types in EXPORT DATABASE. by Tishj in https://github.com/duckdb/duckdb/pull/8798
* Issue: 8932 Fix description in empty_needle_removal.hpp by Light-City in https://github.com/duckdb/duckdb/pull/8933
* Fuzzer fixes by Tmonster in https://github.com/duckdb/duckdb/pull/8920
* Add ordering to to underspecified tests by lnkuiper in https://github.com/duckdb/duckdb/pull/8819
* Add rowcount property for Python cursor objects by hannes in https://github.com/duckdb/duckdb/pull/8911
* Various fixes for very large (overflow) strings by Mytherin in https://github.com/duckdb/duckdb/pull/8943
* [PythonDev] Protect `test_replacement_scan.py` from side effects by Tishj in https://github.com/duckdb/duckdb/pull/8953
* remove redundant code by gitccl in https://github.com/duckdb/duckdb/pull/8946
* fix(nodejs): wait to write all data to disk before calling back by Mause in https://github.com/duckdb/duckdb/pull/8843
* [Python Arrow] Fix issue related to TIMESTAMP_TZ and filter pushdown into PyArrow by Tishj in https://github.com/duckdb/duckdb/pull/8856
* Add `PRAGMA metadata_info` that displays info about the storage of metadata, and correctly write free metadata blocks by Mytherin in https://github.com/duckdb/duckdb/pull/8956
* DuckDB-Wasm: Custom repository to be served over https by carlopi in https://github.com/duckdb/duckdb/pull/8960
* [PythonDev] Merge `pyduckdb` module into `duckdb` by Tishj in https://github.com/duckdb/duckdb/pull/8959
* [Python] Extend `show` with keyword arguments to set BoxRenderer options by Tishj in https://github.com/duckdb/duckdb/pull/8954
* Bump aws (removing patches) & spatial to latest commits by carlopi in https://github.com/duckdb/duckdb/pull/8936
* [Python] Fix issue with `dtype` parameter in the `read_csv` method. by Tishj in https://github.com/duckdb/duckdb/pull/8387
* Update logo by szarnyasg in https://github.com/duckdb/duckdb/pull/8970
* [Python] Add 'names' option to `read_csv` by Tishj in https://github.com/duckdb/duckdb/pull/8967
* Allow JSON reader to sample across multiple files by lnkuiper in https://github.com/duckdb/duckdb/pull/8891
* Fix typos and update variable type info in Contributing.md by thfmn in https://github.com/duckdb/duckdb/pull/8975
* Fix outdated C API docs by ocadaruma in https://github.com/duckdb/duckdb/pull/8973
* CSV Parallel Tests CI by pdet in https://github.com/duckdb/duckdb/pull/8910
* Truncate the db file before the WAL for differential storage by Y-- in https://github.com/duckdb/duckdb/pull/8980
* Fix 8592: correctly deal with torn writes by ignoring SerializationException during initial read by Mytherin in https://github.com/duckdb/duckdb/pull/8982
* Fixes for CSV And Aggregate Nightly Build Issues by pdet in https://github.com/duckdb/duckdb/pull/8852
* Internal 317: Fix foreach Label by hawkfish in https://github.com/duckdb/duckdb/pull/8987
* httpfs: Avoid corruptions with servers sending more data than asked for by carlopi in https://github.com/duckdb/duckdb/pull/8940
* Move arrow, postgres_scanner and sqlite_scanner to be autoloadable by carlopi in https://github.com/duckdb/duckdb/pull/8966
* Fix some fuzzer issues by lnkuiper in https://github.com/duckdb/duckdb/pull/8871
* ART fixes by taniabogatsch in https://github.com/duckdb/duckdb/pull/8995
* [ODBC] Error Management Improvement by maiadegraaf in https://github.com/duckdb/duckdb/pull/8939
* fix(nodejs): cpp exception handling by Mause in https://github.com/duckdb/duckdb/pull/8994
* [PythonDev][Docs] Add missing docs for Expression methods. by Tishj in https://github.com/duckdb/duckdb/pull/8991
* [Python][DuckSpark] Add `Column` and a bunch of DataFrame methods by Tishj in https://github.com/duckdb/duckdb/pull/8990
* [JSON] Support escaping quotes in VARCHAR -> LIST cast by Tishj in https://github.com/duckdb/duckdb/pull/8655
* Rework row matching by lnkuiper in https://github.com/duckdb/duckdb/pull/8979
* Issue 7581: Epoch Returns Doubles by hawkfish in https://github.com/duckdb/duckdb/pull/8963