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 https://github.com/duckdb/duckdb/pull/11146 * Make `MultiFileReader` filename configurable by @lnkuiper in https://github.com/duckdb/duckdb/pull/11178 * [Dev] Fix compilation issues on `feature` by @Tishj in https://github.com/duckdb/duckdb/pull/11082 * add query() and query_table() functions by @chrisiou in https://github.com/duckdb/duckdb/pull/10586 * [Block Size] Move the block allocation size into the block manager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11176 * LIMIT pushdown below PROJECT by @jeewonhh in https://github.com/duckdb/duckdb/pull/11112 * BUGFIX: IN () filter with one argument should translate to = filter. by @Tmonster in https://github.com/duckdb/duckdb/pull/11473 * Regression Script should calculate micro benchmark differences with the correct base branch by @Tmonster in https://github.com/duckdb/duckdb/pull/11762 * Pushdown filters on window partitions by @Tmonster in https://github.com/duckdb/duckdb/pull/10932 * Arrow ListView Type by @Tishj in https://github.com/duckdb/duckdb/pull/10766 * Add scalar function support to the C API by @Mytherin in https://github.com/duckdb/duckdb/pull/11786 * Add TopN optimization in physical plan mapping by @kryonix in https://github.com/duckdb/duckdb/pull/11290 * Join-dependent filter derivation by @lnkuiper in https://github.com/duckdb/duckdb/pull/11272 * Implement `ROW_GROUPS_PER_FILE` for Parquet by @lnkuiper in https://github.com/duckdb/duckdb/pull/11249 * Prefer Final projected columns on probe side if cardinalities are similar by @Tmonster in https://github.com/duckdb/duckdb/pull/11109 * Propagate unused columns to distinct on by @Tmonster in https://github.com/duckdb/duckdb/pull/11006 * Separate eviction queues by `FileBufferType` by @lnkuiper in https://github.com/duckdb/duckdb/pull/11417 * Disable false positive for vector size nightly in test by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11953 * Rework jemalloc extension by @lnkuiper in https://github.com/duckdb/duckdb/pull/11891 * Tweak jemalloc config by @lnkuiper in https://github.com/duckdb/duckdb/pull/12034 * Httpfs test to nightly by @carlopi in https://github.com/duckdb/duckdb/pull/12196 * Removed three reinterpret casts and some rewriting by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12200 * Begin Profiling Rework to move towards Modularity by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11101 * [CLI] Add highlighting + limited auto-complete for shell dot commands by @Mytherin in https://github.com/duckdb/duckdb/pull/12201 * Skip test to fix block size nightly and add more explicit error checking by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12211 * Remove BLOCK_ALLOC_SIZE from the column segment files by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11474 * [Julia] - Added optional `schema` input argument to `DuckDB.Appender` constructor by @curtd in https://github.com/duckdb/duckdb/pull/12174 * Fix Mark Index in the Bound Join Ref by @pdet in https://github.com/duckdb/duckdb/pull/12263 * Fix for CI Regression Failure by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12273 * 🦆 by @samansmink in https://github.com/duckdb/duckdb/pull/12303 * Disable `JEMALLOC_RETAIN` by @lnkuiper in https://github.com/duckdb/duckdb/pull/12185 * Enforce compression extensions for CSV Files by @pdet in https://github.com/duckdb/duckdb/pull/11903 * Make spuriously failing test more robust by @lnkuiper in https://github.com/duckdb/duckdb/pull/12306 * Add new extensions to issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/12313 * [Fix] Block size nightly run by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12283 * Spell Check | Nothing Major | Corrected base_scanner.cpp by @nj7 in https://github.com/duckdb/duckdb/pull/12282 * add duckdb_bind_timestamp_tz function to C API by @karlseguin in https://github.com/duckdb/duckdb/pull/12151 * [Python] Add some date/datetime functions to pyspark api by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12075 * Fixes to Windows workflow and ubuntu_18 action by @carlopi in https://github.com/duckdb/duckdb/pull/12308 * [Extension Dev] Forward declare re2 in `hive_partitioning.hpp` by @Tishj in https://github.com/duckdb/duckdb/pull/12302 * add expected errors to test/sql/copy/per_thread_output.test by @hmeriann in https://github.com/duckdb/duckdb/pull/12280 * Issue #12287: ICU Strptime Lists by @hawkfish in https://github.com/duckdb/duckdb/pull/12295 * Issue #12171: Streaming Window FILTER by @hawkfish in https://github.com/duckdb/duckdb/pull/12250 * [Python] Update the Connection wrapper generation, now generates c++ code by @Tishj in https://github.com/duckdb/duckdb/pull/12216 * Use iterator buffer position when storing buffer handles by @pdet in https://github.com/duckdb/duckdb/pull/12315 * Bump Julia client to v0.10.3 by @Mytherin in https://github.com/duckdb/duckdb/pull/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 https://github.com/duckdb/duckdb/pull/12318 * [Fix] Only read file size if file handle still exists by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12319 * Add support for APPEND argument to hive partitioned write by @Mytherin in https://github.com/duckdb/duckdb/pull/12262 * Remove all reinterpret casts from the transformer by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12320 * Additional check for overlapping CTE names by @lnkuiper in https://github.com/duckdb/duckdb/pull/12305 * [Dev] `STANDARD_VECTOR_SIZE` and `BLOCK_ALLOC_SIZE` can now be set through the Makefile by @Tishj in https://github.com/duckdb/duckdb/pull/12164 * [Upsert] Fix issue with lambdas in `DO UPDATE SET` expressions by @Tishj in https://github.com/duckdb/duckdb/pull/11866 * [Python] Fix scoping issue for `pandas_analyze_sample` setting by @Tishj in https://github.com/duckdb/duckdb/pull/11706 * Support REGEX matches expected error message by @hmeriann in https://github.com/duckdb/duckdb/pull/12327 * Allow run_fuzzer to reduce multi statements. by @Tmonster in https://github.com/duckdb/duckdb/pull/12278 * Fix #12328 - when flattening STRUCT vectors with NULL values, we need to flatten the children recursively as well by @Mytherin in https://github.com/duckdb/duckdb/pull/12332 * Make `dbgen` generate data in parallel by @Mytherin in https://github.com/duckdb/duckdb/pull/12337 * dbgen: skip parallel generation if DUCKDB_NO_THREADS is set by @Mytherin in https://github.com/duckdb/duckdb/pull/12341 * Add prefix prefix_front_back. to get prefix_front_ and prefix_back_ by @liujiayi771 in https://github.com/duckdb/duckdb/pull/12344 * Issue #12171: Streaming Windowed DISTINCT by @hawkfish in https://github.com/duckdb/duckdb/pull/12311 * Update README by @szarnyasg in https://github.com/duckdb/duckdb/pull/12357 * [CSV Reader] [Skip Option] Tests and fixes by @pdet in https://github.com/duckdb/duckdb/pull/12213 * Adjust BM25 score in FTS extension to prevent negative scores by @lnkuiper in https://github.com/duckdb/duckdb/pull/12356 * Fix typos by @szarnyasg in https://github.com/duckdb/duckdb/pull/12360 * Fix #12293 - accept NULL values in generate_series with timestamp by @Mytherin in https://github.com/duckdb/duckdb/pull/12367 * Fix #12335: avoid calling fsync when writing Parquet files, instead just close the file by @Mytherin in https://github.com/duckdb/duckdb/pull/12371 * Fix parameters passed down to other workflows in OnTag.yml by @carlopi in https://github.com/duckdb/duckdb/pull/12369 * [Python] Fixes for the SQLLogicTest runner implementation by @Tishj in https://github.com/duckdb/duckdb/pull/12372 * Bump julia to v1.0.0 by @Mytherin in https://github.com/duckdb/duckdb/pull/12379 * Fix #11921 - varchar -> timestamp casts are not invertible by @Mytherin in https://github.com/duckdb/duckdb/pull/12376 * Upgrade utf8proc - and move our custom extensions out of utf8proc itself by @Mytherin in https://github.com/duckdb/duckdb/pull/12373 * change max_queries number back to 2000 by @Tmonster in https://github.com/duckdb/duckdb/pull/12375 * Remove sqlsmith extension by @Tmonster in https://github.com/duckdb/duckdb/pull/12300 * Reorder semi and anti joins. by @Tmonster in https://github.com/duckdb/duckdb/pull/11815 * Issue #12351: implicit cast to `TIMESTAMP_MS`, `TIMESTAMP_S`, `TIMESTAMP_NS` from `DATE` values by @akoshchiy in https://github.com/duckdb/duckdb/pull/12352 * Issue #10023: Approx_Count_Distinct Memory Usage by @hawkfish in https://github.com/duckdb/duckdb/pull/12355 * Fix a small typo in dev instructions for swift setup by @gjmwoods in https://github.com/duckdb/duckdb/pull/12383 * Release lock before returning `BufferHandle` in `StandardBufferManager::Pin` by @lnkuiper in https://github.com/duckdb/duckdb/pull/12391 * Remote attach autoload by @carlopi in https://github.com/duckdb/duckdb/pull/12393 * Add JSON type to Parquet reader/writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/12222 * Add `RETURN_FILES` parameter to `COPY TO` by @lnkuiper in https://github.com/duckdb/duckdb/pull/12220 * Updated JoinHashTable to use linear probing to resolve hash collisions by @gropaul in https://github.com/duckdb/duckdb/pull/11472 * [Benchmark Runner] Add `--disable-timeout` flag by @Tishj in https://github.com/duckdb/duckdb/pull/12387 * Don't replace unicode spaces within `$$` quotes in query strings by @lnkuiper in https://github.com/duckdb/duckdb/pull/12405 * [Python] Fix fatal exception caused by empty Pandas Categorical objects. by @Tishj in https://github.com/duckdb/duckdb/pull/12370 * Release CSV Blocks when acquiring new blocks if single threaded by @pdet in https://github.com/duckdb/duckdb/pull/12409 * Add support for prefetching multiple adjacent blocks in a single batched read when attaching to remote databases by @Mytherin in https://github.com/duckdb/duckdb/pull/12413 * MatchRegex() fixed to do not return false positive result by @hmeriann in https://github.com/duckdb/duckdb/pull/12396 * Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/12392 * [C-API] Catch exception in `duckdb_execute_prepared` by @Tishj in https://github.com/duckdb/duckdb/pull/12414 * Combining LIST_CONCAT and CONCAT binding by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12317 * [Appender] Add `AppendDefault` by @Tishj in https://github.com/duckdb/duckdb/pull/11905 * [Python Dev] Push CTE internally for every (python) replacement scan that occurred. by @Tishj in https://github.com/duckdb/duckdb/pull/12161 * Improve compiler compatibility by @krlmlr in https://github.com/duckdb/duckdb/pull/12401 * Write zero-length list offsets for NULL values when serializing vectors by @Mytherin in https://github.com/duckdb/duckdb/pull/12423 * Get column statistics if Logical Get has a statistics function by @jeewonhh in https://github.com/duckdb/duckdb/pull/12424 * jemalloc: Identify GNU source code properly by @lnkuiper in https://github.com/duckdb/duckdb/pull/12420 * Avoid parallelizing LIMIT clauses when the query plan is simple by @Mytherin in https://github.com/duckdb/duckdb/pull/12433 * Prefetch metadata blocks for remote files by @Mytherin in https://github.com/duckdb/duckdb/pull/12437 * [Jupyter] Remove width limit on the BoxRenderer config by @Tishj in https://github.com/duckdb/duckdb/pull/12443 * Revert duckdb/duckdb#10865 by @carlopi in https://github.com/duckdb/duckdb/pull/12426 * inline delta by @samansmink in https://github.com/duckdb/duckdb/pull/12435 * Account for _tagged_ dollar-quoted strings when stripping unicode spaces by @lnkuiper in https://github.com/duckdb/duckdb/pull/12421 * Work-around for broken github windows runner by @Mytherin in https://github.com/duckdb/duckdb/pull/12447 * Prevents clearing of the types of the LogicalExecute operator by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/12436 * Add support for BEGIN TRANSACTION READ ONLY by @Mytherin in https://github.com/duckdb/duckdb/pull/12202 * Make `range` and `generate_series` table in-out functions, and fix several issues with table in-out functions by @Mytherin in https://github.com/duckdb/duckdb/pull/12431 * Issue #12412: AsOf Filter Push by @hawkfish in https://github.com/duckdb/duckdb/pull/12448 * [Fix] Block Size Nightly by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12427 * [ART] Remove Flatten and template key generation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12428 * [Python] Clean up internals of `execute` / `executemany` by @Tishj in https://github.com/duckdb/duckdb/pull/12434 * By default attach remote databases as READ_ONLY by @carlopi in https://github.com/duckdb/duckdb/pull/12461 * Fix #11837: use internal physical type for FIRST/LAST/ANY_VALUE instead of logical type by @Mytherin in https://github.com/duckdb/duckdb/pull/12462 * Issue #12464: Windowed Order By All by @hawkfish in https://github.com/duckdb/duckdb/pull/12470 * Specialize `list_value` for primitive types for significantly improved performance by @Mytherin in https://github.com/duckdb/duckdb/pull/12468 * [Dev] Remove dead code from `PhysicalBatchCopyToFile` by @Tishj in https://github.com/duckdb/duckdb/pull/12459 * Disable Windows extensions CI until Github actions runners are fixed by @Mytherin in https://github.com/duckdb/duckdb/pull/12479 * [Fix] access_mode now lives in AttachOptions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12482 * Internal #2186: Nanosecond Functionality by @hawkfish in https://github.com/duckdb/duckdb/pull/12440 * [C-API] Fix leak in `duckdb_create_config` by @Tishj in https://github.com/duckdb/duckdb/pull/12465 * [Python] No longer scan the entire frame lineage in a replacement scan, added option to disable (python) replacements entirely by @Tishj in https://github.com/duckdb/duckdb/pull/12425 * throw binder error for comment on system catalog by @samansmink in https://github.com/duckdb/duckdb/pull/12486 * Parquet reader performance by @lnkuiper in https://github.com/duckdb/duckdb/pull/12478 * Operators the Optimizer can skip by @Tmonster in https://github.com/duckdb/duckdb/pull/12489 * Fixes clang conversion warnings by @TinyTinni in https://github.com/duckdb/duckdb/pull/12467 * Avoid creating internal schemas as non-internal when reading old database files by @Mytherin in https://github.com/duckdb/duckdb/pull/12456 * Allow parquet encryption/decryption keys to be passed in as base64 encoded strings by @elefeint in https://github.com/duckdb/duckdb/pull/12445 * [Block Size] Introducing CompressionInfo by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12481 * add the number of filtered files to explain by @samansmink in https://github.com/duckdb/duckdb/pull/12488 * Implement Map Type Detection for JSON Reader by @ZiyaZa in https://github.com/duckdb/duckdb/pull/11285 * [Dev] Remove busy-spin from `ClientContext::ExecuteTaskInternal` by @Tishj in https://github.com/duckdb/duckdb/pull/12483 * Pluggable collations by @Mytherin in https://github.com/duckdb/duckdb/pull/12492 * [Dev] Don't fail `make generate-files` if the python code generation fails by @Tishj in https://github.com/duckdb/duckdb/pull/12500 * Optimize `EXTRACT(year/month/day FROM date/timestamp)` by @Mytherin in https://github.com/duckdb/duckdb/pull/12499 * [Fix] Remove BLOCK_ALLOC_SIZE in the single file block manager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12502 * Revert Windows CI fixes by @carlopi in https://github.com/duckdb/duckdb/pull/12510 * Fix duckdb/duckdb#12467 changes to covariance calculation by @carlopi in https://github.com/duckdb/duckdb/pull/12515 * [Python] Fix reading strided `datetime` and `timedelta` columns by @Tishj in https://github.com/duckdb/duckdb/pull/12519 * Add method for decoding sort keys, and use this in min/max for arbitrary types by @Mytherin in https://github.com/duckdb/duckdb/pull/12520 * Reduce allocations & use predication in ColumnSegment::FilterSelection by @Mytherin in https://github.com/duckdb/duckdb/pull/12521 * Skip only built-in optimizers by @Mytherin in https://github.com/duckdb/duckdb/pull/12522 * Improve min/max performance for strings and fallback types by @Mytherin in https://github.com/duckdb/duckdb/pull/12524 * Move arg_min/arg_max to use sort keys by @Mytherin in https://github.com/duckdb/duckdb/pull/12525 * Move FIRST/LAST/ANY_VALUE to use sort keys by @Mytherin in https://github.com/duckdb/duckdb/pull/12526 * CMake: use GNUInstallDirs as defaults for INSTALL_{BIN,LIB,INCLUDE}_DIR by @paparodeo in https://github.com/duckdb/duckdb/pull/12509 * More formatting and fix to stddev by @carlopi in https://github.com/duckdb/duckdb/pull/12516 * Linux Extensions CI: Attempt at fix missing dependencies by @carlopi in https://github.com/duckdb/duckdb/pull/12429 * Fix checkouts by @carlopi in https://github.com/duckdb/duckdb/pull/12366 * Etag if none match for extension install by @carlopi in https://github.com/duckdb/duckdb/pull/12333 * [Block Size] FixedSizeAllocator, MetadataManager, PartialBlockManager by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12514 * [Python] Skip the PandasAnalyzer if dtype is `'string'` by @Tishj in https://github.com/duckdb/duckdb/pull/12511 * [StreamQueryResult] Batched variant of the StreamQueryResult collector by @Tishj in https://github.com/duckdb/duckdb/pull/11494 * Move many tests to slow by @Mytherin in https://github.com/duckdb/duckdb/pull/12534 * Add support for `arg_min(ANY, ANY)` by @Mytherin in https://github.com/duckdb/duckdb/pull/12532 * Avoid overriding types in PrepareTypeForCast when not required by @Mytherin in https://github.com/duckdb/duckdb/pull/12539 * Support all types in `histogram` function by @Mytherin in https://github.com/duckdb/duckdb/pull/12538 * [Python] Remove busy-spin during execution by @Tishj in https://github.com/duckdb/duckdb/pull/12512 * [Block Size] String space constant by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12537 * Use string_t instead of std::string in histogram by @Mytherin in https://github.com/duckdb/duckdb/pull/12545 * Add support for binned histograms by @Mytherin in https://github.com/duckdb/duckdb/pull/12548 * [Upsert] Fix RETURNING for `DO NOTHING` by @Tishj in https://github.com/duckdb/duckdb/pull/12554 * Build Android Binaries by @hannes in https://github.com/duckdb/duckdb/pull/12550 * [CI] Remove pyarrow version lock by @Tishj in https://github.com/duckdb/duckdb/pull/12566 * [Dev] Change tests: np.NaN -> np.nan by @Tishj in https://github.com/duckdb/duckdb/pull/12565 * Internal #2017: DECIMAL Downcast Rounding by @hawkfish in https://github.com/duckdb/duckdb/pull/12036 * Issue #12204: Summarize Temporal Quantiles by @hawkfish in https://github.com/duckdb/duckdb/pull/12297 * Internal #2186: Nanosecond StrTimeFormat by @hawkfish in https://github.com/duckdb/duckdb/pull/12551 * Add support for `equi_width_bins` function to compute histogram boundaries by @Mytherin in https://github.com/duckdb/duckdb/pull/12574 * add support for casting 'yes'/'no' strings to boolean values by @chrisiou in https://github.com/duckdb/duckdb/pull/12501 * Julia: Add chunked results with Tables.partitions() by @frankier in https://github.com/duckdb/duckdb/pull/12395 * [PySpark] - Allow spark session range by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12346 * [PySpark] Implement subset drop duplicates by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12348 * ICU noaccent collation by @tiagokepe in https://github.com/duckdb/duckdb/pull/12170 * Implement Brotli compression for Parquet reading & writing by @hannes in https://github.com/duckdb/duckdb/pull/12103 * [FriendlySQL] Unpacked COLUMNS() Expression by @Tishj in https://github.com/duckdb/duckdb/pull/11872 * [PySpark] Implement UDFRegistration.register method on PySpark api by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/12179 * [Python] Don't use `np.nan`, deprecated alias starting with NumPy 2.0 by @Tishj in https://github.com/duckdb/duckdb/pull/12583 * Add `bind_expression` callback to scalar function, and use it to turn `typeof` into a `BoundConstantExpression` by @Mytherin in https://github.com/duckdb/duckdb/pull/12580 * Add `can_cast_implicitly` scalar function by @Mytherin in https://github.com/duckdb/duckdb/pull/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 https://github.com/duckdb/duckdb/pull/12590 * build: swap libclang for cxxheaderparser by @Mause in https://github.com/duckdb/duckdb/pull/12567 * [C-API] Add `table_description` struct to query various information about the table. by @Tishj in https://github.com/duckdb/duckdb/pull/12460 * Change new micro benchmark script to only look for `.benchmark` files by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12598 * Add HTTP error code to extension install failures by @carlopi in https://github.com/duckdb/duckdb/pull/12608 * Separate WAL write from commit, and allow writing to the WAL without holding the transaction lock by @Mytherin in https://github.com/duckdb/duckdb/pull/12261 * Add `OwningStringMap` - and rework `histogram` and `mode` functions to use this by @Mytherin in https://github.com/duckdb/duckdb/pull/12601 * Feature #1272: Window Executor State by @hawkfish in https://github.com/duckdb/duckdb/pull/12573 * Add support for any type to `mode` aggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/12619 * WAL - when dropping a table, also delete any transaction local storage associated with that table by @Mytherin in https://github.com/duckdb/duckdb/pull/12603 * [Python] Allow Generators to be passed where List is expected by @Tishj in https://github.com/duckdb/duckdb/pull/12602 * VectorOperations::Copy - fast path when copying an aligned flat validity mask into a flat vector by @Mytherin in https://github.com/duckdb/duckdb/pull/12618 * Move android CI to only run during nightly CI triggers by @Mytherin in https://github.com/duckdb/duckdb/pull/12622 * Add initial support for GeoParquet + Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/12503 * Issue #12600: Streaming Positive LAG by @hawkfish in https://github.com/duckdb/duckdb/pull/12609 * Feature #1272: Window Group Preparation by @hawkfish in https://github.com/duckdb/duckdb/pull/12628 * Minor window improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/12617 * Merge feature into main by @Mytherin in https://github.com/duckdb/duckdb/pull/12633 * Refactor `quantile` aggregate - clean up code & support `quantile_disc`/`median` for all types by @Mytherin in https://github.com/duckdb/duckdb/pull/12630 * Feature 1272: Window Payload Preallocation by @hawkfish in https://github.com/duckdb/duckdb/pull/12629 * [ART] Configurable index scan threshold by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12635 * Subtract start offset for when fetching array child segment by @Maxxen in https://github.com/duckdb/duckdb/pull/12639 * Remove custom logic to detect main vs feature by @carlopi in https://github.com/duckdb/duckdb/pull/12643 * Do not quote fields with space in the CSV output mode by @szarnyasg in https://github.com/duckdb/duckdb/pull/12644 * Use lowercase in 'html' output mode by @szarnyasg in https://github.com/duckdb/duckdb/pull/12612 * Internal #2361: Window ROWS Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/12652 * Quantile: Fix variable used only in D_ASSERT by @carlopi in https://github.com/duckdb/duckdb/pull/12642 * Skip pytorch test, it fails spuriously in CI by @carlopi in https://github.com/duckdb/duckdb/pull/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 https://github.com/duckdb/duckdb/pull/12650 * Add operator hook for sink progress by @Maxxen in https://github.com/duckdb/duckdb/pull/12637 * Regression workflow on newly introduced benchmarks: remove for now by @carlopi in https://github.com/duckdb/duckdb/pull/12659 * Fix #12646 - allow SQL value functions in HAVING by @Mytherin in https://github.com/duckdb/duckdb/pull/12654 * Add != operators on string_t and interval_t by @carlopi in https://github.com/duckdb/duckdb/pull/12658 * fix: improve C scalar functions API by @rustyconover in https://github.com/duckdb/duckdb/pull/12663 * Add `approx_top_k` aggregate based on the (Filtered) Space-Saving algorithm, and use it in histogram by @Mytherin in https://github.com/duckdb/duckdb/pull/12653 * Fix std::sort requirements, from greater_equal to greater by @carlopi in https://github.com/duckdb/duckdb/pull/12669 * fix(parquet): two-complement zeroes check on FIXED_BYTE_ARRAY encoded DECIMAL (#12621) by @fedefrancescon in https://github.com/duckdb/duckdb/pull/12655 * [CSV Reader] Reorder of Columns for CSV Scans on multiple files. by @pdet in https://github.com/duckdb/duckdb/pull/12288 * [CSV] [Bug-Fix] Fix for issue related with single-threaded execution and null padding. by @pdet in https://github.com/duckdb/duckdb/pull/12679 * [Block Size] String block limit and a few other places by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12671 * Rework arena allocator allocation policy - and increase pivot threshold by @Mytherin in https://github.com/duckdb/duckdb/pull/12690 * Julia - Fix Base.isopen(db::DB) in https://github.com/duckdb/duckdb/pull/12700 * [CLI] Limit history size to 100MB, and avoid writing invalid UTF8 to the CLI history by @Mytherin in https://github.com/duckdb/duckdb/pull/12677 * Add configurable thresholds for using nested loop join and merge join by @Mytherin in https://github.com/duckdb/duckdb/pull/12689 * Prevent unnecessary usage of `std::string` in `list` aggregate - and use more efficient `memcpy` for batched copy by @Mytherin in https://github.com/duckdb/duckdb/pull/12694 * Dont load spatial unless geoparquet metata is present by @Maxxen in https://github.com/duckdb/duckdb/pull/12692 * Serialization: add CustomData and better support for integrating with extensions by @jeewonhh in https://github.com/duckdb/duckdb/pull/12681 * Removing ODBC driver by @hannes in https://github.com/duckdb/duckdb/pull/12706 * Support thousand separator for floating point numbers by @Mytherin in https://github.com/duckdb/duckdb/pull/12717 * [Python] Use non-owning references to hold created cursors by @Tishj in https://github.com/duckdb/duckdb/pull/12711 * LIST(VARCHAR) - reduce memory usage by avoiding allocation of nullmask for string data, and allocate larger initial batches by @Mytherin in https://github.com/duckdb/duckdb/pull/12705 * [CSV] Bug fix for race condition in single-threaded multifile reader + properly print paths on union_by_name errors. by @pdet in https://github.com/duckdb/duckdb/pull/12697 * Issue template: Add ODBC and Node (neo) clients by @szarnyasg in https://github.com/duckdb/duckdb/pull/12714 * Shell: add .sql suffix to temporary file created with \e by @Mytherin in https://github.com/duckdb/duckdb/pull/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 https://github.com/duckdb/duckdb/pull/12708 * Change setting types to fix warnings by @Mytherin in https://github.com/duckdb/duckdb/pull/12724 * Avoid unnecessarily copying child expression when binding COLLATE statements by @Mytherin in https://github.com/duckdb/duckdb/pull/12725 * Support for variadic arguments in scalar UDFs in the C API by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12678 * [Relation API] Dont push DISTINCT modifier for EXCEPT/INTERSECT ALL by @Tishj in https://github.com/duckdb/duckdb/pull/12599 * Builds for Windows on ARM64 by @hannes in https://github.com/duckdb/duckdb/pull/12586 * Rework `union_by_name` so that files are no longer kept open by @Mytherin in https://github.com/duckdb/duckdb/pull/12730 * Fix #12729: early-out when checking for perfect hash joins when running on empty tables by @Mytherin in https://github.com/duckdb/duckdb/pull/12731 * CLI: Replace \n with \r\n again in history again by @Mytherin in https://github.com/duckdb/duckdb/pull/12735 * Fix #11228 - add support for unsigned integers in printf/format by @Mytherin in https://github.com/duckdb/duckdb/pull/12736 * Various CI fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/12737 * Add repeat(LIST[], INT) that allows repetition of lists similar to how this is allowed in Python by @Mytherin in https://github.com/duckdb/duckdb/pull/12738 * [Python] Add missing options to `read_json` method by @Tishj in https://github.com/duckdb/duckdb/pull/12732 * Add support for fetching cardinality estimation and stats through a multifilelist by @samansmink in https://github.com/duckdb/duckdb/pull/12740 * Fixes warnings detected by cppcheck by @carlopi in https://github.com/duckdb/duckdb/pull/12745 * [Arrow] Add `ArrowQueryResult` by @Tishj in https://github.com/duckdb/duckdb/pull/12496 * [Dev] StreamQueryResult internals cleanup by @Tishj in https://github.com/duckdb/duckdb/pull/12636 * ALP/ALPRD: correctly skip when we are skipping fewer values than in a vector by @Mytherin in https://github.com/duckdb/duckdb/pull/12753 * Maintain prepared statement parameter types explicitly instead of converting into literals by @Mytherin in https://github.com/duckdb/duckdb/pull/12759 * CLI .changes: use sqlite3_changes64 and sqlite3_totalchanges64 to prevent overflows by @Mytherin in https://github.com/duckdb/duckdb/pull/12761 * Fix #12569: avoid truncating zeros that matter in format function by @Mytherin in https://github.com/duckdb/duckdb/pull/12762 * Fix #12418: Remove .lint command in SQLite shell by @Mytherin in https://github.com/duckdb/duckdb/pull/12763 * Fewer system calls in LocalFileSystem::ListFiles by @Mytherin in https://github.com/duckdb/duckdb/pull/12769 * Support indexes in `COPY DATABASE` by @Mytherin in https://github.com/duckdb/duckdb/pull/12768 * Issue #12600: Batched LEAD/LAG by @hawkfish in https://github.com/duckdb/duckdb/pull/12770 * Issue #12600: Streaming Positive LEAD by @hawkfish in https://github.com/duckdb/duckdb/pull/12685 * Add dl functionality for Windows by @ccfelius in https://github.com/duckdb/duckdb/pull/12765 * Fix stale bot permissions, with @szarnyasg by @carlopi in https://github.com/duckdb/duckdb/pull/12782 * [CI] Stale bot: actually add permissions by @carlopi in https://github.com/duckdb/duckdb/pull/12786 * Fix `FILE_SIZE_BYTES` test (again) by @lnkuiper in https://github.com/duckdb/duckdb/pull/12779 * Fix extended tests in CI by @carlopi in https://github.com/duckdb/duckdb/pull/12781 * Patch CentOS 7 EOL causing CI failure by @samansmink in https://github.com/duckdb/duckdb/pull/12788 * Allow extensions to optionally add own description (on load) by @carlopi in https://github.com/duckdb/duckdb/pull/12754 * Internal #2429: Shifted LEAD NULLs by @hawkfish in https://github.com/duckdb/duckdb/pull/12791 * Issue #12784: Months Before Days by @hawkfish in https://github.com/duckdb/duckdb/pull/12794 * bump vss by @Maxxen in https://github.com/duckdb/duckdb/pull/12797 * Remove centos workaround by @samansmink in https://github.com/duckdb/duckdb/pull/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 https://github.com/duckdb/duckdb/pull/12803 * feat: new inet functions by @panga in https://github.com/duckdb/duckdb/pull/12575 * [Dev] Make`Executor::ResultCollectorIsBlocked` less trigger-happy by @Tishj in https://github.com/duckdb/duckdb/pull/12780 * Fix #12798: Add head file to fix debug build incomplete type error by @zzachimed in https://github.com/duckdb/duckdb/pull/12810 * [Block Size] Switching to configurable block sizes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12691 * [Dev] Clean up the `generate_serialization.py` script a bit by @Tishj in https://github.com/duckdb/duckdb/pull/12823 * Remove micro extended from duckdb/duckdb by @hmeriann in https://github.com/duckdb/duckdb/pull/12792 * [Python] Allow `pathlib.Path` to be provided to `duckdb.connect` by @Tishj in https://github.com/duckdb/duckdb/pull/12809 * remove .py scripts migrating to the sqlsmith by @hmeriann in https://github.com/duckdb/duckdb/pull/12827 * Some expected error messages added by @hmeriann in https://github.com/duckdb/duckdb/pull/12825 * [Fix] list_resize by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12832 * [Python] Python SQLLogicTester maintenance by @Tishj in https://github.com/duckdb/duckdb/pull/12833 * [Python] Accept a list of `Expression` objects in `DuckDBPyRelation.aggregate` by @Tishj in https://github.com/duckdb/duckdb/pull/12812 * [Copy Database] Don't include generated columns in the copied data by @Tishj in https://github.com/duckdb/duckdb/pull/12835 * [Julia] Added Appender support for `Int128`, `UInt128`, and `Base.UUID` values by @curtd in https://github.com/duckdb/duckdb/pull/12836 * [Python] Fix extraction of days/seconds/microseconds from `timedelta` object by @Tishj in https://github.com/duckdb/duckdb/pull/12760 * [Python] Output a regular key -> value dict for hashable keys by @Tishj in https://github.com/duckdb/duckdb/pull/12734 * [Dev] Change internals of `StringUtil::GenerateRandomName` by @Tishj in https://github.com/duckdb/duckdb/pull/12806 * [CSV] Adaptive Sniffer by @pdet in https://github.com/duckdb/duckdb/pull/12698 * Fix LinuxRelease.yml after bump to Node 20 by @carlopi in https://github.com/duckdb/duckdb/pull/12850 * Fix: Reduce repeated judgment in ties[i]. by @Light-City in https://github.com/duckdb/duckdb/pull/12840 * add html_escape and html_unescape functions in inet extension by @chrisiou in https://github.com/duckdb/duckdb/pull/11191 * Fix union struct implict cast by @Maxxen in https://github.com/duckdb/duckdb/pull/12847 * Update httplib from v0.10.2 to v0.14.3 by @lnkuiper in https://github.com/duckdb/duckdb/pull/12849 * Fix an issue where parameters would be promoted to `NULL`, incorrectly causing `PREPARE` to fail by @Mytherin in https://github.com/duckdb/duckdb/pull/12844 * More expected error messages added by @hmeriann in https://github.com/duckdb/duckdb/pull/12846 * Overload `MIN/MAX/MAX_BY/MIN_BY` to return the "top" `N` values by @Maxxen in https://github.com/duckdb/duckdb/pull/12834 * Fix #12789: list_zip support array by @flashmouse in https://github.com/duckdb/duckdb/pull/12859 * [Python] Fix missing ConnectionException errors by @Tishj in https://github.com/duckdb/duckdb/pull/12864 * Make equi_width_binning buckets even nicer by @Mytherin in https://github.com/duckdb/duckdb/pull/12878 * Add a JSON pretty print function by @PhictionalOne in https://github.com/duckdb/duckdb/pull/12398 * Add Metrics Support in the CAPI by @maiadegraaf in https://github.com/duckdb/duckdb/pull/12498 * Update issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/12880 * Fix regression in Parquet reader `TryOpenNextFile` by @lnkuiper in https://github.com/duckdb/duckdb/pull/12848 * Improve performance of memory usage counters by @yiyuanliu in https://github.com/duckdb/duckdb/pull/12751 * [Fix] No String Inline / Destroy Unpinned Blocks nightly run by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12884 * Fix LinuxRelease.yml CI by avoiding upload by @carlopi in https://github.com/duckdb/duckdb/pull/12891 * Do not depend on manylinux extension in Python's CI by @carlopi in https://github.com/duckdb/duckdb/pull/12895 * [Dev] Fix failing test in `test_relation_api.cpp` by @Tishj in https://github.com/duckdb/duckdb/pull/12894 * [Dev] Skip `test_run_pandas_with_tz` on pandas <2.0.0 by @Tishj in https://github.com/duckdb/duckdb/pull/12896 * Fix #12688: Julia SubString handling by @dhanak in https://github.com/duckdb/duckdb/pull/12899 * [Python-Dev] Add `DependencyException`, throw earlier if `PendingQuery` fails by @Tishj in https://github.com/duckdb/duckdb/pull/12888 * [Fix] Mixing block sizes and compression functions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12858 * Fix issue with list radix serialization by @lnkuiper in https://github.com/duckdb/duckdb/pull/12887 * Respect limit during join order by @Tmonster in https://github.com/duckdb/duckdb/pull/12851 * [CHORE]: Fix minor SQL test case by @Tmonster in https://github.com/duckdb/duckdb/pull/12909 * Fixes for duckdb_constraints and information_schema constraint tables by @Mytherin in https://github.com/duckdb/duckdb/pull/12914 * [Postgres Compatiblity] Support `=>` to supply named parameters to functions by @Tishj in https://github.com/duckdb/duckdb/pull/12913 * Pushdown table filters into probe based on min/max data found during hash build of hash joins by @Mytherin in https://github.com/duckdb/duckdb/pull/12908 * Count nulls when detecting JSON structure by @lnkuiper in https://github.com/duckdb/duckdb/pull/12883 * Fix #12870 - improve error message when encountering schema mismatches in COPY tbl FROM file.parquet by @Mytherin in https://github.com/duckdb/duckdb/pull/12918 * Use different versions of snappy depending on the compiler by @lnkuiper in https://github.com/duckdb/duckdb/pull/12889 * Fix Issues with type detection for Doubles/Floats/Decimals by @pdet in https://github.com/duckdb/duckdb/pull/12866 * Pass 'Unsecure_node_version' to allow node16 for a bit longer by @carlopi in https://github.com/duckdb/duckdb/pull/12922 * Minor refactor for window_executor by @ZhangHuiGui in https://github.com/duckdb/duckdb/pull/12924 * ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION:false for Android and Nightly by @carlopi in https://github.com/duckdb/duckdb/pull/12930 * [Fix] Vector verification for dictionary expressions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12890 * Return smaller cardinality for Top N operator by @jeewonhh in https://github.com/duckdb/duckdb/pull/12932 * Make GCC Happy Again by @carlopi in https://github.com/duckdb/duckdb/pull/12937 * [Fix] More robust parquet metadata test by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12935 * Rework table filters, and for each row group only execute table filters if they can actually filter out any rows by @Mytherin in https://github.com/duckdb/duckdb/pull/12938 * Issue #12941: Window Constant Results by @hawkfish in https://github.com/duckdb/duckdb/pull/12943 * Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/12927 * Make `ErrorData::Message()` and `ErrorData::RawMessage()` const by @Flogex in https://github.com/duckdb/duckdb/pull/12885 * Feature #1272: Window Parallel Sink by @hawkfish in https://github.com/duckdb/duckdb/pull/12907 * [Arrow] Add `PhysicalArrowBatchCollector`, a batched result collector for the `ArrowQueryResult` by @Tishj in https://github.com/duckdb/duckdb/pull/12787 * [Python] Rework internals of object registration by @Tishj in https://github.com/duckdb/duckdb/pull/12625 * [StreamQueryResult] Add `ExecuteTask` method to StreamQueryResult by @Tishj in https://github.com/duckdb/duckdb/pull/12824 * Fix several CTE related issues by @kryonix in https://github.com/duckdb/duckdb/pull/12948 * Label mark joins with convert to semi by @Tmonster in https://github.com/duckdb/duckdb/pull/12916 * [Julia]: Added `FixedDecimal` support to Appender API by @curtd in https://github.com/duckdb/duckdb/pull/12923 * Pushdown dynamically generated filters into `MultiFileList`, allowing partitions to be pruned by @Mytherin in https://github.com/duckdb/duckdb/pull/12955 * Automatically materialize CTEs by @lnkuiper in https://github.com/duckdb/duckdb/pull/12290 * Move checkpointing parallelism into `TaskExecutor` class, use that class for parallel `union_by_name` by @Mytherin in https://github.com/duckdb/duckdb/pull/12957 * [Dev] Uncouple `HTTPState` from core by @Tishj in https://github.com/duckdb/duckdb/pull/12912 * [Dev] Clean up TreeRenderer code by @Tishj in https://github.com/duckdb/duckdb/pull/12716 * Swap build side and probe side base on cardinality AND width of build side. by @Tmonster in https://github.com/duckdb/duckdb/pull/12755 * [Python] Use `Set` instead of `List` for the `get_table_names` stubs by @Tishj in https://github.com/duckdb/duckdb/pull/12963 * Feature #1272: Window Validity Array by @hawkfish in https://github.com/duckdb/duckdb/pull/12954 * [CSV Reader] Make glob reading more permissive to errors if ignore_errors is set by @pdet in https://github.com/duckdb/duckdb/pull/12966 * [Python] Convert ENUM to `np.array` instead of `pd.Categorical` for `fetchnumpy` by @Tishj in https://github.com/duckdb/duckdb/pull/12964 * Several hive partitioning fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/12970 * fix incorrect int32 appender by @piever in https://github.com/duckdb/duckdb/pull/12956 * Add missing TransformCTE extraction to TransformRecursiveCTE by @kryonix in https://github.com/duckdb/duckdb/pull/12968 * Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/12969 * Add Pyodide 0.26.1 (corresponding to Python 3.12) by @carlopi in https://github.com/duckdb/duckdb/pull/12965 * Avoid adding a suffix to Parquet files when doing a partitioned write by @Mytherin in https://github.com/duckdb/duckdb/pull/12972 * URL Encode/Decode Hive Partitioning Columns/Filters + add url_encode/url_decode scalar functions by @Mytherin in https://github.com/duckdb/duckdb/pull/12974 * Fix JSON extension Cmake by @carlopi in https://github.com/duckdb/duckdb/pull/12975 * Clarify when it's necessary to refresh data and validity pointers by @Giorgi in https://github.com/duckdb/duckdb/pull/12973 * Added new information_schema views - closes #4343 by @prmoore77 in https://github.com/duckdb/duckdb/pull/12942 * Use jaro winkler similarity for finding similar entries in catalog by @Mytherin in https://github.com/duckdb/duckdb/pull/12980 * Internal #2503: Streaming Window Reset by @hawkfish in https://github.com/duckdb/duckdb/pull/12984 * Fix #12933: maintain insertion order in window when the window clause is empty (i.e. over ()) by @Mytherin in https://github.com/duckdb/duckdb/pull/12982 * Feature #1272: Window Constant Sink by @hawkfish in https://github.com/duckdb/duckdb/pull/12979 * Remove special case for '+' in URLs in httplib by @lnkuiper in https://github.com/duckdb/duckdb/pull/12929 * Rebind prepared statements based on catalog versions by @ywelsch in https://github.com/duckdb/duckdb/pull/12829 * Allow string stats larger than our default for parquet row group pruning by @lnkuiper in https://github.com/duckdb/duckdb/pull/12928 * Add work-around for R client table function initialization back in under a config setting by @Mytherin in https://github.com/duckdb/duckdb/pull/12990 * [Dev] Add getters/setters for the 'column_ids' of a `LogicalGet` by @Tishj in https://github.com/duckdb/duckdb/pull/12971 * Accelerate Parquet en/decryption with HTTPFS extension by @ccfelius in https://github.com/duckdb/duckdb/pull/11720 * remove deprecated CDN invalidations by @samansmink in https://github.com/duckdb/duckdb/pull/12997 * add large ingestions by @hmeriann in https://github.com/duckdb/duckdb/pull/12949 * Fix shared_ptr issues in RowGroup and add locks to WAL initialization by @Mytherin in https://github.com/duckdb/duckdb/pull/13000 * Add the ANY type and special null handling to the C API by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12785 * Improve error messages in the presence of subqueries by @Mytherin in https://github.com/duckdb/duckdb/pull/13001 * Case-insensitive `NULL` casting in `VARCHAR` -> `STRUCT` casts by @lnkuiper in https://github.com/duckdb/duckdb/pull/13003 * `TemporaryMemoryManager` improvements by @lnkuiper in https://github.com/duckdb/duckdb/pull/12931 * Make sure that empty and only white space headers have same treatment by @pdet in https://github.com/duckdb/duckdb/pull/12994 * Push timestamp_tz to do direct casting if ICU is not loaded by @pdet in https://github.com/duckdb/duckdb/pull/12993 * [Dev] Add `query` to QueryRelation for logging by @Tishj in https://github.com/duckdb/duckdb/pull/13004 * [Spark API] Fix group by compatibility issues by @Tishj in https://github.com/duckdb/duckdb/pull/13005 * [CSV] Progress Bar for compressed files. by @pdet in https://github.com/duckdb/duckdb/pull/12728 * Disable fixed size map in `PartitionedTupleData` by @Mytherin in https://github.com/duckdb/duckdb/pull/13013 * Fix parallel creation and destruction of instances through the `DBInstanceCache` by @Mytherin in https://github.com/duckdb/duckdb/pull/13010 * Avoid generating join filters for interval columns by @Mytherin in https://github.com/duckdb/duckdb/pull/13014 * Extend least/greatest to support all types, and always return the same type as its input types by @Mytherin in https://github.com/duckdb/duckdb/pull/13019 * Add sha1(varchar) -> varchar scalar function by @bradlarsen in https://github.com/duckdb/duckdb/pull/13020 * Decimal to FloatingPoint: Avoid losing precision by splitting operation in two, more fixes and tests by @carlopi in https://github.com/duckdb/duckdb/pull/12627 * Feature #1272: Segment Tree Finalize by @hawkfish in https://github.com/duckdb/duckdb/pull/13002 * Create Delimiter Join and Delimiter Get via Relations by @pdet in https://github.com/duckdb/duckdb/pull/12953 * Fix CTE/noalternativeverify issues by @lnkuiper in https://github.com/duckdb/duckdb/pull/13024 * Fix bug in reworked `fixed_size_map_t` by @lnkuiper in https://github.com/duckdb/duckdb/pull/13023 * Fix abs for floating point negative zero by @Mytherin in https://github.com/duckdb/duckdb/pull/13025 * [Nightly-Bug] [CSV Reader] Use strings on header detection by @pdet in https://github.com/duckdb/duckdb/pull/13028 * Release GIL during DB instantiation by @ywelsch in https://github.com/duckdb/duckdb/pull/13029 * GCC 4.8: add noexpr to 2 constructors by @carlopi in https://github.com/duckdb/duckdb/pull/13030 * Fixes for LogicalType::ANY and fixed_size_map by @Mytherin in https://github.com/duckdb/duckdb/pull/13035 * [Nightly] Fix for arrow appending fixed size lists by @pdet in https://github.com/duckdb/duckdb/pull/13039 * fix storing persistent secrets in home dir by @samansmink in https://github.com/duckdb/duckdb/pull/13033 * Internal #2534: IGNORE NULLS Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/13050 * [Julia] Only commit transaction on non-error (compat) by @genericallyterrible in https://github.com/duckdb/duckdb/pull/13049 * Improve EXPLAIN output of Delim Joins and Delim Gets by @kryonix in https://github.com/duckdb/duckdb/pull/12995 * Make client reuse threadsafe by @samansmink in https://github.com/duckdb/duckdb/pull/13052 * Only remove the first occurrence of extension prefix by @jeewonhh in https://github.com/duckdb/duckdb/pull/13057 * Fix incorrect overflow in left shift of unsigned number by @Mytherin in https://github.com/duckdb/duckdb/pull/13056 * Add tests for sha1 function by @bradlarsen in https://github.com/duckdb/duckdb/pull/13064 * [Relation] ViewRelation could be created without an alias by @Tishj in https://github.com/duckdb/duckdb/pull/13054 * Support IN operator for LIST by @Tishj in https://github.com/duckdb/duckdb/pull/12920 * [Python] Read from file-like objects with `read_json` by @Tishj in https://github.com/duckdb/duckdb/pull/13040 * [Python] Fix lifetime issue with MaterializedRelation by @Tishj in https://github.com/duckdb/duckdb/pull/12998 * PySpark sort by columns and DataFrame.getitem by @khalidmammadov in https://github.com/duckdb/duckdb/pull/12981 * Fix trouble to compile with MSVC by @annnei in https://github.com/duckdb/duckdb/pull/12579 * Create a dedicated `RegisteredStateManager` that manages client context states in a thread-safe manner by @Mytherin in https://github.com/duckdb/duckdb/pull/13027 * DEBUG_STACKTRACE should not be enabled for release builds by @Mytherin in https://github.com/duckdb/duckdb/pull/13070 * Add blob overloads to crypto functions, and turn md5_number_lower and md5_number_upper into macros by @Mytherin in https://github.com/duckdb/duckdb/pull/13068 * Internal #2534: IGNORE NULLS Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/13065 * Variable Integer Size Type by @pdet in https://github.com/duckdb/duckdb/pull/13015 * Simplify binding of CALL statement by @Mytherin in https://github.com/duckdb/duckdb/pull/13074 * Fix #13045: flatten in list_inner_product by @Mytherin in https://github.com/duckdb/duckdb/pull/13076 * Fix for unpivot on zero columns by @Mytherin in https://github.com/duckdb/duckdb/pull/13073 * Add support for overloading to macros by @Mytherin in https://github.com/duckdb/duckdb/pull/13062 * Internal #2534: Windowed FILTER Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/13086 * Fixup #12579, remove pessimizing std::move by @carlopi in https://github.com/duckdb/duckdb/pull/13089 * [CSV Reader] Fix when reading overbuffer values of csv files with extra delimiter by @pdet in https://github.com/duckdb/duckdb/pull/13081 * Making error messages more clear for new line delimiter errors by @pdet in https://github.com/duckdb/duckdb/pull/13082 * [CSV Sniffer] Sniffer can now sniff files with extra delimiters by @pdet in https://github.com/duckdb/duckdb/pull/13083 * Remove test in Pyodide due to weird pandas interactions by @carlopi in https://github.com/duckdb/duckdb/pull/13091 * Add support for SQL-level variables by @Mytherin in https://github.com/duckdb/duckdb/pull/13084 * Fix wasm CI and add missing template argument by @carlopi in https://github.com/duckdb/duckdb/pull/13094 * Some clang tidy fixes around narrowing casts by @carlopi in https://github.com/duckdb/duckdb/pull/13105 * chore: PushdownAggregate fast path by @lichuang in https://github.com/duckdb/duckdb/pull/13098 * - fix list_distance & list_cosine_similarity execute fail when list i… by @flashmouse in https://github.com/duckdb/duckdb/pull/13090 * [Explain] Add `EXPLAIN (FORMAT JSON)` syntax by @Tishj in https://github.com/duckdb/duckdb/pull/12967 * Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/13107 * [Bug] Enum types not being found if created in a schema by @pdet in https://github.com/duckdb/duckdb/pull/13106 * Parquet reader can now read files with duplicate column names by @hannes in https://github.com/duckdb/duckdb/pull/13111 * Prefer aliases over column-value functions in `GROUP BY`, and prefer error message when alias is used in an expression by @Mytherin in https://github.com/duckdb/duckdb/pull/13118 * Disallowing DISTINCT, FILTER and ORDER BY for UNNEST by @hannes in https://github.com/duckdb/duckdb/pull/13110 * Feature #1272: Windowed DISTINCT Sink by @hawkfish in https://github.com/duckdb/duckdb/pull/13093 * adjust list value logic execute seq by @flashmouse in https://github.com/duckdb/duckdb/pull/13114 * add CORE_EXTENSIONS build flag by @samansmink in https://github.com/duckdb/duckdb/pull/13116 * [Python] Add missing options for `read_csv` by @Tishj in https://github.com/duckdb/duckdb/pull/12872 * Fix merge conflict by @Mytherin in https://github.com/duckdb/duckdb/pull/13126 * Retry on HTTP failure in extension install by @Mytherin in https://github.com/duckdb/duckdb/pull/13122 * Clean up ChunkInfo when cleaning up a transaction by @Mytherin in https://github.com/duckdb/duckdb/pull/13125 * typo: conjuction -> conjunction by @qsliu2017 in https://github.com/duckdb/duckdb/pull/13127 * Add duckdb_result_error_type that returns the exception type of the error by @Mytherin in https://github.com/duckdb/duckdb/pull/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 <alias> 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**: https://github.com/duckdb/duckdb/compare/v1.0.0...v1.1.0