Duckdb

Latest version: v1.2.1

Safety actively analyzes 723650 Python packages for vulnerabilities to keep your Python projects secure.

Page 4 of 8

0.7.0

Not secure

This preview release of DuckDB is named "Labradorius" after the [Labrador duck (Camptorhynchus labradorius)](https://en.wikipedia.org/wiki/Labrador_duck) 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](https://duckdb.org/2023/02/13/announcing-duckdb-070.html) 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](https://duckdb.org/docs/sql/statements/export) 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
* Ccaching2 by carlopi in https://github.com/duckdb/duckdb/pull/6101
* Making CSV Parallel tests more robust by pdet in https://github.com/duckdb/duckdb/pull/6122
* [Julia] Fix execute deadlock by Tishj in https://github.com/duckdb/duckdb/pull/6123
* [Python] Check overflow in DATE -> datetime conversion by Tishj in https://github.com/duckdb/duckdb/pull/6125
* Python box rendering: limit rendering to 10K rows by Mytherin in https://github.com/duckdb/duckdb/pull/6121
* Correctly setting the validity of constant struct vector references by taniabogatsch in https://github.com/duckdb/duckdb/pull/6118
* Fix 6092 - retain casing for keywords by Mytherin in https://github.com/duckdb/duckdb/pull/6112
* Fuzzer issue 9 and 40 from 5984 by samansmink in https://github.com/duckdb/duckdb/pull/6126
* fix(python): fix gil error in fsspec integration by Mause in https://github.com/duckdb/duckdb/pull/6140
* Fuzzer issue 5984 no.43. Substring generating an invalid string by LindsayWray in https://github.com/duckdb/duckdb/pull/6139
* Remove sporadically failing Windows CI CSV reader test by Mytherin in https://github.com/duckdb/duckdb/pull/6147
* issue 5984 42 disable nan as random seed by Tmonster in https://github.com/duckdb/duckdb/pull/6128
* [Python] Add `read_parquet`, `to_parquet` and `to_csv` by Tishj in https://github.com/duckdb/duckdb/pull/6129
* Make ATTACH work over HTTP(S), and fix ATTACH for databases with custom types by Mytherin in https://github.com/duckdb/duckdb/pull/6141
* Replace replacement_opens with storage_init by Mytherin in https://github.com/duckdb/duckdb/pull/6132
* Fix to Fuzzer 5 item 30, plus various very marginal fixes by carlopi in https://github.com/duckdb/duckdb/pull/6137
* Improve read_json transform errors and fix some read_json related bugs by lnkuiper in https://github.com/duckdb/duckdb/pull/6145
* [Fuzzer] ArgMax Segfault by Tishj in https://github.com/duckdb/duckdb/pull/6144
* Fix 6136: fix issue with SINGLE JOIN where NULL values of a struct were not correctly set by Mytherin in https://github.com/duckdb/duckdb/pull/6148
* Fix fuzzer issue 35: correctly check overflows on casts from float/double to unsigned integers by Mytherin in https://github.com/duckdb/duckdb/pull/6151
* [Fuzzer] Unset 'swizzled' flag in SortedData by lnkuiper in https://github.com/duckdb/duckdb/pull/6143
* Introduces Bit type by LindsayWray in https://github.com/duckdb/duckdb/pull/5990
* Fix issue related to NodeJS UDF not returning constant vectors by Tishj in https://github.com/duckdb/duckdb/pull/5697
* 6055 column alias in where clause results in binder error by Tmonster in https://github.com/duckdb/duckdb/pull/6162
* Skip concurrent index/grouping sets tests for now by Mytherin in https://github.com/duckdb/duckdb/pull/6164
* Skip attach over HTTPFS test by Mytherin in https://github.com/duckdb/duckdb/pull/6167
* 5982 (8, 12, 15) binder error when group by all & having clause both refer to column from correlated subquery by Tmonster in https://github.com/duckdb/duckdb/pull/6163
* More minor fixes to warnings by carlopi in https://github.com/duckdb/duckdb/pull/6138
* Fix fuzzer issue 14: correctly switch between deleting from transaction local storage and main table based on ids by Mytherin in https://github.com/duckdb/duckdb/pull/6166
* fix(nodejs): error as object instead of string by Mause in https://github.com/duckdb/duckdb/pull/6174
* Fixing Parallel CSV Reader over multiple files by pdet in https://github.com/duckdb/duckdb/pull/6131
* Issue 6157 duckdbj database meta data supports like escape clause by rpbouman in https://github.com/duckdb/duckdb/pull/6178
* Fuzzer issue: Grapheme function overflow by LindsayWray in https://github.com/duckdb/duckdb/pull/6171
* Fix fuzzer issue 31 (again) by lnkuiper in https://github.com/duckdb/duckdb/pull/6172
* Wiring storage_info into attach and create_transaction_manager calls by rjatwal in https://github.com/duckdb/duckdb/pull/6161
* Try to auto-cast list_filter input and throw exception when failing by taniabogatsch in https://github.com/duckdb/duckdb/pull/6119
* Pass unrecognized configuration options to storage by Mytherin in https://github.com/duckdb/duckdb/pull/6177
* Art fuzzer issues by taniabogatsch in https://github.com/duckdb/duckdb/pull/6168
* Fix Python deadlock - execute all PyRelations through the shared execute loop, and throw exception if Pandas Scan is called while GIL is held by Mytherin in https://github.com/duckdb/duckdb/pull/6186
* No lambdas in CHECK constraint and generated columns by taniabogatsch in https://github.com/duckdb/duckdb/pull/6190
* fixes 6159 by rpbouman in https://github.com/duckdb/duckdb/pull/6183
* Fix lambda warning on building by taniabogatsch in https://github.com/duckdb/duckdb/pull/6195
* Python: Make duckdb.sql return results for non-select queries in the form of a ValueRelation by Mytherin in https://github.com/duckdb/duckdb/pull/6196
* Fix 6204: fix buffer management in ColumnDataRowCollection construction used in BoxRenderer by Mytherin in https://github.com/duckdb/duckdb/pull/6205
* Python: make imports lazy, add .sql as an alias for .query, and add integration functions with polars by Mytherin in https://github.com/duckdb/duckdb/pull/6181
* bugfix(python): fsspec file modes by Mause in https://github.com/duckdb/duckdb/pull/6207
* Fix 6182: add DESCRIBE to the set of table name keywords by Mytherin in https://github.com/duckdb/duckdb/pull/6206
* Fix 5983: avoid serializing type as part of numeric statistics (de)serialization by Mytherin in https://github.com/duckdb/duckdb/pull/6197
* Fuzzer 16: Between type mismatch by LindsayWray in https://github.com/duckdb/duckdb/pull/6194
* [Fuzzer] Fixes fuzzer issue 27 by Tishj in https://github.com/duckdb/duckdb/pull/6193
* Fuzzer fixes 2, 3 and 5 of 5984 by samansmink in https://github.com/duckdb/duckdb/pull/6187
* DuckDBJ: sanitize values of tableTypes argument in DatabaseMetadata.getTables() by rpbouman in https://github.com/duckdb/duckdb/pull/6180
* Add more tests for fetch* functions, and add support for Pandas-style .describe() by Mytherin in https://github.com/duckdb/duckdb/pull/6212
* More descriptive error message if we are using a table function as a scalar function by Mytherin in https://github.com/duckdb/duckdb/pull/6201
* Make NumPy dependency optional by Mytherin in https://github.com/duckdb/duckdb/pull/6215
* Implement FORMAT JSON for COPY/IMPORT/EXPORT by lnkuiper in https://github.com/duckdb/duckdb/pull/6170
* Fix ODBC CI by Mytherin in https://github.com/duckdb/duckdb/pull/6216
* [Python] Add `read_json` method by Tishj in https://github.com/duckdb/duckdb/pull/6165
* [C-API] Add struct list_entry, ListVector::reserve and ListVector::set_size by eddyxu in https://github.com/duckdb/duckdb/pull/6155
* Disable the Node build cache in the CI for now by Mytherin in https://github.com/duckdb/duckdb/pull/6220
* [Java] BigDecimal scale > precision bug fix by Tishj in https://github.com/duckdb/duckdb/pull/6110
* Fix 6044: in Value::DECIMAL, switch on the width instead of assuming the width is correctly set with the corresponding integer type by Mytherin in https://github.com/duckdb/duckdb/pull/6219
* Fix 6184: skip unused column removal right after a filter with entries in the projection map by Mytherin in https://github.com/duckdb/duckdb/pull/6221
* Bump postgres scanner by hannes in https://github.com/duckdb/duckdb/pull/6226
* Add support for "show" to py relation objects by Mytherin in https://github.com/duckdb/duckdb/pull/6224

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.6.1...v0.7.0

0.6.1

Not secure

This is a bug fix release for various issues discovered after we released 0.6.0. There are no new features, just bug fixes.
What's Changed
* Correctly accept BUILD_JEMALLOC_EXTENSION on Linux by Mytherin in https://github.com/duckdb/duckdb/pull/5343
* [julia] fix docstring of `load!` and relax type restriction by jfb-h in https://github.com/duckdb/duckdb/pull/5354
* Bump DuckDB_jll compat to v0.6 by jeremiahpslewis in https://github.com/duckdb/duckdb/pull/5356
* Issue 5342: DATE_PART Struct Indexing by hawkfish in https://github.com/duckdb/duckdb/pull/5382
* Add reference to cleanup function for duckdb_result_get_chunk by ak-coram in https://github.com/duckdb/duckdb/pull/5389
* Fix 5390: in filter pull-up optimizer avoid adding columns to one side of a set operation by Mytherin in https://github.com/duckdb/duckdb/pull/5400
* Fix 5371: correctly use instance cache in JDBC and ODBC connector by Mytherin in https://github.com/duckdb/duckdb/pull/5398
* Add support for reading JSON type columns from Parquet files by Mytherin in https://github.com/duckdb/duckdb/pull/5401
* [Dev] Fix compilation issues related to MSVC and Windows.h by Tishj in https://github.com/duckdb/duckdb/pull/5386
* fix: upgrade npm's internal node-gyp by Mause in https://github.com/duckdb/duckdb/pull/5402
* [Appender] Appender can now properly append to DECIMAL columns by Tishj in https://github.com/duckdb/duckdb/pull/5364
* Fix bug causing loss of order preservation in insert by lnkuiper in https://github.com/duckdb/duckdb/pull/5427
* Allocator: throw std::bad_alloc if a malloc allocation fails by Mytherin in https://github.com/duckdb/duckdb/pull/5439
* Fix the use of COLUMNS(...) in ORDER BY clause by lokax in https://github.com/duckdb/duckdb/pull/5444
* Adding lazy relation -> data.frame conversion for R client by hannes in https://github.com/duckdb/duckdb/pull/5181
* Fix 5450, don't crash on integer dates in R by hannes in https://github.com/duckdb/duckdb/pull/5451
* Issue 5366: QUANTILE_DISC Intervals by hawkfish in https://github.com/duckdb/duckdb/pull/5442
* Remove the f off by hatvik in https://github.com/duckdb/duckdb/pull/5475
* Fix many fuzzer issues by Mytherin in https://github.com/duckdb/duckdb/pull/5482
* Allow column references in constant table functions by Mytherin in https://github.com/duckdb/duckdb/pull/5483
* Node register arrow ipc buffer fix by samansmink in https://github.com/duckdb/duckdb/pull/5433
* Add initializer for queue_insertions by hannes in https://github.com/duckdb/duckdb/pull/5504
* Disabling per-value materialization of r altrep strings in results by hannes in https://github.com/duckdb/duckdb/pull/5454
* Correctly set delim_offset in flatten dependent join and disable linux arrow test by Mytherin in https://github.com/duckdb/duckdb/pull/5509
* update arrow extension by samansmink in https://github.com/duckdb/duckdb/pull/5506
* [Python] Correct stub for DuckDBPyConnection::df by Tishj in https://github.com/duckdb/duckdb/pull/5385
* Add deserialization to custom operators by rjatwal in https://github.com/duckdb/duckdb/pull/5496
* [Python] No longer truncate ByteArray values by nullbytes by Tishj in https://github.com/duckdb/duckdb/pull/5517
* Add in the pg_database, pg_proc, and pg_settings views to pg_catalog by jwills in https://github.com/duckdb/duckdb/pull/5526
* Fix various BufferManager issues by lnkuiper in https://github.com/duckdb/duckdb/pull/5476
* Add feature request link by Mause in https://github.com/duckdb/duckdb/pull/5324
* [Python] Fix `relation.query()` not accepting non-select statements by Tishj in https://github.com/duckdb/duckdb/pull/5531
* fix issue 5488 by samansmink in https://github.com/duckdb/duckdb/pull/5519
* [Python] Adding back Query interrupt support (through Ctrl+C) by Tishj in https://github.com/duckdb/duckdb/pull/5487
* Adding dummy user/username/password settings by hannes in https://github.com/duckdb/duckdb/pull/5530
* Add memory leak tests, and fix memory leaks related to repeated table creation/destruction by Mytherin in https://github.com/duckdb/duckdb/pull/5537
* DuckBox renderer fixes by Mytherin in https://github.com/duckdb/duckdb/pull/5539
* Fix 5533: correctly use timestamp logical type unit in Parquet stats reader by Mytherin in https://github.com/duckdb/duckdb/pull/5540
* Disable the extended code coverage tests for now by Mytherin in https://github.com/duckdb/duckdb/pull/5542
* NLJoin is not always terrible by pdet in https://github.com/duckdb/duckdb/pull/5538
* naming mismatch for linux arm extension upload by samansmink in https://github.com/duckdb/duckdb/pull/5556
* Deprecate 'sprintf' usage using MacOSX SDK 13 by darrenfu in https://github.com/duckdb/duckdb/pull/5545
* Fix 5546: allow foldable scalar expressions in standard table functions by Mytherin in https://github.com/duckdb/duckdb/pull/5550
* Upgrade sqlite scanner hash by Mytherin in https://github.com/duckdb/duckdb/pull/5551
* [Python] Fixed bug where creating a cursor from a closed connection caused a segfault by Tishj in https://github.com/duckdb/duckdb/pull/5565
* Fsst pull bugfix from upstream by samansmink in https://github.com/duckdb/duckdb/pull/5567
* Parquet: Not setting num_children for primitive types as per spec by hannes in https://github.com/duckdb/duckdb/pull/5579
* [Python] Fix accidental dependency on `pandas` by Tishj in https://github.com/duckdb/duckdb/pull/5581
* Throw error when sorting or using indexes on big endian architecture by Mytherin in https://github.com/duckdb/duckdb/pull/5588
* fix: separate artifacts for 32bit and 64bit builds by Mause in https://github.com/duckdb/duckdb/pull/5592
* Bug fix for 5523 by taniabogatsch in https://github.com/duckdb/duckdb/pull/5554
* Disabling truncating of temporary buffer manager files on Windows by hannes in https://github.com/duckdb/duckdb/pull/5600
* Removed FSST unused global that triggered compiler warning by hannes in https://github.com/duckdb/duckdb/pull/5602
* Copy JDBC Properties to not lose readonly setting by hannes in https://github.com/duckdb/duckdb/pull/5594

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.6.0...v0.6.1

0.6.0

Not secure

This preview release of DuckDB is named "Oxyura" after the [White-headed duck (Oxyura leucocephala)](https://en.wikipedia.org/wiki/White-headed_duck) 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](https://duckdb.org/2022/11/14/announcing-duckdb-060.html) 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](https://duckdb.org/docs/sql/statements/export) 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 DatabaseMetadatagetFunctions() 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
* 6. Like empty list assertion error by LindsayWray in https://github.com/duckdb/duckdb/pull/5261
* fix: fix python stub test by Mause in https://github.com/duckdb/duckdb/pull/5269
* Issue 5254: Validate Collation Expressions by hawkfish in https://github.com/duckdb/duckdb/pull/5270
* Cast overflow varchar to decimal by LindsayWray in https://github.com/duckdb/duckdb/pull/5262
* Issue 5259: ChunkCollection Sort Values by hawkfish in https://github.com/duckdb/duckdb/pull/5280
* Parallel CSV Reader by pdet in https://github.com/duckdb/duckdb/pull/5194
* Add Java constant for default schema name by michaeljohnalbers in https://github.com/duckdb/duckdb/pull/5271
* Fix/4978 substring overflow by Maxxen in https://github.com/duckdb/duckdb/pull/5273
* token url encoding bug in S3 glob by samansmink in https://github.com/duckdb/duckdb/pull/5248
* fix: don't build M1 NodeJS binaries on node versions that don't support M1 by Mause in https://github.com/duckdb/duckdb/pull/5284
* Several CI fixes by Mytherin in https://github.com/duckdb/duckdb/pull/5281
* Fix several fuzzer issues, move client context into ExpressionExecutor, and ColumnList index rework by Mytherin in https://github.com/duckdb/duckdb/pull/5276
* feat: prebuild for NodeJS 19 by Mause in https://github.com/duckdb/duckdb/pull/5295
* Calendar overflow Fixes by hawkfish in https://github.com/duckdb/duckdb/pull/5287
* Add correlated columns to LogicalDistinct::distinct_targets when flattening dependent joins by lnkuiper in https://github.com/duckdb/duckdb/pull/5286
* Fuzzer fixes - 4978 (16) Binder assertion error by Tmonster in https://github.com/duckdb/duckdb/pull/5285
* [Fuzzer] Fix triggered assertion in LogicalOperator::Verify by Tishj in https://github.com/duckdb/duckdb/pull/5283
* Disable url decoding of http header values by samansmink in https://github.com/duckdb/duckdb/pull/5275
* fix: pg constraint foreign key by Mause in https://github.com/duckdb/duckdb/pull/5264
* Improve memory management of ART indexes by Mytherin in https://github.com/duckdb/duckdb/pull/5292
* Several parallel CSV reader fixes by Mytherin in https://github.com/duckdb/duckdb/pull/5291
* [Python] support for pandas experimental NA type by Tishj in https://github.com/duckdb/duckdb/pull/5246
* Add internal verification to unpinning buffer blocks by lnkuiper in https://github.com/duckdb/duckdb/pull/5263
* [Python] Fix support for UInt64 and similar by Tishj in https://github.com/duckdb/duckdb/pull/5299
* Add support for quoted schema/column in DESCRIBE statement by Tishj in https://github.com/duckdb/duckdb/pull/5230
* Increase SQLite scanner version by Mytherin in https://github.com/duckdb/duckdb/pull/5309
* node / TypesScript bindings: add missing accessMode argument to Database constructor. by antonycourtney in https://github.com/duckdb/duckdb/pull/5307
* Initial version of extension to allow creating operators outside of duckdb core lib by rjatwal in https://github.com/duckdb/duckdb/pull/5144
* Improve progress bar & box rendering by Mytherin in https://github.com/duckdb/duckdb/pull/5304
* Parallel csv auto fixes by pdet in https://github.com/duckdb/duckdb/pull/5303
* Current fix for Issue 5266 Returning error with rowid by Tmonster in https://github.com/duckdb/duckdb/pull/5267
* [Fuzzer] Add support for use of generated columns in GROUP BY expression by Tishj in https://github.com/duckdb/duckdb/pull/5249
* [Fuzzer] Generated columns now work properly with query-level aliases by Tishj in https://github.com/duckdb/duckdb/pull/5308
* fix: use oldest supported numpy to build for a given python version by Mause in https://github.com/duckdb/duckdb/pull/5319
* [UB sanitizer] Prevent doing arithmetic on NaN in 'logical_limit_percent.cpp' by Tishj in https://github.com/duckdb/duckdb/pull/5322
* Fix OSX Builds on Master - Revert 5319 by Mytherin in https://github.com/duckdb/duckdb/pull/5329
* Bump Postgres Scanner by hannes in https://github.com/duckdb/duckdb/pull/5325
* disable node client arrow ipc replacement scans by samansmink in https://github.com/duckdb/duckdb/pull/5332
* Shared ColumnDataAllocator: hold lock for just a bit longer by lnkuiper in https://github.com/duckdb/duckdb/pull/5333

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.5.1...v0.6.0

0.5.1

Not secure

This is a bug fix release for various issues discovered after we released 0.5.0. There are no new features, just bug fixes. The following PRs were included in this release:

* [Fuzzer] Issue 4152 - Lag window function issue by lokax in https://github.com/duckdb/duckdb/pull/4603
* Fix zonemap check for VARCHAR by lokax in https://github.com/duckdb/duckdb/pull/4613
* Remove the DLLEXPORT from deleted API methods by emmenlau in https://github.com/duckdb/duckdb/pull/4611
* Fix update statement on generated column by lokax in https://github.com/duckdb/duckdb/pull/4616
* [Fuzzer] Issue 4152 - Limit 0% on ANY subquery by lokax in https://github.com/duckdb/duckdb/pull/4544
* [Fuzzer] Issue 4610 - Vacuum table with generated column by lokax in https://github.com/duckdb/duckdb/pull/4622
* [Fuzzer] Decimal scale+width overflows too quickly by Tishj in https://github.com/duckdb/duckdb/pull/4627
* [Fuzzer] issue 4566 by Tishj in https://github.com/duckdb/duckdb/pull/4592
* Issue 4635: DATE_DIFF Week Boundaries by hawkfish in https://github.com/duckdb/duckdb/pull/4648
* Fix issue 4630 by lnkuiper in https://github.com/duckdb/duckdb/pull/4642
* [Python] Fix unwanted conversion from NaN -> NULL in param list by Tishj in https://github.com/duckdb/duckdb/pull/4624
* Fix home directory setter by attilahorvath in https://github.com/duckdb/duckdb/pull/4617
* fix(jdbc): correct mapping for TIMESTAMP_WITH_TIME_ZONE by Mause in https://github.com/duckdb/duckdb/pull/4654
* Fix bug changing input order on array_sort column by taniabogatsch in https://github.com/duckdb/duckdb/pull/4643
* Fix issue 4625 by lnkuiper in https://github.com/duckdb/duckdb/pull/4653
* [Extensions] Suggesting which extension to Load/Install by pdet in https://github.com/duckdb/duckdb/pull/4634
* Fixes issue 4123 by Tishj in https://github.com/duckdb/duckdb/pull/4523
* Updating jdbc deploy script by hannes in https://github.com/duckdb/duckdb/pull/4663
* Consistent struct definitions by hannes in https://github.com/duckdb/duckdb/pull/4667
* Fix 4666 by taofengliu in https://github.com/duckdb/duckdb/pull/4670
* Fix for 3417 by PedroTadim in https://github.com/duckdb/duckdb/pull/4664
* feat: improve python replacement scan error by Mause in https://github.com/duckdb/duckdb/pull/4672
* [C-API] Data chunk invalid left-shift by Tishj in https://github.com/duckdb/duckdb/pull/4660
* fix: correct mislabelling of amd64 libs in jars by Mause in https://github.com/duckdb/duckdb/pull/4691
* Fix 4647 by taofengliu in https://github.com/duckdb/duckdb/pull/4698
* Throw error if attempting to delete from table without physical columns by Tishj in https://github.com/duckdb/duckdb/pull/4693
* Fix 4475: allow ignore_errors in read_csv and read_csv_auto by Mytherin in https://github.com/duckdb/duckdb/pull/4713
* Fix 4442: correctly handle TIMESTAMP logicalType in Parquet files by Mytherin in https://github.com/duckdb/duckdb/pull/4714
* Fix 4699: when no file is found globbing, fallback to using the literal string name as a path by Mytherin in https://github.com/duckdb/duckdb/pull/4716
* Fuzzer fixes batch 1 by Mytherin in https://github.com/duckdb/duckdb/pull/4707
* Fix 4677. Correctly set_not_null when table contains generated column by zippond in https://github.com/duckdb/duckdb/pull/4706
* Fix 4703 by taofengliu in https://github.com/duckdb/duckdb/pull/4715
* Fixing Extension naming CI Checker by pdet in https://github.com/duckdb/duckdb/pull/4717
* [Python(pandas)] Scan multiple chunks worth of values from a 'object' dtype DataFrame by Tishj in https://github.com/duckdb/duckdb/pull/4692
* Fix 4694: Keep shared pointer to pipelines around in additionally scheduled events by Mytherin in https://github.com/duckdb/duckdb/pull/4724
* Fuzzer Batch Fixes 2 by Mytherin in https://github.com/duckdb/duckdb/pull/4722
* Fix 4702. Correctly use index when generated column is involved by zippond in https://github.com/duckdb/duckdb/pull/4727
* Fix for 4583 by PedroTadim in https://github.com/duckdb/duckdb/pull/4728
* Fuzzer fix batch 3 by Mytherin in https://github.com/duckdb/duckdb/pull/4726
* Fix 4562: generate table index for dummy scan generated from VALUES clause by Mytherin in https://github.com/duckdb/duckdb/pull/4731
* [Arrow] Guarantee threads don't call get_next after stream is done. by pdet in https://github.com/duckdb/duckdb/pull/4712
* Correctly catch and report exceptions thrown during a pipeline's scheduling by Mytherin in https://github.com/duckdb/duckdb/pull/4733
* Fix for issue 4708 by PedroTadim in https://github.com/duckdb/duckdb/pull/4711
* Fix 4568: correctly handle casts in deliminator by Mytherin in https://github.com/duckdb/duckdb/pull/4734
* No longer disable vptr sanitizer on M1 macs by Mytherin in https://github.com/duckdb/duckdb/pull/4735
* Use version tag as dir for extensions for releases by samansmink in https://github.com/duckdb/duckdb/pull/4729
* Correctly call ::Skip function of child of structs by Mytherin in https://github.com/duckdb/duckdb/pull/4736
* [Map] Map extract now properly uses the selection vectors of the `map` and `key` vectors by Tishj in https://github.com/duckdb/duckdb/pull/4725
* Fix 4356 by taofengliu in https://github.com/duckdb/duckdb/pull/4740
* Fuzzer Batch 4 by Mytherin in https://github.com/duckdb/duckdb/pull/4737
* feat: bump Julia package version by Mause in https://github.com/duckdb/duckdb/pull/4742
* Julia API: Add load! to add a DataFrame as a table by jfb-h in https://github.com/duckdb/duckdb/pull/4743
* aarch64 extensions by samansmink in https://github.com/duckdb/duckdb/pull/4745
* Faster hive part filters by samansmink in https://github.com/duckdb/duckdb/pull/4746
* [Python] DECIMAL with value 0.00... issue fix by Tishj in https://github.com/duckdb/duckdb/pull/4690
* enable out-of-tree extensions for aarch64 by samansmink in https://github.com/duckdb/duckdb/pull/4751

**Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.5.0...v0.5.1

0.5.0

Not secure

This preview release of DuckDB is named "Pulchellus" after the [Green pygmy goose (Nettapus pulchellus)](https://en.wikipedia.org/wiki/Green_pygmy_goose) which is native to Australia where [VLDB 2022](https://vldb.org/2022/) is starting today. Despite being called a "goose" it is actually a duck.

Binary builds are listed at the bottom of this post. Feedback is very welcome.

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.

Below a list of changes in this release

Major Changes & Features

- 4189: Implement Out-of-Core Hash Join and Re-Work Query Verification
- 4022: Art Index Storage
- 4274: Join Order Optimizer improvements
- 4420: Logical Plan Serialization
- 4137, 4347, 4293, 4190, 4178, 4177, 3954 & 4159: Scalability and performance improvements for Window operator
- 4004: Add support for extensions to the parser, and add an example of this to the loadable extension demo
- 4089: Signed Extensions
- 4097 & 4211: Filename column + Hive partitioning support for Parquet Reader
- 4501, 4511: Aarch64 Linux builds of CLI, shared library, JDBC & ODBC

Minor Changes & Bug Fixes
- 4594: [Map] Fix map_extract from multiple rows
- 4585: Fix for r test instability, 4549
- 4560: Support all basic integer types in node API
- 4558: [CPP-API] Comment no longer causes crash
- 4552: [Fuzzer] Issue 4152 - Remove ToString roundtrip in query verification
- 4543: Fixing silent assertions
- 4542: Check if database is still alive when trying to connect for nodejs
- 4541: fix for issue 4533
- 4539: Paralelization non-dependent on Arrow rows
- 4524: Explicitly deleting default connection on js side
- 4522: Correct architecture name for Linux aarch64
- 4521: Adding correct substrait release tag to out-of-tree extension deployment
- 4520: Added test cases for several fixed JDBC issues
- 4516: Fix 4455, dont set default schema in transform
- 4513: Issue 4502
- 4510: [Casting] Varchar -> Decimal cast fix
- 4507: [CSV] Fixed bug related to invalidated iterators
- 4505: extension trigger event
- 4504: fix: short-circuit hash and version discovery
- 4496: [Fuzzer] Issue 4152 - Force no cross-product issue
- 4495: Build ODBC driver binary for OSX
- 4494: [Fuzzer] Issue 4152 - Analyze inexisting column
- 4493: Declare all variables for nodejs.
- 4491: Issue 4419: Range Join Swizzling
- 4488: Making the parquet extension loadable
- 4484: fix: ignore status message from output of mypy stubs check
- 4483: [Development bug] unittest result_helper.cpp triggers assertion
- 4480: Remove REST server
- 4479: Remove assertion
- 4477: Removing Substrait From DuckDB Repo
- 4474: WIP 4152
- 4472: [Python] Removed mutable default parameters
- 4470: Fix hidden merge conflict with fetchmany
- 4465: [Python] `fetchmany` implemented
- 4458: Issue 4454: VARCHAR/DATE Reversibility
- 4448: Issue 3954: Pinned Heap Blocks
- 4440: Added support for HUGEINT input type to BIT_COUNT scalar function
- 4434: Python: Add PyRelation.fetchnumpy()
- 4429: Allow indicating a format version that should be used to write/read from (De)serializer and use it for plans
- 4427: Python: Improve docstrings for DuckDBPyRelation and DuckDBPyResult
- 4418: Fix typo
- 4416: Fix several update issues
- 4413: Correctly schedule mix of union/child pipelines (again)
- 4409: Increase timeout for coverage checks
- 4405: Hybrid ART Leaf Part I
- 4404: Add support for TS_MS, TS_NS, and TS_S
- 4400: Issue 4388: DATE_TRUNC Low Precision
- 4398: fix: correct object return types for arrow functions
- 4395: Fix name of environment variable
- 4390: Support UNION BY NAME set operation
- 4383: Missing LISTs are NULL
- 4382: Include PID in test directory name
- 4380: R: Avoid `translate_duckdb()` in tests
- 4377: R: Full BLOB support
- 4372: Fix 4370: correctly handle non-flat vectors in list_sort
- 4371: [Python] Changed all RuntimeErrors thrown in the Python client
- 4368: Fixes issue 4365 - Not null constraint is no longer duplicated
- 4364: Allow extra parameters in list_aggr to be passed in, as long as they are constant and only used during the bind
- 4363: Fix for array_position with NaNs: use Equals::Operation instead of regular equality
- 4362: Allow table functions to set cardinality stats through the C API - and utilize this in Julia DataFrame scans
- 4359: Mark slow tests
- 4355: Fix typo in exception text
- 4354: R: Use preinstalled symbol
- 4353: Shell: Add missing newline in help output
- 4352: Tweak contributing guide [ci skip]
- 4345: [Substrait] Pushing-down projections and filters to read relation
- 4340: Correctly schedule pipeline dependencies when scheduling mix of UNION and FULL OUTER JOINs
- 4336: feat: add basic json support to jdbc client
- 4334: Bring ibis/substrait tests to a sane state
- 4332: Fix Julia parallelism interleaving with the garbage collector, and expose Pending Query Result in C interface
- 4328: Allow specifying a custom home directory using the SET home_directory option
- 4327: [Aggregate] DISTINCT aggregates without GROUP BY are now executed in parallel
- 4324: Fix 4309: fix for multiple foreign key constraints on the same table-table pair
- 4323: Optimizer profiling
- 4322: Print NOT operator correctly
- 4319: feat: add missing node versions to CI
- 4317: refactor: remove dead code in python client
- 4316: R: Add rlang as suggested dependency
- 4315: Column Data Collection, Arrow Result conversion rework, Cross Product performance fixes & more
- 4312: R: Install tidy CLI tool
- 4310: R: Add test for `test_all_types()`
- 4304: Improve numeric hash function to a better but slightly slower hash function
- 4301: Add unit of measurement in timer function
- 4300: Support root type on expressions 4278
- 4298: Feature/nodejs client docs
- 4297: fix: remove nodejs test focus
- 4296: Avoid infinite loop in range(NULL)
- 4294: 4276 Serializing data types on table schema in substrait
- 4289: [Python/Pandas] fix +/- inf wrongly converting to NaN (NULL)
- 4288: Fix fuzzer issue w.r.t. NULL values in generate_series
- 4286: [Python - Relation] CreateView on a filtered relation does not cause infinite loop anymore
- 4285: chore: remove cython constraint now that bug is fixed
- 4284: Pandas timezone
- 4283: Return errors from RecordBatchReader
- 4280: R: Remove nycflights13 dependency
- 4279: R: Don't export duckdb_explain()
- 4277: feat: update setup.py links
- 4272: Allow 0 as a seed parameter
- 4266: R: Only quote non-syntactic and reserved words
- 4265: Specialize LIST aggregate function implementation
- 4263: R: Avoid attaching package during tests
- 4259: Add ANY_VALUE agg function
- 4256: Schedule child pipeline correctly
- 4255: Disable ibis substrait tests for now
- 4250: C API: Report appender error in case conversion fails
- 4240: DELIM_JOIN now propagate statistics correctly
- 4237: fix: pin cython to work around bug
- 4236: Integer types now correctly increase `width` of DECIMAL type.
- 4235: Parquet writer: Write dictionary_page_offset, and distinct_count for dictionary encoded strings/enum
- 4234: Implement json_merge_patch and jsonlines output mode
- 4233: feat: fix pandas types in docstrings/python types
- 4230: Handle nulls in structs and lists
- 4225: Add Jaro Winkler
- 4215: Use right template for smallint
- 4213: feat: update instructions for installing master builds in bug report template
- 4212: Improve error message
- 4210: PARQUET: Move StringColumnWriter dictionary to use string_t to avoid allocations
- 4209: Remove unused PhysicalTypes
- 4207: Disable GC during Julia execution to avoid internal GC deadlock in DataFrame scan
- 4206: Fix 4202: in the comparison simplification optimizer, we can only shift the cast to the constant if both casts are invertible
- 4199: feat: Use pip to install and uninstall python client
- 4198: [capi] impl clear bindings for prepared stmt
- 4197: feat: port bug_report.md to bug_report.yml
- 4196: Fix RTTI issue across extension boundaries on OSX
- 4192: Correctly call SetFilePointerEx on Windows so the truncate works as expected
- 4191: Fix Expanded CI test case by adding swap space to test
- 4188: ALTER SEQUENCE IF EXISTS fix
- 4187: [Storage] FOR compression
- 4185: ISSUE 3248 Support for ALTER TABLE altering columns NOT NULL
- 4183: Julia multi-threading fix: avoid using a time-out to cancel threads in case there are no tasks
- 4179: node: add async-iterator-based streaming
- 4175: [CI] Python Build with Sanitizer
- 4172: Update stubs test
- 4168: Issue 4161: Create WindowExecutor
- 4167: node: report memory usage to the node GC
- 4166: Fix 4165: correctly fill in false_sel when performing comparison with constant null value
- 4160: node: don't crash on syntax errors
- 4154: Making date_trunc statistics handling consistent with date_part
- 4153: Support for int64 round trips in R driver using the bit64 package
- 4151: Fix orrify merge conflict
- 4143: Correctly handle query parameters in JDBC
- 4140: CI Fixes
- 4139: Remove redundant code
- 4138: Support struct.* to retrieve all struct fields in SELECT list
- 4134: Fuzzer Fixes
- 4133: Remove DUCKDB_API for deletes. (For Windows/ZIG)
- 4132: [Python] `project` now correctly inherits owning references to PyObjects
- 4131: Missing error messages
- 4125: Fix Orrify rename merge conflicts
- 4124: [Substrait] [Python] [R] Upgrade Substrait and introduce function to export query plan as a substrait - JSON
- 4117: (Hopefully) fix signing extension signing on master
- 4112: PARQUET: Add data pages encodings to their metadata
- 4111: Fix off-by-one in plan cost regression test script
- 4110: Rename Orrify -> ToUnifiedFormat, VectorData -> UnifiedVectorFormat, Normalify -> Flatten
- 4108: ODBC: fixing multicolumn parameter binding
- 4107: Refactor: rename simple aggregate to ungrouped aggregate
- 4104: Support Parquet's `RLE_DICTIONARY` encoding for string columns
- 4103: Ntile fixes
- 4101: Some follow up fixes for extension signing
- 4096: Implement ANALYZE
- 4093: Support ORDER BY and LIMIT in correlated subqueries, and add support for the ARRAY(subquery) syntax
- 4090: Fix for non varchar input for sequence functions
- 4088: Fix Issue 3813 - fixedsize PyArrow List -> DuckDB conversion
- 4083: JDBC Change getTimestamp to throw an error for wrong data types
- 4080: Several parser improvements
- 4076: Unentangle Parquet ColumnWriter and StandardColumnWriterState
- 4075: feat(breaking): improve python exceptions
- 4070: [JDBC] CachedRowSet support
- 4069: Improve error messages of extension install
- 4068: Fix bug with PhysicalStreamingWindow
- 4065: Better handling plus encoding in urls
- 4061: Fix 3991: use case_insensitive_map for headers
- 4060: Null handling unification
- 4059: Prepared Statement Verification & many prepared statement fixes
- 4058: nodejs: use less memory in each
- 4057: Fixed an error in comment
- 4053: [R] [CI] Run arrow test single threaded to avoid wrong fp comparison
- 4050: Bump sqlite scanner version
- 4049: Remove need for locks in TPC-H dbgen
- 4048: Test query profiler shouldn't output profiling info to the console
- 4045: Making delayload flags dependent on whether we are NOT doing a static…
- 4044: Issue 3593: avoid duplicate eliminating correlated columns in subqueries when they involve LIST columns
- 4039: Making memory leak sanitizer happy with DuckDB Shell
- 4035: Fix several memory-allocation related issues - use Allocator in many places, and reduce many allocations all over
- 4033: Plan cost regression tests
- 4032: Add missing python test dependencies
- 4031: Fix issue 3989
- 4012: Fix amalgamated build with multiple .cpp
- 4011: Fix amalgamation script when --splits is used
- 4009: `EXPLAIN ANALYSE` should honor profiler output format
- 4005: Fix for 3997
- 4002: fix fts/httpfs include directories
- 3999: Include guard renaming for amalgamation export
- 3996: Fix for issue 3951
- 3990: Substrait Interface in R API
- 3988: feat: implement DuckDBConnectiongetSchema for JDBC
- 3985: Pandas->DuckDB Series of dtype='O' conversion
- 3982: Expose dbgen text buffer size as a parameter and Python Replacement Scans Leak fix
- 3978: Enhance bound parameters error message
- 3977: Adding alias part 2
- 3973: Using aggregate input data for aggregate functions
- 3971: Issue 3079: When installed system RAM cannot be determined, default to no memory limit
- 3967: Use fmt library for Value::ToString of float/double types
- 3965: Fix 3942: avoid converting + to space in httplib::decode_url
- 3964: Add support for DATEFORMAT and TIMESTAMPFORMAT to COPY TO
- 3963: Atomic extension install: use UUID in temp file
- 3961: Fix 3960: avoid returning an error when a blob contains a NULL character in duckdb_append_blob
- 3958: Fix 3955: correctly compute width/scale when combining decimal type of different width/scale
- 3957: [Java] Implement appender support for all? UTF-8 characters 😜
- 3953: Fix missing LIST type in duckdb_types
- 3952: Windows FileExists regression fix: need to use _wstati64 instead of _wstat64i32
- 3950: Atomic extension installation
- 3945: Fuzzer 55: Remove Normalify Call
- 3939: Issue 3937: Casting infinite times
- 3928: Adding alias type struct and map
- 3927: Fix failing TPC-E test
- 3925: New Julia package requires 0.4 of DuckDB_jll
- 3921: Retire `LogicalTypeId::HASH` and replace it with `LogicalTypeId::UBIGINT`
- 3919: ODBC: SingleExecuteStmt and error message
- 3918: Julia compat version
- 3917: Ignore invalid UTF8 in fuzzer scripts
- 3916: Julia Guidelines fix
- 3915: Add duckdb_extensions function
- 3914: Expanding jdbc deploy script to be able to automatically release, too
- 3912: Julia UUID and version bump
- 3911: Making universal builds of OSX Extensions
- 3910: Fix for export of current_time, current_timestamp, etc functions
- 3909: More fuzzer fixes
- 3903: Issue 3881: DATE_TRUNC statistics
- 3900: Add newlines at EOF
- 3897: feat: add extension load/install methods to python client
- 3882: Uncompressed string improvements
- 3868: Bump yyjson version
- 3867: Enable exporting macro's
- 3866: Add default for function NULL handling
- 3864: [Python] Relation Explain
- 3853: Feature/struct_insert function
- 3814: Expose dbgen text buffer size as a parameter
- 3694: List lambdas
- 3618: Struct Types for Node.js UDFs
- 3600: Issue 1466: added `map_from_entries` function

0.4.0

Not secure

This preview release of DuckDB is named "Ferruginea" after the [Andean Duck](https://en.wikipedia.org/wiki/Andean_duck).

Binary builds are listed below. Feedback is very welcome.

Note: This release should be backwards-compatible wrt the on-disk storage format, but the next release may very well be incompatible again. So please don't rely on this just yet. 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.

Also note: DuckDB is switching to [semantic versioning](https://semver.org). Version numbers look like this: `MAJOR.MINOR.PATCH` with changes to
- MAJOR version when you make incompatible API changes,
- MINOR version when you add functionality in a backwards compatible manner, and
- PATCH version when you make backwards compatible bug fixes.

However, note that because `MAJOR` is currently 0, "Major version zero (0.y.z) is for initial development. Anything MAY change at any time. The public API SHOULD NOT be considered stable."

Below a list of changes in this release

Major Changes & Features
- 3767: Table function rework, parallel Julia DF scans & Python regression tests
- 3749 & 3747: Query cancellation with CTRL-C for R and Python clients
- 3700: Support Parallel Order-Preserving Result Set Materialization
- 3696: Support WINDOW FILTER
- 3620: HTTP read optimization
- 3668: Adding alias type
- 3435: Add support for reading newline-delimited JSON
- 3783: Extension loading by statically linking DuckDB

Minor Changes & Bug Fixes
- 3905: Fix SQLancer CI
- 3904: Fix 3896: correctly compute GroupRowsAvailable in struct reader in case a child-entry is not just a list, but a struct with only list entries
- 3902: Fuzzer: fix sanitization of address sanitizer error
- 3901: R: Extract DetectLogicalType() function
- 3899: R: Check query return type instead of query type in dbFetch()
- 3898: Issue 3880: Rebind DATE_TRUNC dates
- 3894: Purge concurrent queue when enqueueing entries to prevent entries from piling up
- 3892: Fix for issue 3878
- 3889: Fix TreeRenderer crash on invalid UTF8
- 3888: Julia Table Functions: add stack trace to errors reported
- 3887: Correctly reset interrupted flag so verification does not overwrite original error
- 3886: Remove the check_tread from python connection
- 3879: Avoid title is too long error in fuzzer issue submission
- 3877: Fix use-after-free in create view with prepared statement parameter
- 3872: Glob with search paths
- 3871: [Python] Making new connections to cursors and adding lock on queries over sampe connection
- 3869: Several OSSFuzz fixes
- 3865: Fix 3860: add support for creating foreign keys on temporary tables, and for now disable support for cross-schema foreign keys
- 3863: Out-of-tree Extensions for Windows
- 3862: Rework of Struct <> Dictionary Vectors, and add test_vector_types function
- 3852: Added support for generated columns to TableCatalogEntry->ToSQL()
- 3850: Enable EXTENSION_STATIC_BUILD for Mac too
- 3849: [Python] Unbundle Substrait
- 3848: Parquet: fix for fixed length byte arrays in dictionary column reader
- 3847: Expand oss-fuzz tests to run queries and check for internal errors
- 3846: Pass through read only flag for node connector
- 3845: Add queries over Arrow to Python regression tests, and time entirety of TPC-H
- 3843: [JDBC] Pass through scale and precision for decimal types from DuckDBColumnTypeMetaData
- 3842: Allow to use custom memory allocator through DuckDB API on Windows
- 3837: Fix overflow in generate_series and overflow in abs operator
- 3832: Issue 3816: Parquet Time Zones
- 3831: s3fs decode keys correctly
- 3828: Update testthat snapshots
- 3818: Add SQLancer to CI Fuzzing Framework
- 3815: Out-of-tree Extension Builds
- 3812: Fix several issues found by Valgrind
- 3810: DuckDB.jl Julia Package History
- 3809: Add `shell: bash` everywhere
- 3802: fix ci breaking from extension PR
- 3799: Optimisation rule for regexp_matches with literal pattern
- 3798: Substrait: Adding more compatibility with Substrait and Ibis
- 3792: Issue 3790: Temporal IsFinite/IsInf
- 3791: Issue 3721: Rightshift Negative Hugeint
- 3786: Fix binding of fully qualified view reference
- 3785: Python: Allowing cursor to set check threads flag
- 3784: Improve speed of ALTER TABLE ADD COLUMN
- 3778: More node types
- 3777: Python: Updating Stubs and Bringing Stubs tests back
- 3776: Simplify `clangd` target
- 3775: Expose dbgen speed_seed functions on header file and add missing ones
- 3771: Increment R package version
- 3765: Issue 3759: Node Time Zone
- 3764: Issue 3763: List Min/Max Problems
- 3761: Fix .import not creating missing table in CLI
- 3760: Requiring keys provided to `map` to be unique
- 3757: Fix 3756: fix issue when running blockwise NL join on dictionary vectors of structs
- 3752: Fixed error handling for node exec()
- 3751: Decreasing the overallocation for list aggregates
- 3750: Fix a bug in HyperLogLog
- 3746: Check if replacement scans don't leak memory
- 3745: Arrow/Pandas Case Insensitive Columns
- 3744: Treating ENUM Case in pyresult describe
- 3739: DuckDBPyRelation: support `offset` argument for `limit()`
- 3738: Fix 3730: avoid modifying the payload in-place in aggregate hash table, because it might be used multiple times in case of grouping sets
- 3736: JDBC better error handling
- 3733: Progress bar clean-up: fix thread sanitizer issue, and move progress bar code to individual operators
- 3720: Issue 3515: Add statistical rounding
- 3707: Fix 3702: avoid assertion that we are not storing internal entries in the file
- 3706: Implement sqlite3_file_control and sqlite3_sleep
- 3705: Add support for ENUM converted types in the Parquet reader
- 3699: Zero-copy scans for non-list uncompressed segments
- 3695: Only rename pandas columns that have duplicates
- 3692: Compatibility with dev dbplyr
- 3691: Fix 3690: correctly assign catalog set to default objects to avoid crash when used as dependency
- 3681: R: Fail CI/CD on NOTEs, check examples on UBSAN, log valgrind output
- 3677: Fuzzer fix: avoid reporting non-internal errors
- 3676: More ccache removal from OSX Extension Release
- 3675: More extensive SQLLogicTest testing, and temporarily disable OR pushdown
- 3667: Handling dataframes with repeated names in columns outside the bind. Now when registering df for scan.
- 3665: Delete correct revision in pypi cleanup script
- 3664: try/except in pypi cleanup
- 3663: Return PY registered objects from temporary views
- 3662: Remove CCache from the OSX Extensions Release build
- 3661: Automatic PyPI cleanup in CI
- 3653: Fixing enum comparison at where clause to TRY_CAST
- 3652: to issue3475 optimize CSG & CMP enumeration of join order optimizer
- 3650: Issue 3610 mem leak
- 3648: Julia DataFrame Scan Performance Improvements & TPC-H Tests
- 3646: ODBC: adjustments because of ADO
- 3643: Fix for 3639, dont use string copy and value api to fill factor vector
- 3635: Avoid running approx quantile with vsize=2
- 3634: Fix some issues with the fuzzer auto-closing issue behavior
- 3633: Add default type generator, move built-in types to default type class and improve error reporting for types
- 3632: Check for div by zero in distinct stats
- 3630: Fix issue 3611
- 3629: S3 Minio fix
- 3628: Issue 3625: Adding canonical guards around Arrow CData Interface
- 3624: Add interval to DBAPI description
- 3615: Fix 1785: correctly copy constraints in ADD COLUMN of alter table
- 3614: Correctly propagate what a statement returns from the binder
- 3613: SQLSmith fuzzer fixes
- 3612: SQLite UDF fixes for writefile and friends
- 3609: Fix operator precedence of ** in the parser
- 3608: Turn the expression depth limit into a configureable parameter
- 3607: Implements __enter__ and __exit__ functions on pyconnection to allow the use of context managers
- 3606: Use Python 3 for configuring R
- 3604: Equal or null optimization
- 3603: Fixing ascii bug in histogram strings
- 3602: Support for Arrow Timezone
- 3598: Add auto-commit off to JDBC Connection
- 3594: Issue 3588: Half constant BETWEEN
- 3592: Issue 3444: Approximate quantile lists
- 3589: Issue 1187: Virtual Generated Columns
- 3576: More compliant with substrait and upgrading version up to 0.1.2
- 3575: Issue 3534: Remove TIMESTAMPTZ casts
- 3574: Issue 3430: Temporal Infinity Values
- 3571: Fixing JNI, matching function signature exactly
- 3569: Implicit struct_pack
- 3564: Fix for 3562
- 3551: Issue 2309: Update benchmark info in README.
- 3550: ICU Extension Rework: clangd for extensions
- 3547: Issue 3273 support multistatments for JDBC driver
- 3546: Issue 2910: Support pandas boolean datatype
- 3533: Exit with the correct exit code in the regression test runner
- 3531: Correctly increment list offset on histogram aggregation
- 3528: Julia Client - re-enable parallelism by executing tasks on dedicated Julia threads
- 3524: Rework table-in-out function API, and move Unnest table function to table-in-out function
- 3523: Improve HyperLogLog
- 3519: Support in-place updates for unsigned integers
- 3516: Issue 3497: Round DECIMAL casts
- 3514: Issue 3453: Window Partition Collections
- 3512: Issue 3418: Match Multiple Spaces
- 3511: Fix 3505: Correctly handle Foreign Key syntax for when primary-key columns are not specified
- 3507: Fix merge conflicts
- 3504: ODBC: issue 3398
- 3503: ODBC: issue 3478
- 3502: Random-value generation clean-up, and move aux data in client context to separate ClientData class
- 3500: Bug fixes for ENUMs
- 3498: Relational API basics for R client
- 3495: R: support structs
- 3481: List distinct and list unique functionality
- 3474: Unified BufferedCSVReaderOptions parsing
- 3470: Force aggregates to have a Combine method, expose bind data in combine & general bind data clean up
- 3469: Add duckdb.lib to Windows release package
- 3467: ODBC: PowerBI showing column headers
- 3464: CSVReader option 'ignore_errors'
- 3456: Add C API functions to build list/map types and read map types
- 3454: CMake install DLL file on Windows platform
- 3442: ICU Extension Rework: No longer use ICU amalgamation, and update ICU data to 71
- 3437: Implement JNI class, method and field caching
- 3420: Expose get table names from conn to python
- 3416: R extension loading
- 3410: Turn SQLSmith into an extension, add CI fuzzing framework, and add automatic SQL test case reduce functionality
- 3405: Issue 3403: Logical Type Append
- 3389: Issue 3187: Implement strptime_icu
- 3388: CI: Use ccache and clang-tidy-cache
- 3386: Issue 3384: DATE_TRUNC for INTERVAL
- 3382: Fixing python dependency memory leaks
- 3375: Rebind prepared statements in case of type ambiguities, rather than default to VARCHAR
- 3346: list_sort function support

Page 4 of 8

Releases

Has known vulnerabilities

Previous Next

Duckdb

Page 4 of 8

0.7.0

0.6.1

0.6.0

0.5.1

0.5.0

0.4.0

Page 4 of 8

Links

Releases