0.8.0

This preview release of DuckDB is named "Fulvigula" after the Mottled duck (Anas fulvigula) which lives in the Gulf of Mexico, where it is apparently highly prized amongst (heartless) hunters.

There are two SQL-level breaking changes in this release:

• https://github.com/duckdb/duckdb/pull/7174 The default sort order switched from NULLS FIRST to NULLS LAST because this is more intuitive, especially in conjunction with LIMIT.
• https://github.com/duckdb/duckdb/pull/7082 The division operator / will now always lead to a floating point result even with integer parameters. The new operator // retains the old semantics. This change is consistent with Python.

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

What's Changed

• Issue 5984 #4 LogicalColumnIndex out of range Error by @Tmonster in https://github.com/duckdb/duckdb/pull/6303
• Implementing Integration with PyTorch by @pdet in https://github.com/duckdb/duckdb/pull/6295
• Implement #4941: Python client: for streaming fetches construct a streaming result (fetch_one, record_batch_reader, etc) by @Mytherin in https://github.com/duckdb/duckdb/pull/6346
• Implement sharable Buffer Pool across DatabaseInstances by @jkub in https://github.com/duckdb/duckdb/pull/6299
• Add table functions range and generate_series for TIMESTAMPTZ by @papparapa in https://github.com/duckdb/duckdb/pull/6285
• Add Initial DuckDB Swift API by @tcldr in https://github.com/duckdb/duckdb/pull/6351
• Integration with TensorFlow Tensors by @pdet in https://github.com/duckdb/duckdb/pull/6348
• Windows - remove delayload code and enable statically linking extensions by default by @Mytherin in https://github.com/duckdb/duckdb/pull/6399
• Add support for Pivot/Unpivot statements by @Mytherin in https://github.com/duckdb/duckdb/pull/6387
• [C-API] Add support for StreamQueryResult by @Tishj in https://github.com/duckdb/duckdb/pull/6318
• [Swift] add remaining non-composite types by @tcldr in https://github.com/duckdb/duckdb/pull/6422
• [Swift] Add Prepared Statements by @tcldr in https://github.com/duckdb/duckdb/pull/6459
• [Python] Exclude jemalloc files while pip install on Android OS by @papparapa in https://github.com/duckdb/duckdb/pull/6450
• CI: Swap cron for repository_dispatch by @carlopi in https://github.com/duckdb/duckdb/pull/6498
• CI improvements + add version badge to README by @carlopi in https://github.com/duckdb/duckdb/pull/6493
• Storage: store lists as uint64 offsets instead of as list_entry_t by @Mytherin in https://github.com/duckdb/duckdb/pull/6499
• two changes facilitating sending table/column stats over the wire (M… by @peterboncz in https://github.com/duckdb/duckdb/pull/6440
• Rework Value class internals to have a similar structure to LogicalType and others by @Mytherin in https://github.com/duckdb/duckdb/pull/6503
• Remove unswizzle flag from SortedData::Unswizzle by @lnkuiper in https://github.com/duckdb/duckdb/pull/6501
• [Swift] Add Appender by @tcldr in https://github.com/duckdb/duckdb/pull/6482
• JDBC: Remove DuckDBDatabase by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6426
• Add nan and inf arithmetic by @Tmonster in https://github.com/duckdb/duckdb/pull/6415
• Update tools/rpkg README.md by @Tishj in https://github.com/duckdb/duckdb/pull/6530
• Merge feature into master by @Mytherin in https://github.com/duckdb/duckdb/pull/6534
• Restrict threads for reliability. by @hawkfish in https://github.com/duckdb/duckdb/pull/6540
• Replace replace with format strings by @domoritz in https://github.com/duckdb/duckdb/pull/6542
• Add missing escape for " by @domoritz in https://github.com/duckdb/duckdb/pull/6543
• Blob <-> Bitstring casting by @LindsayWray in https://github.com/duckdb/duckdb/pull/6488
• Mapfunctions: map_entries, map_values, map_keys by @LindsayWray in https://github.com/duckdb/duckdb/pull/6522
• Issue #5920: Ordered Aggregate Buffering by @hawkfish in https://github.com/duckdb/duckdb/pull/6539
• Handle SQL-tagged strings correctly with dplyr::tbl, fixes #6506 by @rsund in https://github.com/duckdb/duckdb/pull/6536
• CI: Update Swift.yml by @carlopi in https://github.com/duckdb/duckdb/pull/6553
• Update SwiftRelease.yml by @carlopi in https://github.com/duckdb/duckdb/pull/6554
• Java: Implement JDBC 4.1 by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6376
• Bitstring aggregations by @LindsayWray in https://github.com/duckdb/duckdb/pull/6417
• Make our default threads setting Cgroup-aware on Linux by @Tishj in https://github.com/duckdb/duckdb/pull/6550
• [Swift] Add composite type support by @tcldr in https://github.com/duckdb/duckdb/pull/6557
• Statistics Rework: Switch to single BaseStatistics class, use separate static classes for methods on the stats instead by @Mytherin in https://github.com/duckdb/duckdb/pull/6560
• Introduce Syntax for SEMI and ANTI joins by @Tmonster in https://github.com/duckdb/duckdb/pull/6480
• Update storage_info with version 0.7.1 by @carlopi in https://github.com/duckdb/duckdb/pull/6572
• [Python] Add the ability to supply a DuckDBPyRelation instance to register by @Tishj in https://github.com/duckdb/duckdb/pull/6483
• [Python] map now defaults to original type when analyzed type at bind is NULL by @Tishj in https://github.com/duckdb/duckdb/pull/6571
• [Dev] Fix broken test_filesystem.py test by @Tishj in https://github.com/duckdb/duckdb/pull/6582
• CI: Node.js, add common NPM-setup step by @carlopi in https://github.com/duckdb/duckdb/pull/6590
• build: add builds for nodejs linux arm64 by @Mause in https://github.com/duckdb/duckdb/pull/6586
• CI: move to setup-node@v3 by @carlopi in https://github.com/duckdb/duckdb/pull/6596
• Issue #6604: TIMESTAMP <=> TIMESTAMPTZ by @hawkfish in https://github.com/duckdb/duckdb/pull/6605
• [Python] Add support for EXPLAIN ANALYZE to explain method by @Tishj in https://github.com/duckdb/duckdb/pull/6561
• Add ICU list functions generate_series and range by @papparapa in https://github.com/duckdb/duckdb/pull/6445
• feat(nodejs): add errorType attribute to DuckDbError by @Mause in https://github.com/duckdb/duckdb/pull/6434
• Fix TPC-DS date insertion by @ywelsch in https://github.com/duckdb/duckdb/pull/6591
• Fix #4016: Test amalgamation with --split param by @carlopi in https://github.com/duckdb/duckdb/pull/6587
• feat(python): throw HTTPExceptions instead of IOException for http errors by @Mause in https://github.com/duckdb/duckdb/pull/6533
• Add httpfs config to support packaging it as an extension by @ankrgyl in https://github.com/duckdb/duckdb/pull/6608
• Issue #6595: N-Ary Positional Joins by @hawkfish in https://github.com/duckdb/duckdb/pull/6598
• [Swift] inline documentation plus API tweaks by @tcldr in https://github.com/duckdb/duckdb/pull/6614
• Fix #6602: add inet extension to build/distribute script by @Mytherin in https://github.com/duckdb/duckdb/pull/6610
• CI remove amalgama x8 + swift release by @carlopi in https://github.com/duckdb/duckdb/pull/6615
• Fix too many open file handles during JSON schema detection by @lnkuiper in https://github.com/duckdb/duckdb/pull/6613
• Issue #6580: Parquet Int96 Timestamps by @hawkfish in https://github.com/duckdb/duckdb/pull/6601
• Exception_static_build defalt: Partial revert of dabbeada3a by @carlopi in https://github.com/duckdb/duckdb/pull/6620
• Make DISTINCT ON respect the ORDER BY clause similar to Postgres + several ordered aggregate improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/6616
• fix url encode issue for R2 by @samansmink in https://github.com/duckdb/duckdb/pull/6609
• [Swift] Database.Configuration type + documentation enhancements by @tcldr in https://github.com/duckdb/duckdb/pull/6617
• R: Avoid passing SEXP by reference by @krlmlr in https://github.com/duckdb/duckdb/pull/6475
• Test and fix preservation of class attribute in external pointers by @krlmlr in https://github.com/duckdb/duckdb/pull/6526
• Add support for lambda functions to COLUMNS, and allow COLUMNS to be used in the ORDER BY/WHERE clauses by @Mytherin in https://github.com/duckdb/duckdb/pull/6621
• [R] Remove duplicate occurrence of dependency by @Tishj in https://github.com/duckdb/duckdb/pull/6625
• Automatically Fully Download Files through HTTPFS if no length header is provided by @pdet in https://github.com/duckdb/duckdb/pull/6448
• Remove some function calls that can throw potential false positives in CI by @Tmonster in https://github.com/duckdb/duckdb/pull/6623
• [Python] Add __getattr__ and __getitem__ implementations for DuckDBPyRelation by @Tishj in https://github.com/duckdb/duckdb/pull/6624
• [Optimizer] Regex Optimization Rule fix by @Tishj in https://github.com/duckdb/duckdb/pull/6634
• [Bug Fix] Enum Serialization by @pdet in https://github.com/duckdb/duckdb/pull/6040
• Update interval for arrow by @handstuyennn in https://github.com/duckdb/duckdb/pull/6515
• SQLLogicTest - instead of moving prepared statements over avoid restarting database when there are prepared statements by @Mytherin in https://github.com/duckdb/duckdb/pull/6638
• Bind replace table function by @samansmink in https://github.com/duckdb/duckdb/pull/6639
• Fix #6630: correctly set bind_data->types in the Parquet scan when using union_by_name by @Mytherin in https://github.com/duckdb/duckdb/pull/6642
• [Python] read_csv can now read from a file-like object. by @Tishj in https://github.com/duckdb/duckdb/pull/6568
• Fix #6640: correctly throw an error on altering schemas by @Mytherin in https://github.com/duckdb/duckdb/pull/6643
• Support multiple aggregates in top-level pivot by @Mytherin in https://github.com/duckdb/duckdb/pull/6644
• [DEV]: Fix clangd errors by @hawkfish in https://github.com/duckdb/duckdb/pull/6650
• Issue #6635: FIRST LAST NULLS by @hawkfish in https://github.com/duckdb/duckdb/pull/6648
• [DEV]: Unreachable window alias by @hawkfish in https://github.com/duckdb/duckdb/pull/6649
• Fix IsRegularCharacter() by @lokax in https://github.com/duckdb/duckdb/pull/6654
• [Swift] add Xcode playground Example by @tcldr in https://github.com/duckdb/duckdb/pull/6629
• Fix #6651: correctly update UpdateSegment references after transferring from transaction-local to committed data by @Mytherin in https://github.com/duckdb/duckdb/pull/6657
• Fix #6656: correctly add casts to NULL values in list_concat, and add more safety around stats mismatches by @Mytherin in https://github.com/duckdb/duckdb/pull/6658
• Fixing some tidy warnings by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6661
• Fix c053bc813a75b, unguarded std::thread by @carlopi in https://github.com/duckdb/duckdb/pull/6663
• Fix class name in error message by @papparapa in https://github.com/duckdb/duckdb/pull/6679
• Fix many fuzzer issues by @Mytherin in https://github.com/duckdb/duckdb/pull/6681
• Fix #6676 and #6677: correctly instantiate local states for nested casts by @Mytherin in https://github.com/duckdb/duckdb/pull/6688
• WebAssembly testing against duckdb-wasm latest stable version by @carlopi in https://github.com/duckdb/duckdb/pull/6665
• Support reading from presigned url by @douenergy in https://github.com/duckdb/duckdb/pull/6467
• Fix #6668: correctly report errors that occur during index appends by @Mytherin in https://github.com/duckdb/duckdb/pull/6693
• R: Remove RProtector class by @krlmlr in https://github.com/duckdb/duckdb/pull/6637
• Fix #6684: in the aggregate hash table, when we have very wide rows, default to HtEntryType::HT_WIDTH_64 by @Mytherin in https://github.com/duckdb/duckdb/pull/6689
• ColumnDataCollection - copy strings if DISALLOW_ZERO_COPY is enabled by @Mytherin in https://github.com/duckdb/duckdb/pull/6700
• Fix ossfuzz assertion triggers by @Mytherin in https://github.com/duckdb/duckdb/pull/6699
• Fix #6690: correctly handle NULL values in CSV auto-detection when decimal separator option is specified by @Mytherin in https://github.com/duckdb/duckdb/pull/6701
• Don't try to process validity mask for arrow null type columns by @cpcloud in https://github.com/duckdb/duckdb/pull/6702
• Adding Children and Step Options to TPC-H generator for BIG DATA by @pdet in https://github.com/duckdb/duckdb/pull/6535
• Add json_serialize_sql and first step of new Format(De)Serialization infrastructure. by @Maxxen in https://github.com/duckdb/duckdb/pull/6647
• feat(nodejs): Expose HTTPException as HTTPError by @Mause in https://github.com/duckdb/duckdb/pull/6655
• Add regexp_extract_all scalar function by @Tishj in https://github.com/duckdb/duckdb/pull/6685
• Storage: Lazily Load Row Groups from Tables by @Mytherin in https://github.com/duckdb/duckdb/pull/6715
• Add support for function chaining and the dot syntax for function calls by @Mytherin in https://github.com/duckdb/duckdb/pull/6725
• Implement JDBC unwrap methods by @tom-s-powell in https://github.com/duckdb/duckdb/pull/6718
• [Swift] Add sub-repo README.md by @tcldr in https://github.com/duckdb/duckdb/pull/6734
• Fix #6433 - avoid double recursion in pushdown of single/mark join by @Mytherin in https://github.com/duckdb/duckdb/pull/6740
• Make more pieces of pivot clause optional, and fix pivot alias issue by @Mytherin in https://github.com/duckdb/duckdb/pull/6731
• Add date_add alias to interval arithmetic by @Mytherin in https://github.com/duckdb/duckdb/pull/6726
• Add --root-dir option to benchmark runner by @Maxxen in https://github.com/duckdb/duckdb/pull/6739
• Add .col option to duckbox rendering in the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/6748
• Add support for CREATE OR REPLACE SEQUENCE and CREATE OR REPLACE SCHEMA by @Mytherin in https://github.com/duckdb/duckdb/pull/6730
• Support recursive unnesting and unnesting of structs by @Mytherin in https://github.com/duckdb/duckdb/pull/6755
• Add support for pivoting on expressions by @Mytherin in https://github.com/duckdb/duckdb/pull/6758
• arrowIPCStream should return a promise by @domoritz in https://github.com/duckdb/duckdb/pull/6744
• Bug report: Add duckdb-wasm as potential alternative by @carlopi in https://github.com/duckdb/duckdb/pull/6794
• Anti/Semi Join fixes by @Tmonster in https://github.com/duckdb/duckdb/pull/6790
• Julia - Add support for streaming query results by @Mytherin in https://github.com/duckdb/duckdb/pull/6770
• Adding the option for the user to specify the column types searched in the CSV Auto Detect by @pdet in https://github.com/duckdb/duckdb/pull/6756
• Add GCD and LCM numeric functions by @kryonix in https://github.com/duckdb/duckdb/pull/6766
• Release the GIL when getting chunks for arrow results by @pdet in https://github.com/duckdb/duckdb/pull/6810
• Add to_hex/from_hex functions by @lokax in https://github.com/duckdb/duckdb/pull/6579
• Fix duckdb_result_chunk_count return description. by @Giorgi in https://github.com/duckdb/duckdb/pull/6813
• Issue #3207: ASOF JOIN Compilation by @hawkfish in https://github.com/duckdb/duckdb/pull/6719
• Fix #6603/#6799 - Index join fixes + fix verification check by @Mytherin in https://github.com/duckdb/duckdb/pull/6807
• Fix #2743 by removing NotImplementedException in CreateUnionPipeline by @kryonix in https://github.com/duckdb/duckdb/pull/6789
• [Swift] SwiftUI example project and type conversion utils by @tcldr in https://github.com/duckdb/duckdb/pull/6795
• Fix issue #6822 by instantiating TryMultiplyOperator for hugeint_t by @kryonix in https://github.com/duckdb/duckdb/pull/6824
• Moving HTTPState initializer to CleanupInternal by @pdet in https://github.com/duckdb/duckdb/pull/6819
• Map extract now allows composite (nested) types as key by @Tishj in https://github.com/duckdb/duckdb/pull/6552
• Issue #6728: Constant Windowed Aggregation by @hawkfish in https://github.com/duckdb/duckdb/pull/6772
• Parquet reader - fixes for reading non-microsecond TIME columns and delta_binary_packed encoded times/timestamps by @Mytherin in https://github.com/duckdb/duckdb/pull/6836
• Register function for Polars DFs by @pdet in https://github.com/duckdb/duckdb/pull/6825
• Storage: Add lazy column meta data loading, and fix issue where RowGroup::InitializeScan was called many times unnecessarily by @Mytherin in https://github.com/duckdb/duckdb/pull/6841
• Add support for named parameters in the API by @dacort in https://github.com/duckdb/duckdb/pull/6575
• Issue #5290: Rewrite ordered LIST by @hawkfish in https://github.com/duckdb/duckdb/pull/6741
• [Python] Fix crash in Jupyter environment related to progress bars by @Tishj in https://github.com/duckdb/duckdb/pull/6831
• Issue #6764: add "null_padding" option to pad rows in a CSV file with missing columns with NULL values by @Mytherin in https://github.com/duckdb/duckdb/pull/6765
• Enable BuildPipelines for nested recursive CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/6838
• 2023a Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/6844
• Normalize comparisons and improve string_t operations by @carlopi in https://github.com/duckdb/duckdb/pull/6381
• Fix #6856: correctly check cast cost of child element of list during function binding by @Mytherin in https://github.com/duckdb/duckdb/pull/6857
• Hash aggregate - switch partitioning threshold to MAX(total_groups) instead of SUM(total_groups), and limit number of partitions by @Mytherin in https://github.com/duckdb/duckdb/pull/6851
• Fix Parquet writer regression + add Parquet writing to regression test suite by @Mytherin in https://github.com/duckdb/duckdb/pull/6852
• [Python] tuple now gets properly converted to LIST, instead of a VARCHAR by @Tishj in https://github.com/duckdb/duckdb/pull/6868
• Implement predicates in JDBC DB-Meta class by @pjarra in https://github.com/duckdb/duckdb/pull/6866
• [Dev]: ICU 2023b TimeZones by @hawkfish in https://github.com/duckdb/duckdb/pull/6855
• [Python/Dev] Add implicit conversion from None -> duckdb.default_connection by @Tishj in https://github.com/duckdb/duckdb/pull/6839
• Add specific version of clang-format to the contributing guidelines by @Tishj in https://github.com/duckdb/duckdb/pull/6849
• ** search (crawl) for files in subdirectories by @lverdoes in https://github.com/duckdb/duckdb/pull/6627
• Modify show tables pragma query to respect current catalog scope by @rjatwal in https://github.com/duckdb/duckdb/pull/6816
• Issue #5920: Ordered Aggregate Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/6867
• Do not enable jemalloc unconditionally by @jeroen in https://github.com/duckdb/duckdb/pull/6864
• Parquet reader - millisecond times are stored as int32 by @Mytherin in https://github.com/duckdb/duckdb/pull/6879
• Aggregate HT: Move intermediate structures to a separate AggregateHTAppendState, and avoid unnecessary resizing when many hash tables are created by @Mytherin in https://github.com/duckdb/duckdb/pull/6877
• [Python] Respect strides in 'object' column (string) to DuckDB conversion by @Tishj in https://github.com/duckdb/duckdb/pull/6878
• [Python] Add implicit conversion from pathlib.Path to string by @Tishj in https://github.com/duckdb/duckdb/pull/6835
• Ci wasm by @carlopi in https://github.com/duckdb/duckdb/pull/6886
• Include necessary C++ header by @david-cortes in https://github.com/duckdb/duckdb/pull/6900
• Wasm loadable extensions wip by @carlopi in https://github.com/duckdb/duckdb/pull/6889
• [Dev]: 2023c TimeZone Data by @hawkfish in https://github.com/duckdb/duckdb/pull/6905
• Adding definition for missing extension exception by @Dtenwolde in https://github.com/duckdb/duckdb/pull/6903
• Export window function as expression in relational api by @Tmonster in https://github.com/duckdb/duckdb/pull/6757
• [Catalog] Improve error message on catalog-qualified catalog-entry lookup by @Tishj in https://github.com/duckdb/duckdb/pull/6911
• fix for ODBC driver issues #4887 and #3801 by @bucweat in https://github.com/duckdb/duckdb/pull/6875
• Add support for transforming boolean tests by @hannes in https://github.com/duckdb/duckdb/pull/6928
• Support for missing GZIP features (extra field in header and concatenated files) used in BGZF by @rsund in https://github.com/duckdb/duckdb/pull/6817
• MultiFileReader - Provide unified methods for multi-file reader functions (Parquet, CSV, JSON) by @Mytherin in https://github.com/duckdb/duckdb/pull/6912
• Fixes an issue where CDPATH causes make to fail. by @marhar in https://github.com/duckdb/duckdb/pull/6940
• Add duckdb::make_uniq by @carlopi in https://github.com/duckdb/duckdb/pull/6950
• [Dev] Lock Pandas version in CI by @Tishj in https://github.com/duckdb/duckdb/pull/6958
• Bump duckdb-wasm to support duckdb::make_uniq by @carlopi in https://github.com/duckdb/duckdb/pull/6957
• Support for the ** operator in s3 by @lverdoes in https://github.com/duckdb/duckdb/pull/6930
• Add rel_to_sql method to convert relations to SQL again by @hannes in https://github.com/duckdb/duckdb/pull/6952
• [Safety] Add safety checks to unique_ptr access to guard access by @Tishj in https://github.com/duckdb/duckdb/pull/6891
• [Dev] Add missing header guard for concurrentqueue.hpp by @Tishj in https://github.com/duckdb/duckdb/pull/6915
• [Python - Chore] Update name of pybind11 type caster for doc gen by @Tishj in https://github.com/duckdb/duckdb/pull/6963
• Remove unnecessary code from the Python client by @Mytherin in https://github.com/duckdb/duckdb/pull/6972
• Faster PIVOT statement by @Mytherin in https://github.com/duckdb/duckdb/pull/6961
• CREATE TYPE creates an alias to a type - not an actual new type by @Mytherin in https://github.com/duckdb/duckdb/pull/6969
• [Safety] Remove C Style Casts by @Mytherin in https://github.com/duckdb/duckdb/pull/6967
• [Python] Fix issue related to objects that derive from builtin.str by @Tishj in https://github.com/duckdb/duckdb/pull/6978
• [Dev] Make copy/csv/test_union_by_name.test result deterministic by @Tishj in https://github.com/duckdb/duckdb/pull/6987
• Fix #6232 - for SQL value functions, only convert them into functions if there is no column with the same name by @Mytherin in https://github.com/duckdb/duckdb/pull/6982
• Fix #6990: When type has both num_children and type set, prefer the num_children - plus more defensive code in Parquet reader by @Mytherin in https://github.com/duckdb/duckdb/pull/6992
• Issue #6881: Window Memory Segfault by @hawkfish in https://github.com/duckdb/duckdb/pull/6984
• Issue #3207: LogicalAsOfJoin Deserialize by @hawkfish in https://github.com/duckdb/duckdb/pull/6983
• Issue #6959: TRY_STRPTIME Implementation by @hawkfish in https://github.com/duckdb/duckdb/pull/6960
• [Safety] Add safety checks to vector indexing by @Tishj in https://github.com/duckdb/duckdb/pull/6927
• Add json->sql deserialisation and execution. by @Maxxen in https://github.com/duckdb/duckdb/pull/6919
• [Python] Enable rel[name] and rel.name syntax for struct fields by @Tishj in https://github.com/duckdb/duckdb/pull/6988
• LIST aggregate performance improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/6995
• Treat MinGW as a different platform for extension loading purposes by @Mytherin in https://github.com/duckdb/duckdb/pull/7007
• Fixes #6775 Error scalar function by @ozdemircs in https://github.com/duckdb/duckdb/pull/6996
• feat(jdbc): stringify nested types by @Mause in https://github.com/duckdb/duckdb/pull/7000
• feat: standalone autocomplete extension by @Mause in https://github.com/duckdb/duckdb/pull/7010
• add support for scaning over numpy arrays by @vlowingkloude in https://github.com/duckdb/duckdb/pull/6523
• Rework Order Dependence Tracking in Pipelines by @Mytherin in https://github.com/duckdb/duckdb/pull/7006
• [Python] Fix crash related to file-like objects and fsspec by @Tishj in https://github.com/duckdb/duckdb/pull/7012
• Partially fixes #6936 - Avoid unnecessarily calling ToString in expression executor state by @Mytherin in https://github.com/duckdb/duckdb/pull/7018
• [Python] Fix datetime with tzinfo converting to naive TIMESTAMP by @Tishj in https://github.com/duckdb/duckdb/pull/7024
• Fix crash/error caused by importing an empty database. by @Tishj in https://github.com/duckdb/duckdb/pull/7025
• postgres_parser: use std::forward by @carlopi in https://github.com/duckdb/duckdb/pull/7038
• fixed an issue with ** operator by @lverdoes in https://github.com/duckdb/duckdb/pull/7040
• CI - Allow codecov uploads to fail by @Mytherin in https://github.com/duckdb/duckdb/pull/7043
• [DEV]: test_map_subscript reliability by @hawkfish in https://github.com/duckdb/duckdb/pull/7041
• Wasm loadable extensions by @carlopi in https://github.com/duckdb/duckdb/pull/7032
• WebAssembly.yml by @carlopi in https://github.com/duckdb/duckdb/pull/7030
• Issue #6959: ICU TRY_STRPTIME Lists by @hawkfish in https://github.com/duckdb/duckdb/pull/7031
• [External Buffer Manager] Step1: Split components from buffer_manager.cpp by @Tishj in https://github.com/duckdb/duckdb/pull/7028
• Issue #3207: ASOF Join Refactoring by @hawkfish in https://github.com/duckdb/duckdb/pull/7001
• [External Buffer Manager] Step2: Abstracting away the atomic<idx_t> counter by @Tishj in https://github.com/duckdb/duckdb/pull/7053
• Fix Julia BoundsError with arrays > 2048 by @frankier in https://github.com/duckdb/duckdb/pull/7055
• Issue #7013: Implement TRUNC by @hawkfish in