This preview release of DuckDB is named "Fulvigula" after the [Mottled duck (Anas fulvigula)](https://en.wikipedia.org/wiki/Mottled_duck) 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](https://duckdb.org/docs/sql/statements/export) 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-nodev3 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 https://github.com/duckdb/duckdb/pull/7036
* Add to_binary/from_binary functions by lokax in https://github.com/duckdb/duckdb/pull/6848
* [Python] Extend `project` to accept a list of types + add DuckDBPyType class by Tishj in https://github.com/duckdb/duckdb/pull/6777
* Ci wasm by carlopi in https://github.com/duckdb/duckdb/pull/7072
* [Optimizer] Fix `regexp_matches` (again) by Tishj in https://github.com/duckdb/duckdb/pull/7075
* [Safety] Remove many C-style pointers by Mytherin in https://github.com/duckdb/duckdb/pull/7080
* [External Buffer Manager] Step3: `BufferManager` interface,`StandardBufferManager` implementation by Tishj in https://github.com/duckdb/duckdb/pull/7078
* Issue 6882: REGEXP_EXTRACT Capture Groups by hawkfish in https://github.com/duckdb/duckdb/pull/6918
* [feature] Add Damerau-Levenshtein string comparison function by ADBond in https://github.com/duckdb/duckdb/pull/7035
* Logical Get children should be optimized as well by Tmonster in https://github.com/duckdb/duckdb/pull/7046
* [BREAKING] Use Python-style division operator (/ is always floating point division, // is integer division) by Mytherin in https://github.com/duckdb/duckdb/pull/7082
* Issue 6861: Index out of bound for all-NULL case. by xuke-hat in https://github.com/duckdb/duckdb/pull/7070
* Issue 5920: Ordered Aggregate Sorting by hawkfish in https://github.com/duckdb/duckdb/pull/6986
* Decode DuckDB blobs as buffers in Node UDF args by matt-allan in https://github.com/duckdb/duckdb/pull/7059
* Partitioned file naming by lverdoes in https://github.com/duckdb/duckdb/pull/6791
* fix: accept either AWS_REGION or AWS_DEFAULT_REGION by OhmniD in https://github.com/duckdb/duckdb/pull/7090
* Kitchen sink related to duckdb-wasm WIP by carlopi in https://github.com/duckdb/duckdb/pull/7074
* Pb/catch stacktrace by peterboncz in https://github.com/duckdb/duckdb/pull/6991
* [Python] Fix nightly build failure by Tishj in https://github.com/duckdb/duckdb/pull/7104
* Possibly fixing R strict barrier issue by hannes in https://github.com/duckdb/duckdb/pull/6974
* Change chunk_size parameter to approx_rows_per_batch by pdet in https://github.com/duckdb/duckdb/pull/6840
* Add interrupt() to jdbc by zhangyt26 in https://github.com/duckdb/duckdb/pull/7058
* Bump Julia package to v0.7.1 by Mytherin in https://github.com/duckdb/duckdb/pull/7109
* R: Add duckplyr tests by krlmlr in https://github.com/duckdb/duckdb/pull/7097
* [Safety] More C-style pointer removal by Mytherin in https://github.com/duckdb/duckdb/pull/7108
* Disable format_uuid for vsize=2 by Mytherin in https://github.com/duckdb/duckdb/pull/7115
* Fix 7096 - allow specifying a column list for VACUUM without ANALYZE by Mytherin in https://github.com/duckdb/duckdb/pull/7110
* Fix 7093 - correctly extract table names even when tables are present in the catalog by Mytherin in https://github.com/duckdb/duckdb/pull/7111
* Tuple Data Collection by lnkuiper in https://github.com/duckdb/duckdb/pull/6998
* Fix 7083 - correctly reset delta offset when reading a new delta byte array page by Mytherin in https://github.com/duckdb/duckdb/pull/7112
* Bump wasm version by carlopi in https://github.com/duckdb/duckdb/pull/7121
* Using Parallel CSV Reader as a Default Option by pdet in https://github.com/duckdb/duckdb/pull/6977
* Upcast Enum to String in Coalesce Function by pdet in https://github.com/duckdb/duckdb/pull/7114
* ADBC - Arrow Database Connectivity - Integration by pdet in https://github.com/duckdb/duckdb/pull/7086
* Timestampformat also for timestamps with timezones by pdet in https://github.com/duckdb/duckdb/pull/7130
* Remove dependency of arrow import with dataset module by pdet in https://github.com/duckdb/duckdb/pull/6809
* [Safety] Even more C-style pointer removal by Mytherin in https://github.com/duckdb/duckdb/pull/7131
* Accidentally pushed timestamp date with current_date instead of fixed… by pdet in https://github.com/duckdb/duckdb/pull/7148
* string_t - rename GetDataUnsafe to GetData by Mytherin in https://github.com/duckdb/duckdb/pull/7151
* Coalesce expression operator should propagate null by douenergy in https://github.com/duckdb/duckdb/pull/7140
* Issue 7128: Fuzzer DATE_DIFF Overflow by hawkfish in https://github.com/duckdb/duckdb/pull/7137
* Issue 7147: TIMESTAMPTZ to DATE by hawkfish in https://github.com/duckdb/duckdb/pull/7150
* Fix floating point error in SKEW by lnkuiper in https://github.com/duckdb/duckdb/pull/7146
* feat(jdbc): set{Schema,Catalog} by Mause in https://github.com/duckdb/duckdb/pull/7158
* Split ** tests up into two files by lverdoes in https://github.com/duckdb/duckdb/pull/7159
* Arrow Blob Filter Pushdown by pdet in https://github.com/duckdb/duckdb/pull/7164
* Fix 7124 - correctly transform order by/limit in pivot/unpivot statements by Mytherin in https://github.com/duckdb/duckdb/pull/7163
* [Safety] Replacing pointers with references/optional_ptr in the Binder by Tishj in https://github.com/duckdb/duckdb/pull/7136
* Fix kurtosis on macOS by lnkuiper in https://github.com/duckdb/duckdb/pull/7165
* Correctly zero-initialize all unused memory in storage blocks, plus add CI run to ensure all memory is correctly initialized by Mytherin in https://github.com/duckdb/duckdb/pull/7175
* Fix rel to sql by Tmonster in https://github.com/duckdb/duckdb/pull/7172
* Update swift CI run to always push & publish a tag by Mytherin in https://github.com/duckdb/duckdb/pull/7179
* [BREAKING] Switch to NULLS LAST as default null sorting order, instead of NULLS FIRST by Mytherin in https://github.com/duckdb/duckdb/pull/7174
* Issue 3207: ASOF Physical Joins by hawkfish in https://github.com/duckdb/duckdb/pull/7153
* Run ADBC tests on windows by pdet in https://github.com/duckdb/duckdb/pull/7185
* feat(jdbc): support TIME_TZ by Mause in https://github.com/duckdb/duckdb/pull/7193
* Fix ASOF join test null ordering by Mytherin in https://github.com/duckdb/duckdb/pull/7195
* [Python] Add support for Pandas 2.0.0 by Tishj in https://github.com/duckdb/duckdb/pull/7005
* [Safety] Remove C-style pointers in Catalog, use references whenever possible by Mytherin in https://github.com/duckdb/duckdb/pull/7203
* Default allow caps to false by Tmonster in https://github.com/duckdb/duckdb/pull/7201
* Fix the `lineitem` table schema definition error of TPC-H by r4ntix in https://github.com/duckdb/duckdb/pull/7099
* Fix 7219 - we cannot use the ungrouped aggregate if there are multiple grouping sets (even if they are all empty) by Mytherin in https://github.com/duckdb/duckdb/pull/7234
* Move several tests to slow tests by Mytherin in https://github.com/duckdb/duckdb/pull/7249
* [TPC-DS] Fix issues in data generator (7222, 7223, 7225) by Mytherin in https://github.com/duckdb/duckdb/pull/7247
* Issue 7230: Named Window Overrides by hawkfish in https://github.com/duckdb/duckdb/pull/7243
* Correct license code in nodejs project by whscullin in https://github.com/duckdb/duckdb/pull/7241
* Issue 7220 - add support for DEFAULT VALUES clause in INSERT INTO by Mytherin in https://github.com/duckdb/duckdb/pull/7240
* Fix 7235 - correctly detect invalid statistics for decimal type by Mytherin in https://github.com/duckdb/duckdb/pull/7238
* Fix 7119/7120 - correctly do a case insensitive comparison in foreign key REFERENCES by Mytherin in https://github.com/duckdb/duckdb/pull/7236
* [C-API] Add `duckdb_string_t` for use with the data chunk API by Tishj in https://github.com/duckdb/duckdb/pull/7180
* [CSV Reader] Allow quoted nulls by pdet in https://github.com/duckdb/duckdb/pull/7210
* Towards buffer managing the ART - no more tiny allocations by taniabogatsch in https://github.com/duckdb/duckdb/pull/6951
* Implements 7118 - support REFERENCES syntax for single column references by Mytherin in https://github.com/duckdb/duckdb/pull/7237
* Fix spurious CI failure by Mytherin in https://github.com/duckdb/duckdb/pull/7257
* In the parallel CSV reader, prevent buffering of data unnecessarily when reading from compressed files by Mytherin in https://github.com/duckdb/duckdb/pull/7253
* fix(JDBC): push down update count calculation into execute() method by Mause in https://github.com/duckdb/duckdb/pull/7242
* Issue 7013: Implement getTimestamp Calendar by hawkfish in https://github.com/duckdb/duckdb/pull/7276
* fix(jdbc): return valid class names from getColumnClassName by Mause in https://github.com/duckdb/duckdb/pull/7262
* fix(adbc): crash when setting database option due to malloc by zeroshade in https://github.com/duckdb/duckdb/pull/7268
* build: Node 20 builds by Mause in https://github.com/duckdb/duckdb/pull/7286
* [Dev] Rename `ClientProperties` property `timezone` -> `time_zone` by Tishj in https://github.com/duckdb/duckdb/pull/7258
* Add ExtraTests CI run that can be manually triggered to run *all* benchmarks and compare to last release by Mytherin in https://github.com/duckdb/duckdb/pull/7287
* Reset parsed_chunk when figuring out new line in Parallel CSV Reader by pdet in https://github.com/duckdb/duckdb/pull/7284
* fix: add catalog information to the serialization of a few logical operators by stephaniewang526 in https://github.com/duckdb/duckdb/pull/7270
* [Python] Fix 7269 by Tishj in https://github.com/duckdb/duckdb/pull/7301
* [Python] Add `by_name` option to `connection.append` method by Tishj in https://github.com/duckdb/duckdb/pull/7300
* Fix affected row count returned from `INSERT .. ON CONFLICT (..)` statement by Tishj in https://github.com/duckdb/duckdb/pull/7259
* Parquet metadata functions - correctly check for isset on various properties by Mytherin in https://github.com/duckdb/duckdb/pull/7289
* Account for presence of varargs when casting table function arguments by MarkRoddy in https://github.com/duckdb/duckdb/pull/7245
* [Python] Add optional `schema` option to `relation.map` method. by Tishj in https://github.com/duckdb/duckdb/pull/7197
* Force parallelism in R dataframe scans. by Tmonster in https://github.com/duckdb/duckdb/pull/7181
* [Python] Add `:default:` option to get the default connection through `duckdb.connect()` by Tishj in https://github.com/duckdb/duckdb/pull/7144
* Rework function registration, and move most scalar/aggregate functions to "core_functions" directory by Mytherin in https://github.com/duckdb/duckdb/pull/7310
* Add ExtensionUtil class and move function registration to ExtensionUtil by Mytherin in https://github.com/duckdb/duckdb/pull/7312
* [swift] Change Int to Int32 in DatabaseType array documentation by indragiek in https://github.com/duckdb/duckdb/pull/7318
* [swift] Make LogicalType public by indragiek in https://github.com/duckdb/duckdb/pull/7319
* Segmented signing checks on extensions by carlopi in https://github.com/duckdb/duckdb/pull/7311
* chore: add newer extensions to default extensions array by Mause in https://github.com/duckdb/duckdb/pull/7322
* Extend `format` and `printf` to support printing thousand separators similar to SQLite by Mytherin in https://github.com/duckdb/duckdb/pull/7323
* Issue 7315: LocalFileSystem Glob FileExists by hawkfish in https://github.com/duckdb/duckdb/pull/7316
* add `dayname`/`monthname` functions for `timestamptz` type by dylanscott in https://github.com/duckdb/duckdb/pull/7332
* [PythonDev] Fix Python regression test CI by Tishj in https://github.com/duckdb/duckdb/pull/7338
* Simplifying initialization logic by rjatwal in https://github.com/duckdb/duckdb/pull/7282
* More clear error message on mismatching files by lverdoes in https://github.com/duckdb/duckdb/pull/7205
* Pivot - add support for custom subqueries in the IN clause of pivot entries by Mytherin in https://github.com/duckdb/duckdb/pull/7333
* Improve error message when using pivot statement in views or macros by Mytherin in https://github.com/duckdb/duckdb/pull/7328
* [swift] Make ResultSet.rowCount a public member by indragiek in https://github.com/duckdb/duckdb/pull/7334
* [swift] Make Foundation extensions public by indragiek in https://github.com/duckdb/duckdb/pull/7335
* Blocking Sink/Source operators by samansmink in https://github.com/duckdb/duckdb/pull/7331
* Restore serialization of BaseStatistics distinct count by bleskes in https://github.com/duckdb/duckdb/pull/7329
* Improve error message for unexpected constraint violations by taniabogatsch in https://github.com/duckdb/duckdb/pull/7343
* Issue 3545: Fix Adar2 Crash by hawkfish in https://github.com/duckdb/duckdb/pull/7346
* Extension signing: Fix 7311 by carlopi in https://github.com/duckdb/duckdb/pull/7347
* TableCatalogEntry should allow customizing serialization but still be opinionated by bleskes in https://github.com/duckdb/duckdb/pull/7350
* Add format_bytes function that formats bytes to a human readable size by Mytherin in https://github.com/duckdb/duckdb/pull/7342
* Make `SQLLogicTestRunner::LoadDatabase` virtual by Flogex in https://github.com/duckdb/duckdb/pull/7340
* [DEBUG] Add "debug_print_bindings" option to DBConfigOptions by lnkuiper in https://github.com/duckdb/duckdb/pull/7288
* [Arrow] We always output the large buffers, for blobs, bytes, uuids and strings by pdet in https://github.com/duckdb/duckdb/pull/7345
* Julia - Make method `destroy_data_chunk` public - streamed query results must be destroyed before the connection is destroyed by Mytherin in https://github.com/duckdb/duckdb/pull/7361
* [Swift] add Int/UInt decoding to VectorElementDecoder by tcldr in https://github.com/duckdb/duckdb/pull/7362
* Add Minimum Batch Index + Order Preserving Insertion Rework by Mytherin in https://github.com/duckdb/duckdb/pull/7352
* Initialize HTTPFS state when extracting plans by pdet in https://github.com/duckdb/duckdb/pull/7365
* Add support for parallel order-preserving CSV write by Mytherin in https://github.com/duckdb/duckdb/pull/7368
* [Safety] Perform `vector` bounds checking on release builds by Tishj in https://github.com/duckdb/duckdb/pull/7325
* [Dev] Fix some Minio boot problems + extend Makefile for use with extensions by Tishj in https://github.com/duckdb/duckdb/pull/7363
* Add `BinarySerializer`, `EnumUtil::` and generator script by Maxxen in https://github.com/duckdb/duckdb/pull/7351
* Capture database type in config by bleskes in https://github.com/duckdb/duckdb/pull/7359
* Change file exist check to is_pipe and do it in the bind by pdet in https://github.com/duckdb/duckdb/pull/7354
* Column function chaining alias by douenergy in https://github.com/duckdb/duckdb/pull/7313
* Relational set operations coerce to richer type by Tmonster in https://github.com/duckdb/duckdb/pull/7256
* Autodetect hive_partitioning by lverdoes in https://github.com/duckdb/duckdb/pull/7344
* Add missing rowsort to test by Mytherin in https://github.com/duckdb/duckdb/pull/7370
* Fold some DistinctFrom + add bloaty (?) by carlopi in https://github.com/duckdb/duckdb/pull/7374
* [Python] Add null_padding option to read_csv by pdet in https://github.com/duckdb/duckdb/pull/7364
* Add support for parallel order-preserving Parquet write by Mytherin in https://github.com/duckdb/duckdb/pull/7375
* fix: update serialization for logical_delete and logical_update by stephaniewang526 in https://github.com/duckdb/duckdb/pull/7382
* Issue 7353: Filtered Constant Aggregates by hawkfish in https://github.com/duckdb/duckdb/pull/7381
* Add `map_concat` function by Tishj in https://github.com/duckdb/duckdb/pull/7360
* Add catalog parameter to dbgen / dsdgen by ywelsch in https://github.com/duckdb/duckdb/pull/7378
* Fix Ubuntu 16 action: first compile OpenSSL, then Python by carlopi in https://github.com/duckdb/duckdb/pull/7397
* [Python] Add scalar UDF, using `pyarrow` by Tishj in https://github.com/duckdb/duckdb/pull/7171
* Add github actions to contributing.md by douenergy in https://github.com/duckdb/duckdb/pull/7404
* Avoid double rollback caused by a constraint violation by taniabogatsch in https://github.com/duckdb/duckdb/pull/7380
* Addings Tests and Fixes for Multiple CSV Issues by pdet in https://github.com/duckdb/duckdb/pull/7379
* feat(jdbc): native array reading support by Mause in https://github.com/duckdb/duckdb/pull/7369
* Print Error Lines in the Parallel CSV Reader by pdet in https://github.com/duckdb/duckdb/pull/7184
* SQLite - Fix SQLiteScanner45 by applying correct extension alias and upgrade SQLite extension by Mytherin in https://github.com/duckdb/duckdb/pull/7405
* Correctly concatenate ART prefixes during deletions by taniabogatsch in https://github.com/duckdb/duckdb/pull/7410
* Add support in the parser for `PREPARE COPY ...` by Tishj in https://github.com/duckdb/duckdb/pull/7409
* Fix elusive unrecognized ART node type bug by taniabogatsch in https://github.com/duckdb/duckdb/pull/7372
* Change exception type for invalid parquet by ccfelius in https://github.com/duckdb/duckdb/pull/7402
* [Optimizer] Fix issue with COMPARE NOT EQUAL and cast overflow by Tishj in https://github.com/duckdb/duckdb/pull/7413
* CI NodeJS: build and publish nightly for M1 by carlopi in https://github.com/duckdb/duckdb/pull/7429
* Issue 7426: DuckDBVector getTimestamp by hawkfish in https://github.com/duckdb/duckdb/pull/7428
* [Julia] Fix 7420 - Don't use `unsafe_string` in `appender.jl` by Tishj in https://github.com/duckdb/duckdb/pull/7427
* Correctly reset the ART keys during index joins by taniabogatsch in https://github.com/duckdb/duckdb/pull/7425
* Remove FileOpener almost everywhere - instead wrap FileSystem in the ClientContext with an "OpenerFileSystem" by Mytherin in https://github.com/duckdb/duckdb/pull/7423
* Make CSV error line numbers 1-indexed by Maxxen in https://github.com/duckdb/duckdb/pull/7422
* Parquet: Check for valid UTF8 also in statistics by carlopi in https://github.com/duckdb/duckdb/pull/7421
* Fix 7023 by Tishj in https://github.com/duckdb/duckdb/pull/7419
* Fix 7263 by carlopi in https://github.com/duckdb/duckdb/pull/7414
* [swift] Add a CodingUserInfoKey for accessing the LogicalType by indragiek in https://github.com/duckdb/duckdb/pull/7371
* Implement JSON <-> Nested types casting by lnkuiper in https://github.com/duckdb/duckdb/pull/7366
* CI - comment out failing CSV tests for now by Mytherin in https://github.com/duckdb/duckdb/pull/7435
* Fix 7274 - correctly do a case insensitive comparison in UndoBuffer::Undo by Mytherin in https://github.com/duckdb/duckdb/pull/7445
* Fix 7348 - In RowGroupCollection::RemoveFromIndexes - correctly account for the case where the row identifiers might not all be present in the same row group by Mytherin in https://github.com/duckdb/duckdb/pull/7442
* Fix 6611 - List lambdas didn't support different vector types by Tishj in https://github.com/duckdb/duckdb/pull/7424
* Swap Children of Logical ANY joins (or block nl joins) when possible by Tmonster in https://github.com/duckdb/duckdb/pull/7437
* Add initialization of HTTPState to `TryBindRelation` by Tishj in https://github.com/duckdb/duckdb/pull/7443
* Initialize the first two smallest plans when creating a cross product by Tmonster in https://github.com/duckdb/duckdb/pull/7438
* Fix another index join bug and move to generated data by taniabogatsch in https://github.com/duckdb/duckdb/pull/7441
* 7415 cross-product joins on parquet files by Tmonster in https://github.com/duckdb/duckdb/pull/7455
* Support binding of ON CONFLICT clauses for extension tables by Mytherin in https://github.com/duckdb/duckdb/pull/7447
* Add MAP {} syntax for easier map construction by Mytherin in https://github.com/duckdb/duckdb/pull/7459
* Add support for `INTERVAL` type in `BETWEEN` expression by Tishj in https://github.com/duckdb/duckdb/pull/7461
* Lipo macos extensions to reduce their size by samansmink in https://github.com/duckdb/duckdb/pull/7469
* Fix fuzzer issue 132 by lnkuiper in https://github.com/duckdb/duckdb/pull/7456
* Fix unnest rewriter bug by taniabogatsch in https://github.com/duckdb/duckdb/pull/7467
* [Safety] Enable `unique_ptr` safety checks on release builds by Tishj in https://github.com/duckdb/duckdb/pull/7449
* Add support for array_to_string as an alias to list_aggr with 'string_agg' by Mytherin in https://github.com/duckdb/duckdb/pull/7476
* Fix 7377 - correctly account for memory allocated in reset buffer of CSVFileHandle, and remove unnecessary caching for gzip files by Mytherin in https://github.com/duckdb/duckdb/pull/7466
* Fixes 7439 and 7433 by carlopi in https://github.com/duckdb/duckdb/pull/7454
* Signing binaries and extensions for OSX by hannes in https://github.com/duckdb/duckdb/pull/7484
* Add support for INSERT INTO tbl BY NAME by Mytherin in https://github.com/duckdb/duckdb/pull/7475
* link Out-of-tree extensions in node/R/python build + fix arrow extension by samansmink in https://github.com/duckdb/duckdb/pull/7458
* Fix (de)serialization + enable serialization verification for more operators by Mytherin in https://github.com/duckdb/duckdb/pull/7468
* disable assertions in release node binaries by samansmink in https://github.com/duckdb/duckdb/pull/7487
* feat(jdbc): Statementcancel() by Mause in https://github.com/duckdb/duckdb/pull/7489
* Fix 6234 - throw invalid input exception when attempting to create non-temp entry in temp database, and disallow SET SCHEMA to temp/system schemas by Mytherin in https://github.com/duckdb/duckdb/pull/7483
* Simplify COLUMNS with lambda -> operate only on column names, instead of qualified names by Mytherin in https://github.com/duckdb/duckdb/pull/7499
* Fix 6666 - when reading an index in the CheckpointReader directly use the table entry by Mytherin in https://github.com/duckdb/duckdb/pull/7481
* Expand SHOW ALL to include schema/database name, and add SHOW ALL TABLES alias by Mytherin in https://github.com/duckdb/duckdb/pull/7500
* Fix 5777 - always read free-list of database, also in read-only mode by Mytherin in https://github.com/duckdb/duckdb/pull/7501
* Run old CSV reader when reading many files by Mytherin in https://github.com/duckdb/duckdb/pull/7490
* Build extensions for R on Windows using MinGW by hannes in https://github.com/duckdb/duckdb/pull/7440
* JSON reader improvements/fixes by lnkuiper in https://github.com/duckdb/duckdb/pull/7478
* Windows File System Unicode Fixes and correctly expand home directory in ATTACH/DBInstanceCache by Mytherin in https://github.com/duckdb/duckdb/pull/7503
* JSON: Fix missing std::move by carlopi in https://github.com/duckdb/duckdb/pull/7507
* [Dev] Add SQLString and SQLIndentifier helpers for `ExceptionFormatValue` by Tishj in https://github.com/duckdb/duckdb/pull/7486
* Unsupported .help options removal by lverdoes in https://github.com/duckdb/duckdb/pull/7488
* Remove even more unsupported options from the shell's .help by Mytherin in https://github.com/duckdb/duckdb/pull/7511
* Increment julia version to v0.8.0 by Mytherin in https://github.com/duckdb/duckdb/pull/7517
* Fixes 7504 and other minor spurious CI issues by Mytherin in https://github.com/duckdb/duckdb/pull/7509
* Fix amalgamation builds avoiding linking utf8proc by carlopi in https://github.com/duckdb/duckdb/pull/7512
* Change HTTPState to a shared_ptr so it doesn't get invalidated in prepared statements by pdet in https://github.com/duckdb/duckdb/pull/7523
* [Dev] `unique_ptr` helper renames by Tishj in https://github.com/duckdb/duckdb/pull/7516
* un-exporting sql() in R by hannes in https://github.com/duckdb/duckdb/pull/7525
* Alias replacement scans to table name if no explicit alias is provided by the replacement scan by Mytherin in https://github.com/duckdb/duckdb/pull/7526
* [Python] `read_json` API changes by Tishj in https://github.com/duckdb/duckdb/pull/7505
* Fix minor benchmark errors by carlopi in https://github.com/duckdb/duckdb/pull/7510
* Fix spurious CI /2 by carlopi in https://github.com/duckdb/duckdb/pull/7515
* [UPSERT] Check for conflict constraint errors within a transaction by Tishj in https://github.com/duckdb/duckdb/pull/7407
* Fix 7356 by Tishj in https://github.com/duckdb/duckdb/pull/7417
* [Python] Fix GIL issue in `sql` with multiple statements by Tishj in https://github.com/duckdb/duckdb/pull/7534
* Changing platform define for mingw by hannes in https://github.com/duckdb/duckdb/pull/7533
* set the min os x to 11.0 for universal by aprock in https://github.com/duckdb/duckdb/pull/7497
* Correctly shift row IDs during ART deletions by taniabogatsch in https://github.com/duckdb/duckdb/pull/7538
* Add internal option to export small buffers to arrow strings by pdet in https://github.com/duckdb/duckdb/pull/7540
* fix: correct format specifier by Mause in https://github.com/duckdb/duckdb/pull/7544
* Add spatial extension to CI by Maxxen in https://github.com/duckdb/duckdb/pull/7545
**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.7.1...v0.8.0