DuckDB 0.6.0 release notes

This preview release of DuckDB is named "Oxyura" after the White-headed duck (Oxyura leucocephala) which is an endangered species native to Eurasia.

This time, @Mytherin has written a blog post explaining the quite long and exciting list of new features in this release.

Binary builds are listed at the bottom of this post. Please note that it can take a couple of hours until binary builds for all platforms and environments are available.

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.

Featured Changes

Optimistically write data to disk when batch loading data into the system by @Mytherin in https://github.com/duckdb/duckdb/pull/4996
Parallel non-order preserving CREATE TABLE AS and INSERT INTO by @Mytherin in https://github.com/duckdb/duckdb/pull/5033
Parallel order preserving CREATE TABLE AS and INSERT INTO by @Mytherin in https://github.com/duckdb/duckdb/pull/5082
FSST compression by @samansmink in https://github.com/duckdb/duckdb/pull/4366
CHIMP128 Compression by @Tishj in https://github.com/duckdb/duckdb/pull/4878
Patas Compression (float/double) (variation on Chimp) by @Tishj in https://github.com/duckdb/duckdb/pull/5044
Parallel CSV Reader by @pdet in https://github.com/duckdb/duckdb/pull/5194
Parallelize CREATE INDEX of ART by @taniabogatsch in https://github.com/duckdb/duckdb/pull/4655
Improve memory management of ART indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5292
DISTINCT aggregates with GROUP BY are now executed in parallel by @Tishj in https://github.com/duckdb/duckdb/pull/5146
Nested "UNION"-type by @Maxxen in https://github.com/duckdb/duckdb/pull/4966
Allow for queries to start with FROM, instead of with SELECT by @Mytherin in https://github.com/duckdb/duckdb/pull/5076
Support for the COLUMNS expression, which allows expanding computations on multiple columns by @Mytherin in https://github.com/duckdb/duckdb/pull/5120
Python-style list-comprehension syntax @Mytherin in https://github.com/duckdb/duckdb/pull/4926
Improvements to Out-of-Core Hash Join by @lnkuiper in https://github.com/duckdb/duckdb/pull/4970
jemalloc "extension" for Linux by @lnkuiper in https://github.com/duckdb/duckdb/pull/4971
Improve rendering of result sets for the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5140
Add auto-complete support to the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/4921
Nicer looking progress bar by @Mytherin in https://github.com/duckdb/duckdb/pull/5187

All Changes

Fix #4747: Handle pandas num categories between 128 and 256 by @pankajp in https://github.com/duckdb/duckdb/pull/4757
Julia 0.5.1 by @Mytherin in https://github.com/duckdb/duckdb/pull/4758
Fix #3595: avoid using system hash for floating point values by @Mytherin in https://github.com/duckdb/duckdb/pull/4761
Fix #4704. Correct the column name for pragma_storage_info with generated column by @zippond in https://github.com/duckdb/duckdb/pull/4750
Allow to load extensions through compiler variable definitions by @pdet in https://github.com/duckdb/duckdb/pull/4767
Fix some typo in code comments by @buaazhwb in https://github.com/duckdb/duckdb/pull/4769
Enhance duckdb_constraints() by @krlmlr in https://github.com/duckdb/duckdb/pull/4346
Issue #4764: Window Ignore Nulls by @hawkfish in https://github.com/duckdb/duckdb/pull/4773
[Python (Relational)] Query now returns a DuckDBPyRelation by @Tishj in https://github.com/duckdb/duckdb/pull/4471
R types expansion by @hannes in https://github.com/duckdb/duckdb/pull/4778
Add json_contains by @lnkuiper in https://github.com/duckdb/duckdb/pull/4686
Fix #4152: create base table reference in returning clause so generated columns are correctly resolved by @Mytherin in https://github.com/duckdb/duckdb/pull/4783
Fix Exists and ANY correlated subquerys by @lokax in https://github.com/duckdb/duckdb/pull/4752
Fix for ORDER BY on large dictionary vectors: correctly pass offset into get_index of selection vector by @Mytherin in https://github.com/duckdb/duckdb/pull/4787
Missing json_contains in extension list by @Mytherin in https://github.com/duckdb/duckdb/pull/4788
Extensible Casts & Cast Function Rework by @Mytherin in https://github.com/duckdb/duckdb/pull/4785
Bump sqlite scanner by @hannes in https://github.com/duckdb/duckdb/pull/4789
Improve sorting for strings and push projections into sort operator by @lnkuiper in https://github.com/duckdb/duckdb/pull/4697
Parquet: Refactor decompression, including more complete datapage v2 support by @wisp3rwind in https://github.com/duckdb/duckdb/pull/4628
Parallelize CREATE INDEX of ART by @taniabogatsch in https://github.com/duckdb/duckdb/pull/4655
Unify LocalStorage and DataTable Storage by @Mytherin in https://github.com/duckdb/duckdb/pull/4798
feat: support passing all db config to jdbc driver by @Mause in https://github.com/duckdb/duckdb/pull/4794
Fix #4806: correctly use offset index in pragma_table_info on view by @Mytherin in https://github.com/duckdb/duckdb/pull/4807
Map VARCHAR, JSON, ENUM to Julia String by @nickrobinson251 in https://github.com/duckdb/duckdb/pull/4810
fix: support SHOW query types in jdbc client by @Mause in https://github.com/duckdb/duckdb/pull/4799
Replacement Open Hooks by @hannes in https://github.com/duckdb/duckdb/pull/4721
Build multiple out of tree extensions in one pass by @Mytherin in https://github.com/duckdb/duckdb/pull/4828
fix(jdbc): release results before releasing statements by @Mause in https://github.com/duckdb/duckdb/pull/4831
Fix for #4827 by @PedroTadim in https://github.com/duckdb/duckdb/pull/4829
Multiblock2 by @jkub in https://github.com/duckdb/duckdb/pull/4555
Disconnect after test by @krlmlr in https://github.com/duckdb/duckdb/pull/4835
Check prefix length, not string_t::INLINE_LENGTH when comparing strings while sorting by @lnkuiper in https://github.com/duckdb/duckdb/pull/4816
Adding a CI workflow to re-build individual out-of-tree extensions by @hannes in https://github.com/duckdb/duckdb/pull/4833
fix: json getColumnType error by @Mause in https://github.com/duckdb/duckdb/pull/4847
Attempt two at rebuilding old extensions by @hannes in https://github.com/duckdb/duckdb/pull/4848
Updating postgres scanner by @hannes in https://github.com/duckdb/duckdb/pull/4832
Extension Rebuild Attempt 3 by @hannes in https://github.com/duckdb/duckdb/pull/4849
Adding overwrite flag to R duckdb_register by @hannes in https://github.com/duckdb/duckdb/pull/4850
Move LocalStorage row groups directly to DataTable instead of re-appending by @Mytherin in https://github.com/duckdb/duckdb/pull/4851
fix for macos CI by @samansmink in https://github.com/duckdb/duckdb/pull/4854
Fully qualified s3url by @LindsayWray in https://github.com/duckdb/duckdb/pull/4786
FSST compression by @samansmink in https://github.com/duckdb/duckdb/pull/4366
Julia: add support for handling errors in replacement scans by @Mytherin in https://github.com/duckdb/duckdb/pull/4865
Extension build: turn IGNORE_WARNINGS into generic OPTIONS field, and add --main-only field by @Mytherin in https://github.com/duckdb/duckdb/pull/4866
Issue #4867: Approximate Quantile Hugeint by @hawkfish in https://github.com/duckdb/duckdb/pull/4868
Install OpenSSH on ubuntu 16 by @Mytherin in https://github.com/duckdb/duckdb/pull/4877
Join order regression test: add 20% threshold to cardinalities before we care about regressions by @Mytherin in https://github.com/duckdb/duckdb/pull/4880
Move LocalStorage row groups directly to DataTable if there are enough rows being appended by @Mytherin in https://github.com/duckdb/duckdb/pull/4876
Allow referencing of aliases in SELECT clause and TPC-DS extension clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/4879
Add github to known hosts by @Mytherin in https://github.com/duckdb/duckdb/pull/4884
Adding a serialized version of all TPCH queries and test we can read them by @bleskes in https://github.com/duckdb/duckdb/pull/4605
Add support for custom bind functions to RegisterCastFunction, and propagate client context to the bind function by @Mytherin in https://github.com/duckdb/duckdb/pull/4885
CSV reader: quoted NULL values should be kept as non-NULL by @Mytherin in https://github.com/duckdb/duckdb/pull/4888
fix: add numpy to setup_requires to fix build from source by @Mause in https://github.com/duckdb/duckdb/pull/4893
fix openFlags overwriting in shell fixing #4894 by @kouta-kun in https://github.com/duckdb/duckdb/pull/4895
Remove filter columns from table scans if they are unused in the remainder of the plan by @lnkuiper in https://github.com/duckdb/duckdb/pull/4817
feat: add duckdb_library_version method and fix extension load state by @Mause in https://github.com/duckdb/duckdb/pull/4881
uuid.cpp: GenerateRandomUUID: fix indexing by @nodakai in https://github.com/duckdb/duckdb/pull/4892
Update serialized plans by @Mytherin in https://github.com/duckdb/duckdb/pull/4900
Add CPython 3.11 to build matrix by @edgarrmondragon in https://github.com/duckdb/duckdb/pull/4906
Support UNION_BY_NAME option in read_csv_auto by @douenergy in https://github.com/duckdb/duckdb/pull/4837
support for virtualizing storage layer by @jkub in https://github.com/duckdb/duckdb/pull/4858
Reduce data set size of IE join test by @Mytherin in https://github.com/duckdb/duckdb/pull/4905
Making sure parquet column readers return the expected amount of rows by @hannes in https://github.com/duckdb/duckdb/pull/4909
Issue #3187: TIMESTAMPTZ <=> VARCHAR by @hawkfish in https://github.com/duckdb/duckdb/pull/4904
Fix breaking CI on unused variable errors by @Tishj in https://github.com/duckdb/duckdb/pull/4916
Issue #4912: NOW returns TIMESTAMPTZ by @hawkfish in https://github.com/duckdb/duckdb/pull/4914
Add ClickBench to benchmark suite by @Mytherin in https://github.com/duckdb/duckdb/pull/4919
Add auto-complete support to the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/4921
Add support for list parameters to read_csv and read_csv_auto by @Mytherin in https://github.com/duckdb/duckdb/pull/4922
- methods for sink_schema by @alitrack in https://github.com/duckdb/duckdb/pull/4918
Add Python-style list-comprehension syntax support to SQL by @Mytherin in https://github.com/duckdb/duckdb/pull/4926
Auto-complete: prioritize files with known extensions, and include position at which completion should be placed by @Mytherin in https://github.com/duckdb/duckdb/pull/4930
Fix ART by @lokax in https://github.com/duckdb/duckdb/pull/4763
[Python] Add support for Protocols by @Tishj in https://github.com/duckdb/duckdb/pull/4435
Work-around for #4935: throw internal error if there is no node by @Mytherin in https://github.com/duckdb/duckdb/pull/4940
Fix #4933: avoid introducing NULL value on first value after empty row by @Mytherin in https://github.com/duckdb/duckdb/pull/4934
Issue #4942: Check DESC Errors by @hawkfish in https://github.com/duckdb/duckdb/pull/4945
Issue #4944: Negative Unpadded Centuries by @hawkfish in https://github.com/duckdb/duckdb/pull/4948
Issue #4943: Date Nanosecond Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/4947
feat: add copy method for logical_operator by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/4915
Bug fix for segmentation fault in list apply by @taniabogatsch in https://github.com/duckdb/duckdb/pull/4910
Fixing hmac for large secrets in S3FS by @hannes in https://github.com/duckdb/duckdb/pull/4949
buffered by @jkub in https://github.com/duckdb/duckdb/pull/4924
Caching Database Instances by @pdet in https://github.com/duckdb/duckdb/pull/4414
Faster ART key allocations, faster index join by @taniabogatsch in https://github.com/duckdb/duckdb/pull/4800
Add CI run with disabled string inlining by @Mytherin in https://github.com/duckdb/duckdb/pull/4957
Split row-group append into Initialize/Append/Finalize and separate append code from version info append by @Mytherin in https://github.com/duckdb/duckdb/pull/4953
Issue #4965: DateDiff Day Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/4973
noswizzle by @jkub in https://github.com/duckdb/duckdb/pull/4923
Issue #4978: DATE_SUB Subtraction Overflows by @hawkfish in https://github.com/duckdb/duckdb/pull/4985
feat: request that people raise scanner issues in the right repos by @Mause in https://github.com/duckdb/duckdb/pull/4956
avoid double-writing the index data by @jkub in https://github.com/duckdb/duckdb/pull/4946
[Python] Optional Pandas Date as datetime by @pdet in https://github.com/duckdb/duckdb/pull/4633
Optimistically write data to disk when batch loading data into the system by @Mytherin in https://github.com/duckdb/duckdb/pull/4996
Bring substrait-extension build back by @pdet in https://github.com/duckdb/duckdb/pull/4993
fix(jdbc): shutdown database after last connection is closed by @Mause in https://github.com/duckdb/duckdb/pull/4990
Add support for TRUNCATE [TABLE] syntax by @Mytherin in https://github.com/duckdb/duckdb/pull/5001
Directly merge row groups from local storage into table even if the table has indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5003
String to list casting by @LindsayWray in https://github.com/duckdb/duckdb/pull/4994
Optimize away DELIM_JOIN even when the child join with the DELIM_GET is an inequality join by @lnkuiper in https://github.com/duckdb/duckdb/pull/4991
JDBC: Add public getter for statement return type by @Jens-H in https://github.com/duckdb/duckdb/pull/5014
Remove duplicate code by @lokax in https://github.com/duckdb/duckdb/pull/5008
Fix lambda bug for struct extract by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5007
Support CREATE OR REPLACE / TEMPORARY / IF NOT EXISTS with CREATE MACRO / FUNCTION by @lnkuiper in https://github.com/duckdb/duckdb/pull/5006
Fixing #4859, correctly passing struct type to recursive calls by @hannes in https://github.com/duckdb/duckdb/pull/5017
[CSV] Added line number to 'maximum_line_size' exceeded error by @Tishj in https://github.com/duckdb/duckdb/pull/5018
ODBC/JDBC Database Instance Cache by @Mytherin in https://github.com/duckdb/duckdb/pull/5004
String functions: count unicode codepoints instead of grapheme clusters by @Mytherin in https://github.com/duckdb/duckdb/pull/5028
Support file_search_path with globbing by @whscullin in https://github.com/duckdb/duckdb/pull/5021
First cut at TypeScript type declarations for DuckDb by @antonycourtney in https://github.com/duckdb/duckdb/pull/5025
Undefined behavior sanitizer error fix by @Tishj in https://github.com/duckdb/duckdb/pull/5030
[Compression] CHIMP128 Compression Algorithm by @Tishj in https://github.com/duckdb/duckdb/pull/4878
Parallel non-order preserving CREATE TABLE AS and INSERT INTO by @Mytherin in https://github.com/duckdb/duckdb/pull/5033
fsst bugfix by @samansmink in https://github.com/duckdb/duckdb/pull/5042
Avoid installing git for ODBC Windows CI Run by @Mytherin in https://github.com/duckdb/duckdb/pull/5051
Fix for shell auto-complete by @Mytherin in https://github.com/duckdb/duckdb/pull/5047
Fix a race condition in an assert by @Mytherin in https://github.com/duckdb/duckdb/pull/5049
[Python] Accept 'schema' in table reference by @Tishj in https://github.com/duckdb/duckdb/pull/5059
Fix levenshtein(s1, s2) for empty strings by @lmores in https://github.com/duckdb/duckdb/pull/5062
Correctly handle NULL values in compound ART keys by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5010
Issue #5023: Fully Parallel Partitioning by @hawkfish in https://github.com/duckdb/duckdb/pull/5024
Enable remote optimizer test by @Y-- in https://github.com/duckdb/duckdb/pull/5019
make wal impl more reusable by @jkub in https://github.com/duckdb/duckdb/pull/5071
Optionally allow for queries to start with FROM, instead of with SELECT by @Mytherin in https://github.com/duckdb/duckdb/pull/5076
[Python] Fall back to DOUBLE for unsupported DECIMAL widths by @Tishj in https://github.com/duckdb/duckdb/pull/4749
Issue #5046: Window Size Restriction by @hawkfish in https://github.com/duckdb/duckdb/pull/5079
Shell: fixes for auto-complete of home directory and absolute paths by @Mytherin in https://github.com/duckdb/duckdb/pull/5081
Varsizeblock by @jkub in https://github.com/duckdb/duckdb/pull/5069
Parallel order preserving CREATE TABLE AS and INSERT INTO by @Mytherin in https://github.com/duckdb/duckdb/pull/5082
Fix #5077: correctly handle carriage return newlines in CSV auto-detection by @Mytherin in https://github.com/duckdb/duckdb/pull/5083
caching table-in-out-functions & chunk cache refactor by @samansmink in https://github.com/duckdb/duckdb/pull/4992
Fix for #4935: throw internal error if there is no node by @Tmonster in https://github.com/duckdb/duckdb/pull/5089
Add nested "union"-type by @Maxxen in https://github.com/duckdb/duckdb/pull/4966
Row Group Collection - smaller allocations for tiny tables by @Mytherin in https://github.com/duckdb/duckdb/pull/5086
chore: pin setuptools_scm to py3.6 compatible version by @Mause in https://github.com/duckdb/duckdb/pull/5099
Correctly scan unaligned row groups in DataTable::ScanTableSegment by @Mytherin in https://github.com/duckdb/duckdb/pull/5101
feat: implement DatabaseMetadata#getFunctions() by @Mause in https://github.com/duckdb/duckdb/pull/5090
Support batch index in arrow scans by @Mytherin in https://github.com/duckdb/duckdb/pull/5085
Arrow support for JDBC ResultSet by @hannes in https://github.com/duckdb/duckdb/pull/5088
fix(jdbc): gracefully handle null bytes in strings by @Mause in https://github.com/duckdb/duckdb/pull/5100
Add file_row_number flag to parquet reader by @hannes in https://github.com/duckdb/duckdb/pull/5084
Fix comment by @zhouliqi in https://github.com/duckdb/duckdb/pull/5110
Add ErrorManager class, allow SQLLogicTests to verify error messages, and improve CSV reader errors by @Mytherin in https://github.com/duckdb/duckdb/pull/5103
Add support for the COLUMNS expression, which allows expanding computations on multiple columns by @Mytherin in https://github.com/duckdb/duckdb/pull/5120
Issue #5107: ICU Data Scripts by @hawkfish in https://github.com/duckdb/duckdb/pull/5109
Batch Insert: Add support for eagerly merging of small adjacent batch indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5113
Add temporary 'skip_reload' to problematic test by @Tishj in https://github.com/duckdb/duckdb/pull/5133
[Python] Add MSVC /utf-8 flag by @metab0t in https://github.com/duckdb/duckdb/pull/5129
Convert values whose data types do not have explicit support in NodeJS into strings by @jwills in https://github.com/duckdb/duckdb/pull/5130
Download OpenSSL from Github instead by @Mytherin in https://github.com/duckdb/duckdb/pull/5141
Add BoxRenderer class - which improves rendering of result sets for the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5140
[Dev] Add extension to excluded folder in `format.py' (format-fix/master) by @Tishj in https://github.com/duckdb/duckdb/pull/5142
Fix #5124: correctly deal with DICTIONARY vectors inside LIST vectors for various functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5151
[Aggregate] DISTINCT aggregates with GROUP BY are now executed in parallel by @Tishj in https://github.com/duckdb/duckdb/pull/5146
[Python] Exceptions encountered in 'with' body are now properly propagated by @Tishj in https://github.com/duckdb/duckdb/pull/5157
Create enum type from query by @lokax in https://github.com/duckdb/duckdb/pull/5126
Fix #5149: better tracking of query location in column reference, and improve error message by @Mytherin in https://github.com/duckdb/duckdb/pull/5158
Allow builder to set GIT_COMMIT_HASH by @Y-- in https://github.com/duckdb/duckdb/pull/5164
Fsst bug by @samansmink in https://github.com/duckdb/duckdb/pull/5168
[Python] Arrow Dataset type requirement is now less strict by @Tishj in https://github.com/duckdb/duckdb/pull/5170
Fix progress bar of regular table scan by @Mytherin in https://github.com/duckdb/duckdb/pull/5171
Document highlight features in the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5176
Support parallel (batch) insertion into tables that have indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5177
Support casting of hex strings to integer types by @IanCal in https://github.com/duckdb/duckdb/pull/5160
[Aggregate] Fix regressions caused by latest distinct HT operator PR by @Tishj in https://github.com/duckdb/duckdb/pull/5169
R: Remove duckdb:: qualifier by @krlmlr in https://github.com/duckdb/duckdb/pull/5135
[Compression] Patas Compression (float/double) (variation on Chimp) by @Tishj in https://github.com/duckdb/duckdb/pull/5044
[C-API] Decimal casting to other type fixes by @Tishj in https://github.com/duckdb/duckdb/pull/4526
Default NULL handing for CARDINALITY function by @lokax in https://github.com/duckdb/duckdb/pull/5073
Update OpenSSL to 1.1.1s by @sjaenick in https://github.com/duckdb/duckdb/pull/5184
Box renderer: Always display "0 rows" if there are no rows by @Mytherin in https://github.com/duckdb/duckdb/pull/5188
chore: request OS version and architecture in bug reports by @Mause in https://github.com/duckdb/duckdb/pull/5191
String to struct cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5147
Optimize String Split by @Mytherin in https://github.com/duckdb/duckdb/pull/5186
Nicer looking progress bar by @Mytherin in https://github.com/duckdb/duckdb/pull/5187
Correctly call Reset on cast_chunk in CSV writer to prevent string heap from continuously accumulating data by @Mytherin in https://github.com/duckdb/duckdb/pull/5199
Increase vector size to 2048 by @Mytherin in https://github.com/duckdb/duckdb/pull/5193
Issue #5131: Time Zone 2022f … by @hawkfish in https://github.com/duckdb/duckdb/pull/5198
jemalloc "extension" for Linux by @lnkuiper in https://github.com/duckdb/duckdb/pull/4971
Further clarify database invalidation error, unify db/transaction invalidation, and move errors to error manager by @Mytherin in https://github.com/duckdb/duckdb/pull/5213
fix: build NodeJS bindings for M1 by @Mause in https://github.com/duckdb/duckdb/pull/5189
Arrow extension by @samansmink in https://github.com/duckdb/duckdb/pull/5195
Fix distinct aggregate race: insert next event before scheduling tasks by @Mytherin in https://github.com/duckdb/duckdb/pull/5219
Avoid exporting SQLite symbols from our sqlite_api_wrapper when building the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5217
buffermanager accounting by @jkub in https://github.com/duckdb/duckdb/pull/5134
Allow NULL bytes in strings by @Mytherin in https://github.com/duckdb/duckdb/pull/5218
Use cmake's find_package to trace git executable by @bleskes in https://github.com/duckdb/duckdb/pull/5220
Issue #5197: Deterministic TimeZone Abbreviations by @hawkfish in https://github.com/duckdb/duckdb/pull/5214
Issue #5239: DATE_DIFF Microseconds Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/5242
Various CI Improvements/Speed Ups by @Mytherin in https://github.com/duckdb/duckdb/pull/5228
Issue #5240: DATE_TRUNC Statistics Orientation by @hawkfish in https://github.com/duckdb/duckdb/pull/5241
Improvements to Out-of-Core Hash Join by @lnkuiper in https://github.com/duckdb/duckdb/pull/4970
Add support for extension aliases by @Mytherin in https://github.com/duckdb/duckdb/pull/5226
Physical batch insert: correctly optimistically flush batches to disk that are close to our row group size by @Mytherin in https://github.com/duckdb/duckdb/pull/5231
Fix Python stub test by @Mytherin in https://github.com/duckdb/duckdb/pull/5245
DISTINCT grouped aggregate lowered memory consumption optimization by @Tishj in https://github.com/duckdb/duckdb/pull/5227
fix: bump node-gyp version by @Mause in https://github.com/duckdb/duckdb/pull/5221
json_extract bugfixes and memory accounting bugfix by @lnkuiper in https://github.com/duckdb/duckdb/pull/5204
[Python] Add support for strided float32 and float64 data by @Tishj in https://github.com/duckdb/duckdb/pull/5256
Issue #4978 - 4. Cardinality estimator assertion errors and filter errors by @Tmonster in https://github.com/duckdb/duckdb/pull/5232
Adding total_uncompressed_size to parquet column chunk metadata by @hannes in https://github.com/duckdb/duckdb/pull/5216
Issue #5258: Inverse Percentile NULLs by @hawkfish in https://github.com/duckdb/duckdb/pull/5260
Issue #5205: TIMESTAMPTZ Casting by @hawkfish in https://github.com/duckdb/duckdb/pull/5229
1. Like empty list assertion error by @LindsayWray in https://github.com/duckdb/duckdb/pull/5261
fix: fix python stub test by @Mause in

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