DuckDB 0.10.0 release notes

This release of DuckDB is named "Fusca" after the Velvet Scooter 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.

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
Issue#604 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
Issue#9795 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

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