DuckDB 1.1.0 "Eatoni"

This release of DuckDB is named "Eatoni" after Eaton's pintail (Anas Eatoni) from the southern Indian Ocean.

Please also refer to the announcement blog post: https://duckdb.org/2024/09/09/announcing-duckdb-110

What's Changed

• Add feature changes back in by @Mytherin in #11146
• Make MultiFileReader filename configurable by @lnkuiper in #11178
• [Dev] Fix compilation issues on feature by @Tishj in #11082
• add query() and query_table() functions by @chrisiou in #10586
• [Block Size] Move the block allocation size into the block manager by @taniabogatsch in #11176
• LIMIT pushdown below PROJECT by @jeewonhh in #11112
• BUGFIX: IN () filter with one argument should translate to = filter. by @Tmonster in #11473
• Regression Script should calculate micro benchmark differences with the correct base branch by @Tmonster in #11762
• Pushdown filters on window partitions by @Tmonster in #10932
• Arrow ListView Type by @Tishj in #10766
• Add scalar function support to the C API by @Mytherin in #11786
• Add TopN optimization in physical plan mapping by @kryonix in #11290
• Join-dependent filter derivation by @lnkuiper in #11272
• Implement ROW_GROUPS_PER_FILE for Parquet by @lnkuiper in #11249
• Prefer Final projected columns on probe side if cardinalities are similar by @Tmonster in #11109
• Propagate unused columns to distinct on by @Tmonster in #11006
• Separate eviction queues by FileBufferType by @lnkuiper in #11417
• Disable false positive for vector size nightly in test by @taniabogatsch in #11953
• Rework jemalloc extension by @lnkuiper in #11891
• Tweak jemalloc config by @lnkuiper in #12034
• Httpfs test to nightly by @carlopi in #12196
• Removed three reinterpret casts and some rewriting by @taniabogatsch in #12200
• Begin Profiling Rework to move towards Modularity by @maiadegraaf in #11101
• [CLI] Add highlighting + limited auto-complete for shell dot commands by @Mytherin in #12201
• Skip test to fix block size nightly and add more explicit error checking by @taniabogatsch in #12211
• Remove BLOCK_ALLOC_SIZE from the column segment files by @taniabogatsch in #11474
• [Julia] - Added optional schema input argument to DuckDB.Appender constructor by @curtd in #12174
• Fix Mark Index in the Bound Join Ref by @pdet in #12263
• Fix for CI Regression Failure by @maiadegraaf in #12273
• 🦆 by @samansmink in #12303
• Disable JEMALLOC_RETAIN by @lnkuiper in #12185
• Enforce compression extensions for CSV Files by @pdet in #11903
• Make spuriously failing test more robust by @lnkuiper in #12306
• Add new extensions to issue template by @szarnyasg in #12313
• [Fix] Block size nightly run by @taniabogatsch in #12283
• Spell Check | Nothing Major | Corrected base_scanner.cpp by @nj7 in #12282
• add duckdb_bind_timestamp_tz function to C API by @karlseguin in #12151
• [Python] Add some date/datetime functions to pyspark api by @mariotaddeucci in #12075
• Fixes to Windows workflow and ubuntu_18 action by @carlopi in #12308
• [Extension Dev] Forward declare re2 in hive_partitioning.hpp by @Tishj in #12302
• add expected errors to test/sql/copy/per_thread_output.test by @hmeriann in #12280
• Issue #12287: ICU Strptime Lists by @hawkfish in #12295
• Issue #12171: Streaming Window FILTER by @hawkfish in #12250
• [Python] Update the Connection wrapper generation, now generates c++ code by @Tishj in #12216
• Use iterator buffer position when storing buffer handles by @pdet in #12315
• Bump Julia client to v0.10.3 by @Mytherin in #12323
• Fix #12286 - in the MetadataManager, prefer to allocate new blocks if the next free block id is smaller than the currently used metadata block by @Mytherin in #12318
• [Fix] Only read file size if file handle still exists by @taniabogatsch in #12319
• Add support for APPEND argument to hive partitioned write by @Mytherin in #12262
• Remove all reinterpret casts from the transformer by @taniabogatsch in #12320
• Additional check for overlapping CTE names by @lnkuiper in #12305
• [Dev] STANDARD_VECTOR_SIZE and BLOCK_ALLOC_SIZE can now be set through the Makefile by @Tishj in #12164
• [Upsert] Fix issue with lambdas in DO UPDATE SET expressions by @Tishj in #11866
• [Python] Fix scoping issue for pandas_analyze_sample setting by @Tishj in #11706
• Support REGEX matches expected error message by @hmeriann in #12327
• Allow run_fuzzer to reduce multi statements. by @Tmonster in #12278
• Fix #12328 - when flattening STRUCT vectors with NULL values, we need to flatten the children recursively as well by @Mytherin in #12332
• Make dbgen generate data in parallel by @Mytherin in #12337
• dbgen: skip parallel generation if DUCKDB_NO_THREADS is set by @Mytherin in #12341
• Add prefix prefix_front_back. to get prefix_front_ and prefix_back_ by @liujiayi771 in #12344
• Issue #12171: Streaming Windowed DISTINCT by @hawkfish in #12311
• Update README by @szarnyasg in #12357
• [CSV Reader] [Skip Option] Tests and fixes by @pdet in #12213
• Adjust BM25 score in FTS extension to prevent negative scores by @lnkuiper in #12356
• Fix typos by @szarnyasg in #12360
• Fix #12293 - accept NULL values in generate_series with timestamp by @Mytherin in #12367
• Fix #12335: avoid calling fsync when writing Parquet files, instead just close the file by @Mytherin in #12371
• Fix parameters passed down to other workflows in OnTag.yml by @carlopi in #12369
• [Python] Fixes for the SQLLogicTest runner implementation by @Tishj in #12372
• Bump julia to v1.0.0 by @Mytherin in #12379
• Fix #11921 - varchar -> timestamp casts are not invertible by @Mytherin in #12376
• Upgrade utf8proc - and move our custom extensions out of utf8proc itself by @Mytherin in #12373
• change max_queries number back to 2000 by @Tmonster in #12375
• Remove sqlsmith extension by @Tmonster in #12300
• Reorder semi and anti joins. by @Tmonster in #11815
• Issue #12351: implicit cast to TIMESTAMP_MS, TIMESTAMP_S, TIMESTAMP_NS from DATE values by @akoshchiy in #12352
• Issue #10023: Approx_Count_Distinct Memory Usage by @hawkfish in #12355
• Fix a small typo in dev instructions for swift setup by @gjmwoods in #12383
• Release lock before returning BufferHandle in StandardBufferManager::Pin by @lnkuiper in #12391
• Remote attach autoload by @carlopi in #12393
• Add JSON type to Parquet reader/writer by @lnkuiper in #12222
• Add RETURN_FILES parameter to COPY TO by @lnkuiper in #12220
• Updated JoinHashTable to use linear probing to resolve hash collisions by @gropaul in #11472
• [Benchmark Runner] Add --disable-timeout flag by @Tishj in #12387
• Don't replace unicode spaces within $$ quotes in query strings by @lnkuiper in #12405
• [Python] Fix fatal exception caused by empty Pandas Categorical objects. by @Tishj in #12370
• Release CSV Blocks when acquiring new blocks if single threaded by @pdet in #12409
• Add support for prefetching multiple adjacent blocks in a single batched read when attaching to remote databases by @Mytherin in #12413
• MatchRegex() fixed to do not return false positive result by @hmeriann in #12396
• Expected errors 2053 by @hmeriann in #12392
• [C-API] Catch exception in duckdb_execute_prepared by @Tishj in #12414
• Combining LIST_CONCAT and CONCAT binding by @maiadegraaf in #12317
• [Appender] Add AppendDefault by @Tishj in #11905
• [Python Dev] Push CTE internally for every (python) replacement scan that occurred. by @Tishj in #12161
• Improve compiler compatibility by @krlmlr in #12401
• Write zero-length list offsets for NULL values when serializing vectors by @Mytherin in #12423
• Get column statistics if Logical Get has a statistics function by @jeewonhh in #12424
• jemalloc: Identify GNU source code properly by @lnkuiper in #12420
• Avoid parallelizing LIMIT clauses when the query plan is simple by @Mytherin in #12433
• Prefetch metadata blocks for remote files by @Mytherin in #12437
• [Jupyter] Remove width limit on the BoxRenderer config by @Tishj in #12443
• Revert #10865 by @carlopi in #12426
• inline delta by @samansmink in #12435
• Account for tagged dollar-quoted strings when stripping unicode spaces by @lnkuiper in #12421
• Work-around for broken github windows runner by @Mytherin in #12447
• Prevents clearing of the types of the LogicalExecute operator by @NiclasHaderer in #12436
• Add support for BEGIN TRANSACTION READ ONLY by @Mytherin in #12202
• Make range and generate_series table in-out functions, and fix several issues with table in-out functions by @Mytherin in #12431
• Issue #12412: AsOf Filter Push by @hawkfish in #12448
• [Fix] Block Size Nightly by @taniabogatsch in #12427
• [ART] Remove Flatten and template key generation by @taniabogatsch in #12428
• [Python] Clean up internals of execute / executemany by @Tishj in #12434
• By default attach remote databases as READ_ONLY by @carlopi in #12461
• Fix #11837: use internal physical type for FIRST/LAST/ANY_VALUE instead of logical type by @Mytherin in #12462
• Issue #12464: Windowed Order By All by @hawkfish in #12470
• Specialize list_value for primitive types for significantly improved performance by @Mytherin in #12468
• [Dev] Remove dead code from PhysicalBatchCopyToFile by @Tishj in #12459
• Disable Windows extensions CI until Github actions runners are fixed by @Mytherin in #12479
• [Fix] access_mode now lives in AttachOptions by @taniabogatsch in #12482
• Internal #2186: Nanosecond Functionality by @hawkfish in #12440
• [C-API] Fix leak in duckdb_create_config by @Tishj in #12465
• [Python] No longer scan the entire frame lineage in a replacement scan, added option to disable (python) replacements entirely by @Tishj in #12425
• throw binder error for comment on system catalog by @samansmink in #12486
• Parquet reader performance by @lnkuiper in #12478
• Operators the Optimizer can skip by @Tmonster in #12489
• Fixes clang conversion warnings by @TinyTinni in #12467
• Avoid creating internal schemas as non-internal when reading old database files by @Mytherin in #12456
• Allow parquet encryption/decryption keys to be passed in as base64 encoded strings by @elefeint in #12445
• [Block Size] Introducing CompressionInfo by @taniabogatsch in #12481
• add the number of filtered files to explain by @samansmink in #12488
• Implement Map Type Detection for JSON Reader by @ZiyaZa in #11285
• [Dev] Remove busy-spin from ClientContext::ExecuteTaskInternal by @Tishj in #12483
• Pluggable collations by @Mytherin in #12492
• [Dev] Don't fail make generate-files if the python code generation fails by @Tishj in #12500
• Optimize EXTRACT(year/month/day FROM date/timestamp) by @Mytherin in #12499
• [Fix] Remove BLOCK_ALLOC_SIZE in the single file block manager by @taniabogatsch in #12502
• Revert Windows CI fixes by @carlopi in #12510
• Fix #12467 changes to covariance calculation by @carlopi in #12515
• [Python] Fix reading strided datetime and timedelta columns by @Tishj in #12519
• Add method for decoding sort keys, and use this in min/max for arbitrary types by @Mytherin in #12520
• Reduce allocations & use predication in ColumnSegment::FilterSelection by @Mytherin in #12521
• Skip only built-in optimizers by @Mytherin in #12522
• Improve min/max performance for strings and fallback types by @Mytherin in #12524
• Move arg_min/arg_max to use sort keys by @Mytherin in #12525
• Move FIRST/LAST/ANY_VALUE to use sort keys by @Mytherin in #12526
• CMake: use GNUInstallDirs as defaults for INSTALL_{BIN,LIB,INCLUDE}_DIR by @paparodeo in #12509
• More formatting and fix to stddev by @carlopi in #12516
• Linux Extensions CI: Attempt at fix missing dependencies by @carlopi in #12429
• Fix checkouts by @carlopi in #12366
• Etag if none match for extension install by @carlopi in #12333
• [Block Size] FixedSizeAllocator, MetadataManager, PartialBlockManager by @taniabogatsch in #12514
• [Python] Skip the PandasAnalyzer if dtype is 'string' by @Tishj in #12511
• [StreamQueryResult] Batched variant of the StreamQueryResult collector by @Tishj in #11494
• Move many tests to slow by @Mytherin in #12534
• Add support for arg_min(ANY, ANY) by @Mytherin in #12532
• Avoid overriding types in PrepareTypeForCast when not required by @Mytherin in #12539
• Support all types in histogram function by @Mytherin in #12538
• [Python] Remove busy-spin during execution by @Tishj in #12512
• [Block Size] String space constant by @taniabogatsch in #12537
• Use string_t instead of std::string in histogram by @Mytherin in #12545
• Add support for binned histograms by @Mytherin in #12548
• [Upsert] Fix RETURNING for DO NOTHING by @Tishj in #12554
• Build Android Binaries by @hannes in #12550
• [CI] Remove pyarrow version lock by @Tishj in #12566
• [Dev] Change tests: np.NaN -> np.nan by @Tishj in #12565
• Internal #2017: DECIMAL Downcast Rounding by @hawkfish in #12036
• Issue #12204: Summarize Temporal Quantiles by @hawkfish in #12297
• Internal #2186: Nanosecond StrTimeFormat by @hawkfish in #12551
• Add support for equi_width_bins function to compute histogram boundaries by @Mytherin in #12574
• add support for casting 'yes'/'no' strings to boolean values by @chrisiou in #12501
• Julia: Add chunked results with Tables.partitions() by @frankier in #12395
• [PySpark] - Allow spark session range by @mariotaddeucci in #12346
• [PySpark] Implement subset drop duplicates by @mariotaddeucci in #12348
• ICU noaccent collation by @tiagokepe in #12170
• Implement Brotli compression for Parquet reading & writing by @hannes in #12103
• [FriendlySQL] Unpacked COLUMNS() Expression by @Tishj in #11872
• [PySpark] Implement UDFRegistration.register method on PySpark api by @mariotaddeucci in #12179
• [Python] Don't use np.nan, deprecated alias starting with NumPy 2.0 by @Tishj in #12583
• Add bind_expression callback to scalar function, and use it to turn typeof into a BoundConstantExpression by @Mytherin in #12580
• Add can_cast_implicitly scalar function by @Mytherin in #12581
• Add support for histogram and histogram_values table macro, and add support for default table macros (similar to how we support default macros) by @Mytherin in #12590
• build: swap libclang for cxxheaderparser by @Mause in #12567
• [C-API] Add table_description struct to query various information about the table. by @Tishj in #12460
• Change new micro benchmark script to only look for .benchmark files by @maiadegraaf in #12598
• Add HTTP error code to extension install failures by @carlopi in #12608
• Separate WAL write from commit, and allow writing to the WAL without holding the transaction lock by @Mytherin in #12261
• Add OwningStringMap - and rework histogram and mode functions to use this by @Mytherin in #12601
• Feature #1272: Window Executor State by @hawkfish in #12573
• Add support for any type to mode aggregate by @Mytherin in #12619
• WAL - when dropping a table, also delete any transaction local storage associated with that table by @Mytherin in #12603
• [Python] Allow Generators to be passed where List is expected by @Tishj in #12602
• VectorOperations::Copy - fast path when copying an aligned flat validity mask into a flat vector by @Mytherin in #12618
• Move android CI to only run during nightly CI triggers by @Mytherin in #12622
• Add initial support for GeoParquet + Bump spatial by @Maxxen in #12503
• Issue #12600: Streaming Positive LAG by @hawkfish in #12609
• Feature #1272: Window Group Preparation by @hawkfish in #12628
• Minor window improvements by @Mytherin in #12617
• Merge feature into main by @Mytherin in #12633
• Refactor quantile aggregate - clean up code & support quantile_disc/median for all types by @Mytherin in #12630
• Feature 1272: Window Payload Preallocation by @hawkfish in #12629
• [ART] Configurable index scan threshold by @taniabogatsch in #12635
• Subtract start offset for when fetching array child segment by @Maxxen in #12639
• Remove custom logic to detect main vs feature by @carlopi in #12643
• Do not quote fields with space in the CSV output mode by @szarnyasg in #12644
• Use lowercase in 'html' output mode by @szarnyasg in #12612
• Internal #2361: Window ROWS Overflow by @hawkfish in #12652
• Quantile: Fix variable used only in D_ASSERT by @carlopi in #12642
• Skip pytorch test, it fails spuriously in CI by @carlopi in #12645
• Add histogram_exact function that adds values to bins only if they match exactly, and add other column that contains values that do not fit in any bin by @Mytherin in #12650
• Add operator hook for sink progress by @Maxxen in #12637
• Regression workflow on newly introduced benchmarks: remove for now by @carlopi in #12659
• Fix #12646 - allow SQL value functions in HAVING by @Mytherin in #12654
• Add != operators on string_t and interval_t by @carlopi in #12658
• fix: improve C scalar functions API by @rustyconover in #12663
• Add approx_top_k aggregate based on the (Filtered) Space-Saving algorithm, and use it in histogram by @Mytherin in #12653
• Fix std::sort requirements, from greater_equal to greater by @carlopi in #12669
• fix(parquet): two-complement zeroes check on FIXED_BYTE_ARRAY encoded DECIMAL (#12621) by @fedefrancescon in #12655
• [CSV Reader] Reorder of Columns for CSV Scans on multiple files. by @pdet in #12288
• [CSV] [Bug-Fix] Fix for issue related with single-threaded execution and null padding. by @pdet in #12679
• [Block Size] String block limit and a few other places by @taniabogatsch in #12671
• Rework arena allocator allocation policy - and increase pivot threshold by @Mytherin in #12690
• Julia - Fix Base.isopen(db::DB) in #12700
• [CLI] Limit history size to 100MB, and avoid writing invalid UTF8 to the CLI history by @Mytherin in #12677
• Add configurable thresholds for using nested loop join and merge join by @Mytherin in #12689
• Prevent unnecessary usage of std::string in list aggregate - and use more efficient memcpy for batched copy by @Mytherin in #12694
• Dont load spatial unless geoparquet metata is present by @Maxxen in #12692
• Serialization: add CustomData and better support for integrating with extensions by @jeewonhh in #12681
• Removing ODBC driver by @hannes in #12706
• Support thousand separator for floating point numbers by @Mytherin in #12717
• [Python] Use non-owning references to hold created cursors by @Tishj in #12711
• LIST(VARCHAR) - reduce memory usage by avoiding allocation of nullmask for string data, and allocate larger initial batches by @Mytherin in #12705
• [CSV] Bug fix for race condition in single-threaded multifile reader + properly print paths on union_by_name errors. by @pdet in #12697
• Issue template: Add ODBC and Node (neo) clients by @szarnyasg in #12714
• Shell: add .sql suffix to temporary file created with \e by @Mytherin in #12723
• Partitioned write - keep only up until 100 files open, when this limit is exceeded close the file and create a new file if more data for this partition appears by @Mytherin in #12708
• Change setting types to fix warnings by @Mytherin in #12724
• Avoid unnecessarily copying child expression when binding COLLATE statements by @Mytherin in #12725
• Support for variadic arguments in scalar UDFs in the C API by @taniabogatsch in #12678
• [Relation API] Dont push DISTINCT modifier for EXCEPT/INTERSECT ALL by @Tishj in #12599
• Builds for Windows on ARM64 by @hannes in #12586
• Rework union_by_name so that files are no longer kept open by @Mytherin in #12730
• Fix #12729: early-out when checking for perfect hash joins when running on empty tables by @Mytherin in #12731
• CLI: Replace \n with \r\n again in history again by @Mytherin in #12735
• Fix #11228 - add support for unsigned integers in printf/format by @Mytherin in #12736
• Various CI fixes by @Mytherin in #12737
• Add repeat(LIST[], INT) that allows repetition of lists similar to how this is allowed in Python by @Mytherin in #12738
• [Python] Add missing options to read_json method by @Tishj in #12732
• Add support for fetching cardinality estimation and stats through a multifilelist by @samansmink in #12740
• Fixes warnings detected by cppcheck by @carlopi in #12745
• [Arrow] Add ArrowQueryResult by @Tishj in #12496
• [Dev] StreamQueryResult internals cleanup by @Tishj in #12636
• ALP/ALPRD: correctly skip when we are skipping fewer values than in a vector by @Mytherin in #12753
• Maintain prepared statement parameter types explicitly instead of converting into literals by @Mytherin in #12759
• CLI .changes: use sqlite3_changes64 and sqlite3_totalchanges64 to prevent overflows by @Mytherin in #12761
• Fix #12569: avoid truncating zeros that matter in format function by @Mytherin in #12762
• Fix #12418: Remove .lint command in SQLite shell by @Mytherin in #12763
• Fewer system calls in LocalFileSystem::ListFiles by @Mytherin in #12769
• Support indexes in COPY DATABASE by @Mytherin in #12768
• Issue #12600: Batched LEAD/LAG by @hawkfish in #12770
• Issue #12600: Streaming Positive LEAD by @hawkfish in #12685
• Add dl functionality for Windows by @ccfelius in #12765
• Fix stale bot permissions, with @szarnyasg by @carlopi in #12782
• [CI] Stale bot: actually add permissions by @carlopi in #12786
• Fix FILE_SIZE_BYTES test (again) by @lnkuiper in #12779
• Fix extended tests in CI by @carlopi in #12781
• Patch CentOS 7 EOL causing CI failure by @samansmink in #12788
• Allow extensions to optionally add own description (on load) by @carlopi in #12754
• Internal #2429: Shifted LEAD NULLs by @hawkfish in #12791
• Issue #12784: Months Before Days by @hawkfish in #12794
• bump vss by @Maxxen in #12797
• Remove centos workaround by @samansmink in #12801
• For compressed deletes in the undo buffer - count the actual size that will be written to the WAL when determining the auto-checkpoint threshold by @Mytherin in #12803
• feat: new inet functions by @panga in #12575
• [Dev] MakeExecutor::ResultCollectorIsBlocked less trigger-happy by @Tishj in #12780
• Fix #12798: Add head file to fix debug build incomplete type error by @zzachimed in #12810
• [Block Size] Switching to configurable block sizes by @taniabogatsch in #12691
• [Dev] Clean up the generate_serialization.py script a bit by @Tishj in #12823
• Remove micro extended from duckdb/duckdb by @hmeriann in #12792
• [Python] Allow pathlib.Path to be provided to duckdb.connect by @Tishj in #12809
• remove .py scripts migrating to the sqlsmith by @hmeriann in #12827
• Some expected error messages added by @hmeriann in #12825
• [Fix] list_resize by @taniabogatsch in #12832
• [Python] Python SQLLogicTester maintenance by @Tishj in #12833
• [Python] Accept a list of Expression objects in DuckDBPyRelation.aggregate by @Tishj in #12812
• [Copy Database] Don't include generated columns in the copied data by @Tishj in #12835
• [Julia] Added Appender support for Int128, UInt128, and Base.UUID values by @curtd in #12836
• [Python] Fix extraction of days/seconds/microseconds from timedelta object by @Tishj in #12760
• [Python] Output a regular key -> value dict for hashable keys by @Tishj in #12734
• [Dev] Change internals of StringUtil::GenerateRandomName by @Tishj in #12806
• [CSV] Adaptive Sniffer by @pdet in #12698
• Fix LinuxRelease.yml after bump to Node 20 by @carlopi in #12850
• Fix: Reduce repeated judgment in ties[i]. by @Light-City in #12840
• add html_escape and html_unescape functions in inet extension by @chrisiou in #11191
• Fix union struct implict cast by @Maxxen in #12847
• Update httplib from v0.10.2 to v0.14.3 by @lnkuiper in #12849
• Fix an issue where parameters would be promoted to NULL, incorrectly causing PREPARE to fail by @Mytherin in #12844
• More expected error messages added by @hmeriann in #12846
• Overload MIN/MAX/MAX_BY/MIN_BY to return the "top" N values by @Maxxen in #12834
• Fix #12789: list_zip support array by @flashmouse in #12859
• [Python] Fix missing ConnectionException errors by @Tishj in #12864
• Make equi_width_binning buckets even nicer by @Mytherin in #12878
• Add a JSON pretty print function by @PhictionalOne in #12398
• Add Metrics Support in the CAPI by @maiadegraaf in #12498
• Update issue template by @szarnyasg in #12880
• Fix regression in Parquet reader TryOpenNextFile by @lnkuiper in #12848
• Improve performance of memory usage counters by @yiyuanliu in #12751
• [Fix] No String Inline / Destroy Unpinned Blocks nightly run by @taniabogatsch in #12884
• Fix LinuxRelease.yml CI by avoiding upload by @carlopi in #12891
• Do not depend on manylinux extension in Python's CI by @carlopi in #12895
• [Dev] Fix failing test in test_relation_api.cpp by @Tishj in #12894
• [Dev] Skip test_run_pandas_with_tz on pandas <2.0.0 by @Tishj in #12896
• Fix #12688: Julia SubString handling by @dhanak in #12899
• [Python-Dev] Add DependencyException, throw earlier if PendingQuery fails by @Tishj in #12888
• [Fix] Mixing block sizes and compression functions by @taniabogatsch in #12858
• Fix issue with list radix serialization by @lnkuiper in #12887
• Respect limit during join order by @Tmonster in #12851
• [CHORE]: Fix minor SQL test case by @Tmonster in #12909
• Fixes for duckdb_constraints and information_schema constraint tables by @Mytherin in #12914
• [Postgres Compatiblity] Support => to supply named parameters to functions by @Tishj in #12913
• Pushdown table filters into probe based on min/max data found during hash build of hash joins by @Mytherin in #12908
• Count nulls when detecting JSON structure by @lnkuiper in #12883
• Fix #12870 - improve error message when encountering schema mismatches in COPY tbl FROM file.parquet by @Mytherin in #12918
• Use different versions of snappy depending on the compiler by @lnkuiper in #12889
• Fix Issues with type detection for Doubles/Floats/Decimals by @pdet in #12866
• Pass 'Unsecure_node_version' to allow node16 for a bit longer by @carlopi in #12922
• Minor refactor for window_executor by @ZhangHuiGui in #12924
• ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION:false for Android and Nightly by @carlopi in #12930
• [Fix] Vector verification for dictionary expressions by @taniabogatsch in #12890
• Return smaller cardinality for Top N operator by @jeewonhh in #12932
• Make GCC Happy Again by @carlopi in #12937
• [Fix] More robust parquet metadata test by @taniabogatsch in #12935
• Rework table filters, and for each row group only execute table filters if they can actually filter out any rows by @Mytherin in #12938
• Issue #12941: Window Constant Results by @hawkfish in #12943
• Expected errors 2053 by @hmeriann in #12927
• Make ErrorData::Message() and ErrorData::RawMessage() const by @Flogex in #12885
• Feature #1272: Window Parallel Sink by @hawkfish in #12907
• [Arrow] Add PhysicalArrowBatchCollector, a batched result collector for the ArrowQueryResult by @Tishj in #12787
• [Python] Rework internals of object registration by @Tishj in #12625
• [StreamQueryResult] Add ExecuteTask method to StreamQueryResult by @Tishj in #12824
• Fix several CTE related issues by @kryonix in #12948
• Label mark joins with convert to semi by @Tmonster in #12916
• [Julia]: Added FixedDecimal support to Appender API by @curtd in #12923
• Pushdown dynamically generated filters into MultiFileList, allowing partitions to be pruned by @Mytherin in #12955
• Automatically materialize CTEs by @lnkuiper in #12290
• Move checkpointing parallelism into TaskExecutor class, use that class for parallel union_by_name by @Mytherin in #12957
• [Dev] Uncouple HTTPState from core by @Tishj in #12912
• [Dev] Clean up TreeRenderer code by @Tishj in #12716
• Swap build side and probe side base on cardinality AND width of build side. by @Tmonster in #12755
• [Python] Use Set instead of List for the get_table_names stubs by @Tishj in #12963
• Feature #1272: Window Validity Array by @hawkfish in #12954
• [CSV Reader] Make glob reading more permissive to errors if ignore_errors is set by @pdet in #12966
• [Python] Convert ENUM to np.array instead of pd.Categorical for fetchnumpy by @Tishj in #12964
• Several hive partitioning fixes by @Mytherin in #12970
• fix incorrect int32 appender by @piever in #12956
• Add missing TransformCTE extraction to TransformRecursiveCTE by @kryonix in #12968
• Expected errors 2053 by @hmeriann in #12969
• Add Pyodide 0.26.1 (corresponding to Python 3.12) by @carlopi in #12965
• Avoid adding a suffix to Parquet files when doing a partitioned write by @Mytherin in #12972
• URL Encode/Decode Hive Partitioning Columns/Filters + add url_encode/url_decode scalar functions by @Mytherin in #12974
• Fix JSON extension Cmake by @carlopi in #12975
• Clarify when it's necessary to refresh data and validity pointers by @Giorgi in #12973
• Added new information_schema views - closes #4343 by @prmoore77 in #12942
• Use jaro winkler similarity for finding similar entries in catalog by @Mytherin in #12980
• Internal #2503: Streaming Window Reset by @hawkfish in #12984
• Fix #12933: maintain insertion order in window when the window clause is empty (i.e. over ()) by @Mytherin in #12982
• Feature #1272: Window Constant Sink by @hawkfish in #12979
• Remove special case for '+' in URLs in httplib by @lnkuiper in #12929
• Rebind prepared statements based on catalog versions by @ywelsch in #12829
• Allow string stats larger than our default for parquet row group pruning by @lnkuiper in #12928
• Add work-around for R client table function initialization back in under a config setting by @Mytherin in #12990
• [Dev] Add getters/setters for the 'column_ids' of a LogicalGet by @Tishj in #12971
• Accelerate Parquet en/decryption with HTTPFS extension by @ccfelius in #11720
• remove deprecated CDN invalidations by @samansmink in #12997
• add large ingestions by @hmeriann in #12949
• Fix shared_ptr issues in RowGroup and add locks to WAL initialization by @Mytherin in #13000
• Add the ANY type and special null handling to the C API by @taniabogatsch in #12785
• Improve error messages in the presence of subqueries by @Mytherin in #13001
• Case-insensitive NULL casting in VARCHAR -> STRUCT casts by @lnkuiper in #13003
• TemporaryMemoryManager improvements by @lnkuiper in #12931
• Make sure that empty and only white space headers have same treatment by @pdet in #12994
• Push timestamp_tz to do direct casting if ICU is not loaded by @pdet in #12993
• [Dev] Add query to QueryRelation for logging by @Tishj in #13004
• [Spark API] Fix group by compatibility issues by @Tishj in #13005
• [CSV] Progress Bar for compressed files. by @pdet in #12728
• Disable fixed size map in PartitionedTupleData by @Mytherin in #13013
• Fix parallel creation and destruction of instances through the DBInstanceCache by @Mytherin in #13010
• Avoid generating join filters for interval columns by @Mytherin in #13014
• Extend least/greatest to support all types, and always return the same type as its input types by @Mytherin in #13019
• Add sha1(varchar) -> varchar scalar function by @bradlarsen in #13020
• Decimal to FloatingPoint: Avoid losing precision by splitting operation in two, more fixes and tests by @carlopi in #12627
• Feature #1272: Segment Tree Finalize by @hawkfish in #13002
• Create Delimiter Join and Delimiter Get via Relations by @pdet in #12953
• Fix CTE/noalternativeverify issues by @lnkuiper in #13024
• Fix bug in reworked fixed_size_map_t by @lnkuiper in #13023
• Fix abs for floating point negative zero by @Mytherin in #13025
• [Nightly-Bug] [CSV Reader] Use strings on header detection by @pdet in #13028
• Release GIL during DB instantiation by @ywelsch in #13029
• GCC 4.8: add noexpr to 2 constructors by @carlopi in #13030
• Fixes for LogicalType::ANY and fixed_size_map by @Mytherin in #13035
• [Nightly] Fix for arrow appending fixed size lists by @pdet in #13039
• fix storing persistent secrets in home dir by @samansmink in #13033
• Internal #2534: IGNORE NULLS Threading by @hawkfish in #13050
• [Julia] Only commit transaction on non-error (compat) by @genericallyterrible in #13049
• Improve EXPLAIN output of Delim Joins and Delim Gets by @kryonix in #12995
• Make client reuse threadsafe by @samansmink in #13052
• Only remove the first occurrence of extension prefix by @jeewonhh in #13057
• Fix incorrect overflow in left shift of unsigned number by @Mytherin in #13056
• Add tests for sha1 function by @bradlarsen in #13064
• [Relation] ViewRelation could be created without an alias by @Tishj in #13054
• Support IN operator for LIST by @Tishj in #12920
• [Python] Read from file-like objects with read_json by @Tishj in #13040
• [Python] Fix lifetime issue with MaterializedRelation by @Tishj in #12998
• PySpark sort by columns and DataFrame.getitem by @khalidmammadov in #12981
• Fix trouble to compile with MSVC by @annnei in #12579
• Create a dedicated RegisteredStateManager that manages client context states in a thread-safe manner by @Mytherin in #13027
• DEBUG_STACKTRACE should not be enabled for release builds by @Mytherin in #13070
• Add blob overloads to crypto functions, and turn md5_number_lower and md5_number_upper into macros by @Mytherin in #13068
• Internal #2534: IGNORE NULLS Threading by @hawkfish in #13065
• Variable Integer Size Type by @pdet in #13015
• Simplify binding of CALL statement by @Mytherin in #13074
• Fix #13045: flatten in list_inner_product by @Mytherin in #13076
• Fix for unpivot on zero columns by @Mytherin in #13073
• Add support for overloading to macros by @Mytherin in #13062
• Internal #2534: Windowed FILTER Threading by @hawkfish in #13086
• Fixup #12579, remove pessimizing std::move by @carlopi in #13089
• [CSV Reader] Fix when reading overbuffer values of csv files with extra delimiter by @pdet in #13081
• Making error messages more clear for new line delimiter errors by @pdet in #13082
• [CSV Sniffer] Sniffer can now sniff files with extra delimiters by @pdet in #13083
• Remove test in Pyodide due to weird pandas interactions by @carlopi in #13091
• Add support for SQL-level variables by @Mytherin in #13084
• Fix wasm CI and add missing template argument by @carlopi in #13094
• Some clang tidy fixes around narrowing casts by @carlopi in #13105
• chore: PushdownAggregate fast path by @lichuang in #13098
• • fix list_distance & list_cosine_similarity execute fail when list i… by @flashmouse in #13090
• [Explain] Add EXPLAIN (FORMAT JSON) syntax by @Tishj in #12967
• Expected errors 2053 by @hmeriann in #13107
• [Bug] Enum types not being found if created in a schema by @pdet in #13106
• Parquet reader can now read files with duplicate column names by @hannes in #13111
• Prefer aliases over column-value functions in GROUP BY, and prefer error message when alias is used in an expression by @Mytherin in #13118
• Disallowing DISTINCT, FILTER and ORDER BY for UNNEST by @hannes in #13110
• Feature #1272: Windowed DISTINCT Sink by @hawkfish in #13093
• adjust list value logic execute seq by @flashmouse in #13114
• add CORE_EXTENSIONS build flag by @samansmink in #13116
• [Python] Add missing options for read_csv by @Tishj in #12872
• Fix merge conflict by @Mytherin in #13126
• Retry on HTTP failure in extension install by @Mytherin in #13122
• Clean up ChunkInfo when cleaning up a transaction by @Mytherin in #13125
• typo: conjuction -> conjunction by @qsliu2017 in #13127
• Add duckdb_result_error_type that returns the exception type of the error by @Mytherin in #13131
• Keep track of user-provided configuration options, and compare them as well for database instance caching purposes by @Mytherin in https://github.com/duckdb/duckdb/pull/13129
• Disable sniff_csv when enable_external_access is not set by @hannes in https://github.com/duckdb/duckdb/pull/13133
• Internal #2577: Window Atomic Finalize by @hawkfish in https://github.com/duckdb/duckdb/pull/13117
• Internal #2577: Window Tree Allocation by @hawkfish in https://github.com/duckdb/duckdb/pull/13119
• Fix optimizer error when dealing with IN with a single NULL parameter by @Mytherin in https://github.com/duckdb/duckdb/pull/13139
• Internal #2597: Ragged Validity Array by @hawkfish in https://github.com/duckdb/duckdb/pull/13137
• Create file with O_EXCL flag set. by @mkaruza in https://github.com/duckdb/duckdb/pull/13123
• better CE for comparisons that use =, !=, <, <=, >, >=. by @Tmonster in https://github.com/duckdb/duckdb/pull/13130
• Use Slurm env vars to manage cpu and memory allocation if run inside Slurm HPC job by @dirkpetersen in https://github.com/duckdb/duckdb/pull/12978
• Fix CTEFilterPusher optimization by @kryonix in https://github.com/duckdb/duckdb/pull/13142
• Test with recent threadsanitizer by @carlopi in https://github.com/duckdb/duckdb/pull/13124
• Fixes for RegexFindAll function errors and multibyte character support by @chrisiou in https://github.com/duckdb/duckdb/pull/13108
• clang-tidy: rework Makefile and CI by @carlopi in https://github.com/duckdb/duckdb/pull/13101
• Extension updates to also be logged via enable_http_logging by @carlopi in https://github.com/duckdb/duckdb/pull/13087
• Hooks now get an error to indicate transaction/query success. by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/13136
• Use alias bind path in ORDER BY when running COLLATE by @Mytherin in https://github.com/duckdb/duckdb/pull/13140
• Implementation of recursive JSONPath expressions by @robert-s01 in https://github.com/duckdb/duckdb/pull/12991
• Adding option to disable materialized cte optimization by @pdet in https://github.com/duckdb/duckdb/pull/13146
• [Python] Fix issue with native UDFs returning STRUCT items by @Tishj in https://github.com/duckdb/duckdb/pull/13147
• CGroups: fix compilation due to UB cast by @carlopi in https://github.com/duckdb/duckdb/pull/13151
• test_expression.py: Skip throw related test on Windows by @carlopi in https://github.com/duckdb/duckdb/pull/13157
• Replaced while loop with if statement by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/13161
• ThreadSanitizer: Avoid spurious data race in InsertMatchesAndIncrementMisses by @carlopi in https://github.com/duckdb/duckdb/pull/13179
• Add 'bugprone-narrowing-conversions' clang-tidy check by @carlopi in https://github.com/duckdb/duckdb/pull/13180
• [C API] Return duckdb_value in duckdb_profiling_info_get_value by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13160
• Fix #13120: implement StructFilter::ToExpression by @Mytherin in https://github.com/duckdb/duckdb/pull/13182
• Feature #1272: Windowed DISTINCT Sort by @hawkfish in https://github.com/duckdb/duckdb/pull/13150
• Add native list_has_any implementation by @Maxxen in https://github.com/duckdb/duckdb/pull/13163
• Add pragma extension versions by @samansmink in https://github.com/duckdb/duckdb/pull/13063
• [C API] Add duckdb_scalar_function_set_volatile that allows changing FunctionStability of a scalar function by @Mytherin in https://github.com/duckdb/duckdb/pull/13186
• [CSV Sniffer] Give preference to configurations that ignore the least amount of lines by @pdet in https://github.com/duckdb/duckdb/pull/13188
• Fix #13017 - if grabbing the lock fails due to it not being supported, allow this in read-only mode by @Mytherin in https://github.com/duckdb/duckdb/pull/13189
• Add test_collate_pivot: used to fail in 1.0.0, add to avoid regressions by @carlopi in https://github.com/duckdb/duckdb/pull/13190
• Add catalog_error_max_schemas setting that toggles how many schemas we look at for "did you mean..." style error messages by @Mytherin in https://github.com/duckdb/duckdb/pull/13191
• Fix build error when compiling with -DDISABLE_EXTENSION_LOAD=1 by @whatsthecraic in https://github.com/duckdb/duckdb/pull/13194
• Add clang-tidy-diff script, and invoke it on PRs by @carlopi in https://github.com/duckdb/duckdb/pull/13158
• [Explain (mostly internal only)] Change the way key-value pairs of information are stored for RenderTreeNodes by @Tishj in https://github.com/duckdb/duckdb/pull/13109
• Fixup invocation of clang-tidy by @carlopi in https://github.com/duckdb/duckdb/pull/13216
• [Julia] fix Vector and DataChunk all_valid() checks by @aplavin in https://github.com/duckdb/duckdb/pull/13210
• Fix broken explain (format json) test by @Mytherin in https://github.com/duckdb/duckdb/pull/13218
• Linux 32: avoid packaging Jemalloc, due to regression by @carlopi in https://github.com/duckdb/duckdb/pull/13156
• feat(c): create value support by @Mytherin in https://github.com/duckdb/duckdb/pull/13203
• feat(c): create value support by @Mause in https://github.com/duckdb/duckdb/pull/12140
• fix: 13077: use tmp file for secret writes by @devanbenz in https://github.com/duckdb/duckdb/pull/13170
• Filter paths before scripts/clang-tidy-diff.py by @carlopi in https://github.com/duckdb/duckdb/pull/13220
• [CSV Reader/Progress Bar] Fixes by @pdet in https://github.com/duckdb/duckdb/pull/13207
• Use poll in httplib by @Mytherin in https://github.com/duckdb/duckdb/pull/13223
• Fix several fuzzer issues by @Mytherin in https://github.com/duckdb/duckdb/pull/13240
• Fix #13238 - cannot return constant vector for volatile functions with more than one row as input by @Mytherin in https://github.com/duckdb/duckdb/pull/13241
• Rename FORCE_CHECKPOINT to ALWAYS_CHECKPOINT by @Mytherin in https://github.com/duckdb/duckdb/pull/13242
• C API test fix - correctly use length also in non-inlined case by @Mytherin in https://github.com/duckdb/duckdb/pull/13243
• Rollback optimistic writers when all rows we have inserted are deleted by @Mytherin in https://github.com/duckdb/duckdb/pull/13236
• Add serialization support and fix ToString of ChangeOwnershipInfo by @Mytherin in https://github.com/duckdb/duckdb/pull/13233
• Fix #13200: Transactions that update tables need to keep the underlying row group collection alive to ensure we can safely clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/13230
• [CSV Reader] Comment Option by @pdet in https://github.com/duckdb/duckdb/pull/13162
• Fix foreign key lookups from different search path by @ywelsch in https://github.com/duckdb/duckdb/pull/13256
• Add aggregate function support to the C API by @Mytherin in https://github.com/duckdb/duckdb/pull/13229
• Feature #1272: Window Task Blocking by @hawkfish in https://github.com/duckdb/duckdb/pull/13249
• Implement #4318: add overload for pg_get_constraintdef by @Mytherin in https://github.com/duckdb/duckdb/pull/13258
• Several fuzzer fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/13261
• Correctly add profiling information from finalize events to operator timings in EXPLAIN ANALYZE by @Mytherin in https://github.com/duckdb/duckdb/pull/13260
• Issue #13250: Zero Time Buckets by @hawkfish in https://github.com/duckdb/duckdb/pull/13271
• Add delta to CI by @samansmink in https://github.com/duckdb/duckdb/pull/13219
• Remove outadated test that fails somehow randomly and doesn't add much by @carlopi in https://github.com/duckdb/duckdb/pull/13276
• Fix casts logic by @carlopi in https://github.com/duckdb/duckdb/pull/13275
• Executor profiler fix by @Mytherin in https://github.com/duckdb/duckdb/pull/13282
• Avoid clang-tidy-diff to check Python sources or extension folder by @carlopi in https://github.com/duckdb/duckdb/pull/13279
• Enable yacc stack growing by @Mytherin in https://github.com/duckdb/duckdb/pull/13280
• Fix #13272: correctly read signed integer stats for TIMETZ by @Mytherin in https://github.com/duckdb/duckdb/pull/13283
• [Upsert] Fix crash caused by scanning an empty LocalTableStorage by @Tishj in https://github.com/duckdb/duckdb/pull/13281
• Internal #2681: IEJoin Progress by @hawkfish in https://github.com/duckdb/duckdb/pull/13284
• Move to latest duckdb-wasm (fixing COI compilation) by @carlopi in https://github.com/duckdb/duckdb/pull/13257
• [DEV] CSV Tests Refactor and Sniffer decoupled of the vector size by @pdet in https://github.com/duckdb/duckdb/pull/13231
• [TemporaryFileManager] Fix bug causing sizes of .block files to not be counted towards max_temp_directory_size by @Tishj in https://github.com/duckdb/duckdb/pull/13278
• [CSV Reader] Properly cleanup invalid rows by @pdet in https://github.com/duckdb/duckdb/pull/13262
• Disable website docs CI run by @Mytherin in https://github.com/duckdb/duckdb/pull/13288
• Window Task Scheduling: avoid blocking tasks during GETDATA by @Mytherin in https://github.com/duckdb/duckdb/pull/13290
• Fix #12582: correctly deal with empty grouping sets mixed with non-empty ones in lateral joins/correlated subqueries by @Mytherin in https://github.com/duckdb/duckdb/pull/13291
• Reduce memory usage of test by @Mytherin in https://github.com/duckdb/duckdb/pull/13292
• Move back from handrolled checkout to GH action + skip some verification in memory-intensive tests in CI by @carlopi in https://github.com/duckdb/duckdb/pull/13296
• C API extensions by @samansmink in https://github.com/duckdb/duckdb/pull/12682
• Secret settings cascade by @samansmink in https://github.com/duckdb/duckdb/pull/13167
• Fix CMake for when folders are not git folders via git rev-parse --is-inside-work-tree by @carlopi in https://github.com/duckdb/duckdb/pull/13315
• [Dev] Fix breakage caused by adjusting duckdb.h directly by @Tishj in https://github.com/duckdb/duckdb/pull/13321
• CAPI extensions: Fixup list of exported functions for wasm by @carlopi in https://github.com/duckdb/duckdb/pull/13320
• [Python Dev] Make cursor creation threadsafe, perform compaction on the internal vector by @Tishj in https://github.com/duckdb/duckdb/pull/13319
• [Dev] Make (previously implicit) assertion explicit for DuckTransactionManager by @Tishj in https://github.com/duckdb/duckdb/pull/13307
• [PySpark] Fix filter type checking and isin column expression return type by @khalidmammadov in https://github.com/duckdb/duckdb/pull/13294
• Fix clang-format version in CONTRIBUTING.md by @JelteF in https://github.com/duckdb/duckdb/pull/13324
• Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/13322
• Fix #13237: fix .mode insert float column output by @flashmouse in https://github.com/duckdb/duckdb/pull/13308
• Add CUMULATIVE_CARDINALITY metric by @maiadegraaf in https://github.com/duckdb/duckdb/pull/13234
• Fuzzer #3113: Lead Lag Shift by @hawkfish in https://github.com/duckdb/duckdb/pull/13330
• Implemented list_extract with VectorOperations::Copy by @Maxxen in https://github.com/duckdb/duckdb/pull/13313
• Issue template: Fix Arrow extension link by @szarnyasg in https://github.com/duckdb/duckdb/pull/13333
• NO_PARTITION_COLUMNS option to skip partition writes for Parquet copy by @ykskb in https://github.com/duckdb/duckdb/pull/12886
• Format Python README by @szarnyasg in https://github.com/duckdb/duckdb/pull/13340
• Bug/Regression fixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/13317
• Enable unnesting lists of arrays by @Maxxen in https://github.com/duckdb/duckdb/pull/13342
• Limit relation has wrong relation type by @pdet in https://github.com/duckdb/duckdb/pull/13343
• [Dev] Remove redundant variable from SQLStatement by @Tishj in https://github.com/duckdb/duckdb/pull/13341
• Internal #2722: Partition State Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/13350
• Adding hyperbolic trigonometric functions by @nickgerrets in https://github.com/duckdb/duckdb/pull/13346
• CSV Sniffer - Error Messages by @pdet in https://github.com/duckdb/duckdb/pull/13355
• Fix a typo by @SYaoJun in https://github.com/duckdb/duckdb/pull/13360
• Add PySpark head, take and first functions by @khalidmammadov in https://github.com/duckdb/duckdb/pull/13349
• [Explain] Add the GRAPHVIZ format for EXPLAIN statements by @Tishj in https://github.com/duckdb/duckdb/pull/13201
• Time cast: Have same behavior as Postgres by @pdet in https://github.com/duckdb/duckdb/pull/13267
• Fix reordering semi joins by @Tmonster in https://github.com/duckdb/duckdb/pull/13335
• Fix appian join tests by @Tmonster in https://github.com/duckdb/duckdb/pull/13356
• remove sqlsmith patch by @Tmonster in https://github.com/duckdb/duckdb/pull/13334
• Support Json Types in CSV Reader by @pdet in https://github.com/duckdb/duckdb/pull/13359
• [CSV Sniffer] Date/Timestamp Sniffing adjustment by @pdet in https://github.com/duckdb/duckdb/pull/13168
• WAL: Write pointers to optimistically written row groups directly, instead of copying over the data by @Mytherin in https://github.com/duckdb/duckdb/pull/13372
• [Metrics] Add CUMULATIVE_ROWS_SCANNED and OPERATOR_ROWS_SCANNED by @maiadegraaf in https://github.com/duckdb/duckdb/pull/13354
• [Transformer] Fix loss of named parameter data in recursive TransformStatement calls by @Tishj in https://github.com/duckdb/duckdb/pull/13344
• Feature #1272: Window Distinct Merging by @hawkfish in https://github.com/duckdb/duckdb/pull/13329
• Refine heuristic for flipping join sides by @lnkuiper in https://github.com/duckdb/duckdb/pull/13399
• Update jemalloc and re-enable opt.retain by @lnkuiper in https://github.com/duckdb/duckdb/pull/13370
• Add native list_has_all implementation by @Maxxen in https://github.com/duckdb/duckdb/pull/13401
• Feature #1272: Window Distinct Indices by @hawkfish in https://github.com/duckdb/duckdb/pull/13394
• [Arrow] Support consuming an "arrow_array_stream" PyCapsule by @Tishj in https://github.com/duckdb/duckdb/pull/13386
• Sample at least one value for the hyperloglog by @Tmonster in https://github.com/duckdb/duckdb/pull/13383
• Fix issues with JSON map inference by @lnkuiper in https://github.com/duckdb/duckdb/pull/13387
• Compressed materialization for joins by @lnkuiper in https://github.com/duckdb/duckdb/pull/13402
• Python installation: Recommend using pip by @szarnyasg in https://github.com/duckdb/duckdb/pull/13357
• [Python UDF] Filter NULL values before calling the user defined function by @Tishj in https://github.com/duckdb/duckdb/pull/13358
• Add support for scalar function overloads to the C API by @Mytherin in https://github.com/duckdb/duckdb/pull/13409
• Fix unused variable, resolve warning turned error in the amalgamation CI by @carlopi in https://github.com/duckdb/duckdb/pull/13408
• Add support for aggregate function overloads to the C API by @Mytherin in https://github.com/duckdb/duckdb/pull/13410
• Fix lossy double cast issue by @lnkuiper in https://github.com/duckdb/duckdb/pull/13411
• Buffer manager: set handle readers after I/O so that any I/O exceptions don't leave the readers with an invalid value by @Mytherin in https://github.com/duckdb/duckdb/pull/13417
• fix undefined symbol in httpfs for python by @cyberjunk in https://github.com/duckdb/duckdb/pull/13420
• Fix dsdgen args by @Tmonster in https://github.com/duckdb/duckdb/pull/13421
• [Arrow] Support producing an "arrow_array_stream" PyCapsule by @Tishj in https://github.com/duckdb/duckdb/pull/13418
• Disable jemalloc on 32bit through cmake, not through a CI script by @lnkuiper in https://github.com/duckdb/duckdb/pull/13433
• allow changing the default persistent secret storage after initialization by @samansmink in https://github.com/duckdb/duckdb/pull/13434
• Fixing hugeint cast to varint by @pdet in https://github.com/duckdb/duckdb/pull/13268
• [Explain] Add the HTML format for EXPLAIN statements by @Tishj in https://github.com/duckdb/duckdb/pull/13202
• fix for the issue 2698 by @hmeriann in https://github.com/duckdb/duckdb/pull/13440
• Avoid rounding errors and simplify memory assignments in TemporaryMemoryManager by @lnkuiper in https://github.com/duckdb/duckdb/pull/13439
• Pull up filters from and through explicit joins by @lnkuiper in https://github.com/duckdb/duckdb/pull/13431
• [Metadata] Populate the expressions column of duckdb_indexes by @Tishj in https://github.com/duckdb/duckdb/pull/13415
• Use LossyNumericCast while reading memory limits by @carlopi in https://github.com/duckdb/duckdb/pull/13450
• Label timestampTZ to timestamp cast as not revertible by @Tmonster in https://github.com/duckdb/duckdb/pull/13206
• Prevent the query thread from picking up query unrelated tasks if compiled with DUCKDB_NO_THREADS by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/13326
• [Dev] Skip test on lower pyarrow versions by @Tishj in https://github.com/duckdb/duckdb/pull/13463
• Add TPCDS sf-100 benchmarks by @hmeriann in https://github.com/duckdb/duckdb/pull/13205
• [Python] Let create_function cancel an open transaction instead of failing by @Tishj in https://github.com/duckdb/duckdb/pull/13462
• [Dev] Mention non-unique indexes in UPSERT DO UPDATE SET error by @Tishj in https://github.com/duckdb/duckdb/pull/13465
• Issue #13380: IN Invertible Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/13441
• Compilation Fixes for GCC 4.8 by @hannes in https://github.com/duckdb/duckdb/pull/13474
• [Dev] Make Binder::Binder a private constructor by @Tishj in https://github.com/duckdb/duckdb/pull/13475
• [Arrow] Accept objects that provide the __arrow_c_stream__ producer method by @Tishj in https://github.com/duckdb/duckdb/pull/13425
• [Lambdas] Support N-ary lambdas in the list comprehension syntax by @Tishj in https://github.com/duckdb/duckdb/pull/13389
• [METRICS] Add blocked_thread_time Metric by @maiadegraaf in https://github.com/duckdb/duckdb/pull/13430
• Add ifdef to allow generating code with newer versions of Bison by @Mytherin in https://github.com/duckdb/duckdb/pull/13477
• Clean up rendered text trees by @Mytherin in https://github.com/duckdb/duckdb/pull/13476
• Make CMake target exports relocatable by @cryos in https://github.com/duckdb/duckdb/pull/13312
• Disable delta extension on windows for now by @Mytherin in https://github.com/duckdb/duckdb/pull/13485
• Regression runner - don't fail on HTTP error by @Mytherin in https://github.com/duckdb/duckdb/pull/13486
• ExecutorTask: flush before finalizing task by @Mytherin in https://github.com/duckdb/duckdb/pull/13482
• [Metrics] Rework Optimizer Metrics by @maiadegraaf in https://github.com/duckdb/duckdb/pull/13480
• Support collations in ordered aggregates by @Mytherin in https://github.com/duckdb/duckdb/pull/13491
• ci: minor optional cleanup for cibuildwheel config by @henryiii in https://github.com/duckdb/duckdb/pull/13496
• chore: remove wheel dependency by @henryiii in https://github.com/duckdb/duckdb/pull/13495
• Prefer depth-first plan evaluation for unions and joins by @lnkuiper in https://github.com/duckdb/duckdb/pull/13447
• Fix #13472: get correct WAL location for windows long paths by @Mytherin in https://github.com/duckdb/duckdb/pull/13487
• Make error message more explicit for when trying to parse SQL types. by @pdet in https://github.com/duckdb/duckdb/pull/13376
• [Arrow] Add UUID and JSON extension types by @pdet in https://github.com/duckdb/duckdb/pull/13446
• Apply extension patches via 'patch' instead of 'git apply' by @carlopi in https://github.com/duckdb/duckdb/pull/13488
• Feature #1272: Window Distinct Tree by @hawkfish in https://github.com/duckdb/duckdb/pull/13503
• Scalar macro default params by @Alex-Monahan in https://github.com/duckdb/duckdb/pull/13494
• Add Varint to AllTypes() by @pdet in https://github.com/duckdb/duckdb/pull/13388
• [ADBC] Support creation and ingestion into temporary tables. by @pdet in https://github.com/duckdb/duckdb/pull/13426
• Add support for registering custom casts (and types) through c api by @Maxxen in https://github.com/duckdb/duckdb/pull/13499
• Bump sqlite & mysql by @carlopi in https://github.com/duckdb/duckdb/pull/13515
• Switch floating point division and modulo to use IEEE semantics for division by zero by default, and add ieee_floating_point_ops setting that can be used to revert back to old behavior by @Mytherin in https://github.com/duckdb/duckdb/pull/13493
• [C API] Get all metrics by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13497
• Tuning ART indexes for duplicate values by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13373
• Feature #1272: Windowed Quantile Tree by @hawkfish in https://github.com/duckdb/duckdb/pull/13516
• [Auto Loading] Autoload extension settings by @Tishj in https://github.com/duckdb/duckdb/pull/12790
• JSON bugfixes and new functions by @lnkuiper in https://github.com/duckdb/duckdb/pull/13481
• Make changes to relation.hpp backward compatible with older API via default parameters by @carlopi in https://github.com/duckdb/duckdb/pull/13522
• Preserve cardinality information by @jeewonhh in https://github.com/duckdb/duckdb/pull/13517
• Return an error when multiple rows are returned from a scalar subquery by @Mytherin in https://github.com/duckdb/duckdb/pull/13514
• When referencing optimistically-written blocks in the WAL, we need to fsync the main database file before writing the WAL to ensure all changes have made it to disk by @Mytherin in https://github.com/duckdb/duckdb/pull/13526
• Remove assertion in compressed file system by @Maxxen in https://github.com/duckdb/duckdb/pull/13531
• Skip empty files in single-threaded CSV reader by @pdet in https://github.com/duckdb/duckdb/pull/13528
• Disallow ordering by non-integer literal by default - and add the setting order_by_non_integer_literal to revert to the previous behavior by @Mytherin in https://github.com/duckdb/duckdb/pull/13532
• Produce an empty list result for enum_range(NULL::enum_type) by @pdet in https://github.com/duckdb/duckdb/pull/13530
• [CSV Reader] Fix for invalid unicode in header by @pdet in https://github.com/duckdb/duckdb/pull/13518
• Issue #13525: Window Local States by @hawkfish in https://github.com/duckdb/duckdb/pull/13538
• Linux32 also to regular ci by @carlopi in https://github.com/duckdb/duckdb/pull/13547
• Feature #1272: Windowed Distinct Tree by @hawkfish in https://github.com/duckdb/duckdb/pull/13527
• Bump GitHub workflows to their latest versions by @deining in https://github.com/duckdb/duckdb/pull/13393
• Add map_contains, map_contains_entry and map_contains_value functions, list_position now returns null. by @Maxxen in https://github.com/duckdb/duckdb/pull/13406
• Numeric casts: forbid NumericCasts for float/double, add Lossy and Exact equivalent to make syntax explicit by @carlopi in https://github.com/duckdb/duckdb/pull/13546
• Fix clang-tidy on insertion_order_preserving_map.hpp: Alter order of statements by @carlopi in https://github.com/duckdb/duckdb/pull/13556
• Add http proxy by @samansmink in https://github.com/duckdb/duckdb/pull/13368
• move the inet extension out-of-tree by @chrisiou in https://github.com/duckdb/duckdb/pull/13085
• Fix compilation: install extension needs an instance now by @Mytherin in https://github.com/duckdb/duckdb/pull/13565
• Initialize (potentially) empty buffer by @lnkuiper in https://github.com/duckdb/duckdb/pull/13564
• HTTP glob test fix by @Mytherin in https://github.com/duckdb/duckdb/pull/13563
• Remove patches (vss and substrait), bump other repositories by @carlopi in https://github.com/duckdb/duckdb/pull/13551
• Disable dynamic filter pushdown for right semi joins by @Mytherin in https://github.com/duckdb/duckdb/pull/13562
• postgres_scanner: bump & remove patches by @carlopi in https://github.com/duckdb/duckdb/pull/13567
• Optimistic write to WAL: cannot write block pointers if we have in-memory updates to transaction local storage by @Mytherin in https://github.com/duckdb/duckdb/pull/13577
• Add all CAPI functions to extension api for now by @samansmink in https://github.com/duckdb/duckdb/pull/13568
• Minor fixes for DuckDB-Wasm by @carlopi in https://github.com/duckdb/duckdb/pull/13566
• Fix for vector size 2 tests by @Mytherin in https://github.com/duckdb/duckdb/pull/13569
• [CSV Sniffer] Date Adjustment by @pdet in https://github.com/duckdb/duckdb/pull/13573
• Fix issues found by alternative verify by @Mytherin in https://github.com/duckdb/duckdb/pull/13578
• Set version info for duckdb.dll by @Giorgi in https://github.com/duckdb/duckdb/pull/13557
• Update storage info by @szarnyasg in https://github.com/duckdb/duckdb/pull/13483
• Constrain size of estimated cardinality returned when operator is not initialized by @Mytherin in https://github.com/duckdb/duckdb/pull/13574
• Unify task (un)blocking in physical operators by @lnkuiper in https://github.com/duckdb/duckdb/pull/13559
• [CSV Reader] Fix lock issue on Global CSV Reader by @pdet in https://github.com/duckdb/duckdb/pull/13560
• TIMETZ group by: collations now no longer always return VARCHAR by @Mytherin in https://github.com/duckdb/duckdb/pull/13571
• Internal #2850: Window Local States by @hawkfish in https://github.com/duckdb/duckdb/pull/13581
• Two steps upload action by @carlopi in https://github.com/duckdb/duckdb/pull/13582
• Use new HLL implementation in DistinctStatistics by @lnkuiper in https://github.com/duckdb/duckdb/pull/13489
• Remove inet from extension update test by @Mytherin in https://github.com/duckdb/duckdb/pull/13589
• [METRICS] Small fixes by @maiadegraaf in https://github.com/duckdb/duckdb/pull/13575
• Fix #13537: correctly maintain parameter count when rebinding a prepared statement by @Mytherin in https://github.com/duckdb/duckdb/pull/13583
• Various nightly test fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/13584
• IE Join: turn these into atomics to prevent tsan from tripping up in GetProgress by @Mytherin in https://github.com/duckdb/duckdb/pull/13586
• Fix HTTPFS tests by @Mytherin in https://github.com/duckdb/duckdb/pull/13588
• [PyArrow] Fix issue with passing timestamp types to filters by @pdet in https://github.com/duckdb/duckdb/pull/13593
• Fuzzer fixes by @Tmonster in https://github.com/duckdb/duckdb/pull/13596
• Automatically call malloc_trim to reduce unused outstanding allocations by @lnkuiper in https://github.com/duckdb/duckdb/pull/13590
• Fix for joins and FSST on 32-bit configurations by @Mytherin in https://github.com/duckdb/duckdb/pull/13594
• Casting to Bit is no longer Invertible by @Tmonster in https://github.com/duckdb/duckdb/pull/13595
• Switch in-tree DuckDB extension to use DuckDB's semver tag by @samansmink in https://github.com/duckdb/duckdb/pull/13591
• List has bind fix by @Maxxen in https://github.com/duckdb/duckdb/pull/13600
• Do not include version.rc file on MINGW by @Giorgi in https://github.com/duckdb/duckdb/pull/13601
• [Python RelAPI] Throw an error if trying to use a invalid argument in read_csv by @pdet in https://github.com/duckdb/duckdb/pull/13597
• More nightly test fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/13605
• Optimistic write to WAL: we cannot optimistically write block pointers if there are indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/13610
• Block verification run and FixedSizeBuffer fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13607
• [Test] Tighter ART storage regression boundaries by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13612
• Disable JEMALLOC_HAVE_MADVISE_HUGE in jemalloc by @lnkuiper in https://github.com/duckdb/duckdb/pull/13608
• Avoid adding buffers that will be destroyed to the eviction queue by @lnkuiper in https://github.com/duckdb/duckdb/pull/13606
• Track overflow strings in PartialBlockManager during optimistic write by @Mytherin in https://github.com/duckdb/duckdb/pull/13618
• [Fix] Avoid index deletion after catalog exception by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13627

Full Changelog: v1.0.0...v1.1.0