DuckDB 0.7.0 release notes

This preview release of DuckDB is named "Labradorius" after the Labrador duck (Camptorhynchus labradorius) which was native to North America and went extinct in 1878 despite its reportedly bad taste.

Again, @Mytherin has written a blog post explaining the 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.

What's Changed

Use structs to avoid confusing C pointer wrappers by @krlmlr in https://github.com/duckdb/duckdb/pull/4961
Enum type added to the types metadata table by @LindsayWray in https://github.com/duckdb/duckdb/pull/5290
R: code format by @krlmlr in https://github.com/duckdb/duckdb/pull/5185
Add starts_with function and operator by @papparapa in https://github.com/duckdb/duckdb/pull/5334
Feature: Allow binary-formatted strings to be cast to integers by @Maxxen in https://github.com/duckdb/duckdb/pull/5337
For range joins use NL join when the LHS or RHS side is tiny by @Mytherin in https://github.com/duckdb/duckdb/pull/5399
Add support for LATERAL joins by @Mytherin in https://github.com/duckdb/duckdb/pull/5393
[Julia] Add support for consuming a UNION vector into a DataFrame by @Tishj in https://github.com/duckdb/duckdb/pull/5360
Issue #5314: At Time Zone by @hawkfish in https://github.com/duckdb/duckdb/pull/5341
Decimal values now round when the value given has more decimals than the scale of the target by @Tishj in https://github.com/duckdb/duckdb/pull/5362
Shell: add individual SQL queries to the history, instead of individual lines by @Mytherin in https://github.com/duckdb/duckdb/pull/5414
Shell: add support for history search by @Mytherin in https://github.com/duckdb/duckdb/pull/5415
Parallelise scanning result of ORDER_BY by @lnkuiper in https://github.com/duckdb/duckdb/pull/5403
Add translate function by @zhouliqi in https://github.com/duckdb/duckdb/pull/5212
Enable cmake to recognize AppleClang by @changhiskhan in https://github.com/duckdb/duckdb/pull/5432
Support enum_code() function by @lokax in https://github.com/duckdb/duckdb/pull/5408
Fix binder error and produce more informative error message. by @Tmonster in https://github.com/duckdb/duckdb/pull/5302
Parquet Reader: Re-use (de)compression and dictionary buffers and allocate powers of two by @Mytherin in https://github.com/duckdb/duckdb/pull/5445
Support RLE, DELTA_BYTE_ARRAY and DELTA_LENGTH_BYTE_ARRAY Parquet encodings by @Mytherin in https://github.com/duckdb/duckdb/pull/5457
print profiling output for deserialized logical query plans by @ila in https://github.com/duckdb/duckdb/pull/5448
Issue #5277: Sorted Aggregate Sorting by @hawkfish in https://github.com/duckdb/duckdb/pull/5456
Add internal flag to duckdb_functions, and correctly set internal flag for internal functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5462
Add experimental R String passthrough support by @hannes in https://github.com/duckdb/duckdb/pull/5479
Issue #5258: Quantile Negative Fractions by @hawkfish in https://github.com/duckdb/duckdb/pull/5463
Arrow stream ingestion for JDBC client by @hannes in https://github.com/duckdb/duckdb/pull/5449
PER_THREAD_OUTPUT flag for COPY by @hannes in https://github.com/duckdb/duckdb/pull/5412
Feature: skip broken tests for now by @Mytherin in https://github.com/duckdb/duckdb/pull/5532
Add Union All support to R extention by @Tmonster in https://github.com/duckdb/duckdb/pull/5484
[Python] Add from_parquet features by @papparapa in https://github.com/duckdb/duckdb/pull/5492
Add ExtractStatements to C API by @LindsayWray in https://github.com/duckdb/duckdb/pull/5524
Improve http retry by @samansmink in https://github.com/duckdb/duckdb/pull/5549
Issue #5277: Sorted Aggregate Window by @hawkfish in https://github.com/duckdb/duckdb/pull/5571
Issue #5422: QUANTILE_DESC Decimals by @hawkfish in https://github.com/duckdb/duckdb/pull/5572
Issue #5559: 2022g Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/5570
[Dev] Clean up of the python pkg folder structure by @Tishj in https://github.com/duckdb/duckdb/pull/5436
httpfs: check environment vars for AWS Credentials by @satotake in https://github.com/duckdb/duckdb/pull/5419
Misc union-type improvements by @Maxxen in https://github.com/duckdb/duckdb/pull/5617
Fix so Left inner join doesn't re-optimize nodes by @Tmonster in https://github.com/duckdb/duckdb/pull/5620
[Substrait] C API + from_substrait_json + bump on substrait version. by @pdet in https://github.com/duckdb/duckdb/pull/5613
Allow strings in ColumnDataCollection to be written to disk by @lnkuiper in https://github.com/duckdb/duckdb/pull/5543
[PythonDEV] Let clean.sh be run from anywhere, not just tools/pythonpkg by @Tishj in https://github.com/duckdb/duckdb/pull/5625
Reorganize Join order optimizer code by @Tmonster in https://github.com/duckdb/duckdb/pull/5621
[Catalog] Grab missing write_locks in a couple places by @Tishj in https://github.com/duckdb/duckdb/pull/5601
Parquet info to Substrait by @pdet in https://github.com/duckdb/duckdb/pull/5627
HTTP parquet optimizations by @samansmink in https://github.com/duckdb/duckdb/pull/5405
Adding delta compression to Bitpacking compression by @samansmink in https://github.com/duckdb/duckdb/pull/5491
[Python] Changed use of DuckDBPyConnection to shared_ptr by @Tishj in https://github.com/duckdb/duckdb/pull/5635
Merge feature branch into master by @Mytherin in https://github.com/duckdb/duckdb/pull/5645
[Python] Display progress bar by default in an interactive environment by @Tishj in https://github.com/duckdb/duckdb/pull/5596
Add support for RESET statement on configuration options by @Tishj in https://github.com/duckdb/duckdb/pull/5603
httpfs: Encode url path on request by @satotake in https://github.com/duckdb/duckdb/pull/5587
Fix broken CI because of RESET statement by @Tishj in https://github.com/duckdb/duckdb/pull/5671
Don't automatically set the bug label on issues by @Mytherin in https://github.com/duckdb/duckdb/pull/5680
Add support for CREATE VIEW IF NOT EXISTS by @Mytherin in https://github.com/duckdb/duckdb/pull/5682
Issue #5622: Validate Timezone Characters by @hawkfish in https://github.com/duckdb/duckdb/pull/5658
Issue 5630 fix. by @Tmonster in https://github.com/duckdb/duckdb/pull/5644
Adding COLUMN_TYPES option for read_csv_auto by @pdet in https://github.com/duckdb/duckdb/pull/5552
[Python] Get rid of DuckDBPyResult (merged functionality into DuckDBPyRelation) by @Tishj in https://github.com/duckdb/duckdb/pull/5597
feat: port nodejs tests to typescript by @Mause in https://github.com/duckdb/duckdb/pull/5632
Improve nodejs README by @Tishj in https://github.com/duckdb/duckdb/pull/5688
[Python] Add (partial) support for numpy.datetime64 objects by @Tishj in https://github.com/duckdb/duckdb/pull/5659
retry on all httplib errors by @samansmink in https://github.com/duckdb/duckdb/pull/5684
Return false if file doesn't exist by @Y-- in https://github.com/duckdb/duckdb/pull/5701
Adding context option to not run replacement scans and exporting namespace of json substrait function - R by @pdet in https://github.com/duckdb/duckdb/pull/5689
Issue #5609: Scope CTE Windows by @hawkfish in https://github.com/duckdb/duckdb/pull/5690
Attempt to fix random NodeJS CI failure by @Tishj in https://github.com/duckdb/duckdb/pull/5710
[Python] duckdb.execute() == duckdb.default_connection.execute() by @Tishj in https://github.com/duckdb/duckdb/pull/5650
NodeJS: switch to using package_build, and add support to BUILD_NODE to Makefile by @Mytherin in https://github.com/duckdb/duckdb/pull/5691
JDBC SNAPSHOT Jars by @hannes in https://github.com/duckdb/duckdb/pull/5687
Fix NodeJS 19 CI for Windows by @Tishj in https://github.com/duckdb/duckdb/pull/5719
Fix issue 5664 by @lokax in https://github.com/duckdb/duckdb/pull/5667
Issue #5712: CURRENT_TIMESTAMP and CURRENT_TIME by @hawkfish in https://github.com/duckdb/duckdb/pull/5713
[CSVReader] Catch a user error in supplying 'columns' option by @Tishj in https://github.com/duckdb/duckdb/pull/5721
Improve suggestions when LOAD of an extension fails by @Mytherin in https://github.com/duckdb/duckdb/pull/5722
doc(nodejs): amend arrow stream type docs by @Mause in https://github.com/duckdb/duckdb/pull/5731
Fix for TSV throwing during sniffing by @pdet in https://github.com/duckdb/duckdb/pull/5555
Statically link extensions on Linux with Clang by @jkub in https://github.com/duckdb/duckdb/pull/5653
[Python] Add support for named parameters by @Tishj in https://github.com/duckdb/duckdb/pull/5611
fix: nodejs source releases should be standalone by @Mause in https://github.com/duckdb/duckdb/pull/5734
build: don't install python from chocolatey by @Mause in https://github.com/duckdb/duckdb/pull/5740
fix: use non-string-splitting variable interpolation in binding.gyp.in by @Mause in https://github.com/duckdb/duckdb/pull/5745
Equalizing DBConfig constructors by @nicku33 in https://github.com/duckdb/duckdb/pull/5747
We should not treat replacement open paths as disk paths by @nicku33 in https://github.com/duckdb/duckdb/pull/5748
Allow table in-out functions to be used in correlated subqueries and as LATERAL queries by @Mytherin in https://github.com/duckdb/duckdb/pull/5485
Issue #5750: clangd std::move by @hawkfish in https://github.com/duckdb/duckdb/pull/5751
Always parallelize CSV reader when run over multiple files, and several other fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/5757
Add C++ ODBC tests framework by @Mytherin in https://github.com/duckdb/duckdb/pull/5755
Fix #5730: document older DuckDB versions internally, and state which DuckDB version a specific file came from by @Mytherin in https://github.com/duckdb/duckdb/pull/5758
Add support for non-order preserving parallel writing to the CSV and Parquet writers by @Mytherin in https://github.com/duckdb/duckdb/pull/5756
Don't compute SHA if we allow unsigned extensions by @Y-- in https://github.com/duckdb/duckdb/pull/5760
Maintain BlockHandle of meta blocks by BlockManager by @Hzc492 in https://github.com/duckdb/duckdb/pull/5699
Imdb benchmark validation and benchmark improvements by @Tmonster in https://github.com/duckdb/duckdb/pull/5693
Add support for attaching multiple DuckDB Databases by @Mytherin in https://github.com/duckdb/duckdb/pull/5764
Fix #5744: Correctly read "compressed" flag in Parquet V2 header by @Mytherin in https://github.com/duckdb/duckdb/pull/5767
Fix issue 5646 by @lokax in https://github.com/duckdb/duckdb/pull/5652
Remove icu from ignored directories when formatted by @papparapa in https://github.com/duckdb/duckdb/pull/5765
Correctly throw an error when attaching over HTTPFS by @Mytherin in https://github.com/duckdb/duckdb/pull/5773
JDBC add getLong method for timestamp columns by @Jens-H in https://github.com/duckdb/duckdb/pull/5783
Issue #5776: ISO Year Corrections by @hawkfish in https://github.com/duckdb/duckdb/pull/5796
Issue #5669: Advance NULL Pointers by @hawkfish in https://github.com/duckdb/duckdb/pull/5793
Issue #5791: TIMESTAMP/TIMESTAMPTZ Casting by @hawkfish in https://github.com/duckdb/duckdb/pull/5801
Issue #4121: INTERVAL List Search by @hawkfish in https://github.com/duckdb/duckdb/pull/5805
Fix incorrect file name in icu-timezone.hpp comment by @papparapa in https://github.com/duckdb/duckdb/pull/5784
Fully Qualified s3url request with globs by @LindsayWray in https://github.com/duckdb/duckdb/pull/5774
Map restructure by @LindsayWray in https://github.com/duckdb/duckdb/pull/5768
Issue #5806: Count Star Window by @hawkfish in https://github.com/duckdb/duckdb/pull/5810
S3 uploader fixes by @samansmink in https://github.com/duckdb/duckdb/pull/5769
fix for FSST segfault by @samansmink in https://github.com/duckdb/duckdb/pull/5824
Issue: #5717: SetValue TIMESTAMP Case by @hawkfish in https://github.com/duckdb/duckdb/pull/5804
Remove unnecessary code modifying the validity mask of the child vectors of a struct by @Mytherin in https://github.com/duckdb/duckdb/pull/5844
Add date part specifier synonyms by @papparapa in https://github.com/duckdb/duckdb/pull/5845
Add non ICU time_bucket function by @papparapa in https://github.com/duckdb/duckdb/pull/5835
Fix list_sort segmentation fault regression by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5823
Add support for specifying timestamp precision using standard modifiers by @Mytherin in https://github.com/duckdb/duckdb/pull/5848
Fix #5836: generate unique oid for attached databases as well by @Mytherin in https://github.com/duckdb/duckdb/pull/5851
Fix #5782 and #5794: in strict mode do not accept leading zeros when parsing numbers by @Mytherin in https://github.com/duckdb/duckdb/pull/5850
Fix #5781: add missing flatten call to list_aggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/5854
Fix #5788: improve error message when referencing an alias that contains a subquery (not supported yet) by @Mytherin in https://github.com/duckdb/duckdb/pull/5855
Fix #5853: fully qualify function names inside macros during the binding process by @Mytherin in https://github.com/duckdb/duckdb/pull/5856
CSV Auto Detection: disallow leading + when parsing numbers in strict mode by @Mytherin in https://github.com/duckdb/duckdb/pull/5857
Additional quote handling for string to list cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5859
Parser: add support for unicode space characters by @Mytherin in https://github.com/duckdb/duckdb/pull/5858
Adding std:: to every move by @hannes in https://github.com/duckdb/duckdb/pull/5873
MinGW Warning Fixes for R by @Mytherin in https://github.com/duckdb/duckdb/pull/5881
Issue #5887: ICU DateAdd Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/5888
NodeJS replacement scans by @whscullin in https://github.com/duckdb/duckdb/pull/5825
Further parallelize index creation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5812
Added the 'GetExpectedParameterTypes' method to the PreparedStatement… by @AlexR2D2 in https://github.com/duckdb/duckdb/pull/5792
Extend GenericExecutor by @Maxxen in https://github.com/duckdb/duckdb/pull/5863
Add signbit function for floating point values by @carlopi in https://github.com/duckdb/duckdb/pull/5862
Nested/Outer lambda parameters in rhs of inner lambda expressions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5860
Issue #5826: ICUDateFunc SubtractField Fix by @hawkfish in https://github.com/duckdb/duckdb/pull/5869
Reset schema setting when the default schema is dropped by @Tishj in https://github.com/duckdb/duckdb/pull/5874
Issue #5870: Nested ArgMinMax Results by @hawkfish in https://github.com/duckdb/duckdb/pull/5879
Fix #5779: Parquet writer - when writing lists write only the required subsection of a child entry to the Parquet file by @Mytherin in https://github.com/duckdb/duckdb/pull/5875
Change AddString to AddBlob in update_segment.cpp by @Maxxen in https://github.com/duckdb/duckdb/pull/5837
Support UNION_BY_NAME option in parquet_scan read_parquet by @douenergy in https://github.com/duckdb/duckdb/pull/5716
Minor fixes for cran by @hannes in https://github.com/duckdb/duckdb/pull/5904
[Julia] Use best practices for locking strategies by @Tishj in https://github.com/duckdb/duckdb/pull/5905
More GCC 13 issues by @hannes in https://github.com/duckdb/duckdb/pull/5907
read_csv_auto column_types improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/5911
feat: add parser support for CREATE DATABASE to allow extensions to provide the functionality by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/5898
Fix #5903: ICU addition overflow by @papparapa in https://github.com/duckdb/duckdb/pull/5908
Export set operations to relational API by @Tmonster in https://github.com/duckdb/duckdb/pull/5872
Join Order + EXPLAIN Improvements by @lnkuiper in https://github.com/duckdb/duckdb/pull/5891
fixed bug in generating grammar script by @ila in https://github.com/duckdb/duckdb/pull/5917
Fix implicit conversion by @carlopi in https://github.com/duckdb/duckdb/pull/5892
Issue 5660 - do not allow unnest with alias in groupby by @Tmonster in https://github.com/duckdb/duckdb/pull/5918
Parquet: correctly output TIMESTAMP_TZ type when isAdjustedToUTC is set by @Mytherin in https://github.com/duckdb/duckdb/pull/5916
Parquet reader: Fix an issue reading boolean values that cross column pages by @Mytherin in https://github.com/duckdb/duckdb/pull/5926
Allow hive columns to be present in parquet files by @samansmink in https://github.com/duckdb/duckdb/pull/5901
Fix #5936 - in the Pragma parser, avoid calling ToString() on column references because it might add quotes to keywords by @Mytherin in https://github.com/duckdb/duckdb/pull/5939
Add option to limit parallel compile by @ashish01 in https://github.com/duckdb/duckdb/pull/5935
Avoid writing .tmp file when redirecting stdout to a file by @Mytherin in https://github.com/duckdb/duckdb/pull/5930
[Macro] Remove limitation for types of expressions accepted as named arguments by @Tishj in https://github.com/duckdb/duckdb/pull/5876
Benchmarks by @carlopi in https://github.com/duckdb/duckdb/pull/5942
Fix non-deterministic test failure of parquet_scan by @papparapa in https://github.com/duckdb/duckdb/pull/5954
[Binder] Throw exception for aggregate function modifiers applied to non-aggregate functions by @lnkuiper in https://github.com/duckdb/duckdb/pull/5951
Add logical plan serialization for LOAD, DROP and ALTER by @ywelsch in https://github.com/duckdb/duckdb/pull/5934
Fix trainbenchmark non-determinism adding ordering by @carlopi in https://github.com/duckdb/duckdb/pull/5952
Add missing include to duckdb.hpp by @Tishj in https://github.com/duckdb/duckdb/pull/5953
httpfs: remove unneded include by @carlopi in https://github.com/duckdb/duckdb/pull/5945
[jemalloc] Detect LG_PAGE by @lnkuiper in https://github.com/duckdb/duckdb/pull/5949
String to map cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5838
Add time bucket function by @papparapa in https://github.com/duckdb/duckdb/pull/5665
[Python] Add UNION_BY_NAME to from_parquet arguments by @papparapa in https://github.com/duckdb/duckdb/pull/5913
Ci partial rework by @carlopi in https://github.com/duckdb/duckdb/pull/5943
Issue #3423: Positional Join Operator by @hawkfish in https://github.com/duckdb/duckdb/pull/5867
docs: add nodejs connection args to docs by @tshauck in https://github.com/duckdb/duckdb/pull/5780
[SQL Logic Test] Add support for environment variables by @Tishj in https://github.com/duckdb/duckdb/pull/5877
Ci: scope / remove env variables by @carlopi in https://github.com/duckdb/duckdb/pull/5967
Restore node-pre-gyp credentials by @carlopi in https://github.com/duckdb/duckdb/pull/5970
Python: Allow replacement scans on pyrelations, move to BoxRenderer and use pending query API for relations by @Mytherin in https://github.com/duckdb/duckdb/pull/5962
Issue #5023: Window Radix Partitions by @hawkfish in https://github.com/duckdb/duckdb/pull/5909
Update copyright year by @sjaenick in https://github.com/duckdb/duckdb/pull/5974
Fix #5968: ignore repetition type of root schema by @Mytherin in https://github.com/duckdb/duckdb/pull/5969
Fix #5971: addition and subtraction on infinity of TIMESTAMPTZ by @papparapa in https://github.com/duckdb/duckdb/pull/5978
Regression ci by @carlopi in https://github.com/duckdb/duckdb/pull/5961
Add support for UPSERT (INSERT .. ON CONFLICT DO ..) syntax by @Tishj in https://github.com/duckdb/duckdb/pull/5866
Removing Arrow ABI Testing by @pdet in https://github.com/duckdb/duckdb/pull/5980
Remove LogicalTypeId::JSON and implement read_json_objects by @lnkuiper in https://github.com/duckdb/duckdb/pull/5544
Make sqlsmith extension compile by @PedroTadim in https://github.com/duckdb/duckdb/pull/5963
Issue #5023: Radix Partition Cardinality by @hawkfish in https://github.com/duckdb/duckdb/pull/5989
Added UUID case to GetTypeToPython by @maclockard in https://github.com/duckdb/duckdb/pull/5885
Export right left and full joins by @Tmonster in https://github.com/duckdb/duckdb/pull/5822
Decimal separator option for CSV reader by @eeroel in https://github.com/duckdb/duckdb/pull/5958
feat(python): fsspec filesystems by @Mause in https://github.com/duckdb/duckdb/pull/5829
Fix amalgamation build: returning (std::)move will otherwise be flagg… by @carlopi in https://github.com/duckdb/duckdb/pull/5991
Fix issue 5675 by @samansmink in https://github.com/duckdb/duckdb/pull/6001
Only copy relevant list children in column data collection by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5982
Many Parallel CSV Reader Fixes by @pdet in https://github.com/duckdb/duckdb/pull/5950
[python] Use duck typing for arrow dataset by @changhiskhan in https://github.com/duckdb/duckdb/pull/5998
[Import/Export] Exported databases can now be safely moved by @Tishj in https://github.com/duckdb/duckdb/pull/5965
Add count_if as a macro function by @ashish01 in https://github.com/duckdb/duckdb/pull/6007
Rcpp17 by @carlopi in https://github.com/duckdb/duckdb/pull/6022
[Dev] Fix #6020: Fix failure of CI with pyarrow by @papparapa in https://github.com/duckdb/duckdb/pull/6023
Format script: enforce same varargs formatting by @Mytherin in https://github.com/duckdb/duckdb/pull/6014
fixed fsst issue with size calculation check by @samansmink in https://github.com/duckdb/duckdb/pull/6016
Fix Node.js Windows CI jobs by @carlopi in https://github.com/duckdb/duckdb/pull/6041
fix 5923 - convert float16 column in pandas to float32 column by @wordhardqi in https://github.com/duckdb/duckdb/pull/6028
Add support for JDBC Metadata for the nested typess List, Struct, Map by @jonathanswenson in https://github.com/duckdb/duckdb/pull/6029
move block checksum from FileBuffer to BlockManager by @jkub in https://github.com/duckdb/duckdb/pull/6033
Optimize SELECT UNNEST in lateral joins by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6035
Fix Python CI: numpy added before-build by @carlopi in https://github.com/duckdb/duckdb/pull/6056
Track exact ART size and many ART improvements by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5893
Use back-up to download unixODBC by @carlopi in https://github.com/duckdb/duckdb/pull/6063
Copy into partition by by @samansmink in https://github.com/duckdb/duckdb/pull/5964
Add support for a pluggable storage and catalog back-end, and add support for a SQLite back-end storage by @Mytherin in https://github.com/duckdb/duckdb/pull/6066
Various fixes by @carlopi in https://github.com/duckdb/duckdb/pull/6036
out of tree extension improvements by @samansmink in https://github.com/duckdb/duckdb/pull/6049
Fix checks on R-devel by @krlmlr in https://github.com/duckdb/duckdb/pull/6025
Update editor config by @Tmonster in https://github.com/duckdb/duckdb/pull/6065
Implement read_json and improve JSON parse errors by @lnkuiper in https://github.com/duckdb/duckdb/pull/5992
[Python] Add read_csv method by @Tishj in https://github.com/duckdb/duckdb/pull/6015
Add bar function by @papparapa in https://github.com/duckdb/duckdb/pull/5993
Remove console.log from UDF catch by @chrisbrain in https://github.com/duckdb/duckdb/pull/6082
Fix performance regression in read_csv_auto auto detection by @Mytherin in https://github.com/duckdb/duckdb/pull/6078
Allowing lambdas in table functions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6039
Add relational tests back by @Tmonster in https://github.com/duckdb/duckdb/pull/6038
Force-enabling DEBUG_MOVE for debug builds by @hannes in https://github.com/duckdb/duckdb/pull/6099
[Python] Make pyarrow.dataset optional by @Tishj in https://github.com/duckdb/duckdb/pull/6106
Fuzzer issue #5984 no 25 by @LindsayWray in https://github.com/duckdb/duckdb/pull/6107
[ParquetWriter] Prevent creating broken parquet files by @Tishj in https://github.com/duckdb/duckdb/pull/6104
[Fuzzer] Fix issue related to dropping a generated column by @Tishj in https://github.com/duckdb/duckdb/pull/6113
Implement md alias for motherduck and add motherduck to list of known extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/6111
Map extract bug by @LindsayWray in https://github.com/duckdb/duckdb/pull/6109
[Dev] Fix some unqualified move's that snuck in by @Tishj in https://github.com/duckdb/duckdb/pull/6117