DuckDB: 0.6.0 Preview Release "Oxyura"

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 DatabaseMetadata#getFunctions() by @Mause in https://github.com/duckdb/duckdb/pull/5090 * Support batch index in arrow scans by @Mytherin in https://github.com/duckdb/duckdb/pull/5085 * Arrow support for JDBC ResultSet by @hannes in https://github.com/duckdb/duckdb/pull/5088 * fix(jdbc): gracefully handle null bytes in strings by @Mause in https://github.com/duckdb/duckdb/pull/5100 * Add file_row_number flag to parquet reader by @hannes in https://github.com/duckdb/duckdb/pull/5084 * Fix comment by @zhouliqi in https://github.com/duckdb/duckdb/pull/5110 * Add ErrorManager class, allow SQLLogicTests to verify error messages, and improve CSV reader errors by @Mytherin in https://github.com/duckdb/duckdb/pull/5103 * Add support for the COLUMNS expression, which allows expanding computations on multiple columns by @Mytherin in https://github.com/duckdb/duckdb/pull/5120 * Issue #5107: ICU Data Scripts by @hawkfish in https://github.com/duckdb/duckdb/pull/5109 * Batch Insert: Add support for eagerly merging of small adjacent batch indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5113 * Add temporary 'skip_reload' to problematic test by @Tishj in https://github.com/duckdb/duckdb/pull/5133 * [Python] Add MSVC `/utf-8` flag by @metab0t in https://github.com/duckdb/duckdb/pull/5129 * Convert values whose data types do not have explicit support in NodeJS into strings by @jwills in https://github.com/duckdb/duckdb/pull/5130 * Download OpenSSL from Github instead by @Mytherin in https://github.com/duckdb/duckdb/pull/5141 * Add BoxRenderer class - which improves rendering of result sets for the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5140 * [Dev] Add `extension` to excluded folder in `format.py' (format-fix/master) by @Tishj in https://github.com/duckdb/duckdb/pull/5142 * Fix #5124: correctly deal with DICTIONARY vectors inside LIST vectors for various functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5151 * [Aggregate] DISTINCT aggregates *with* GROUP BY are now executed in parallel by @Tishj in https://github.com/duckdb/duckdb/pull/5146 * [Python] Exceptions encountered in 'with' body are now properly propagated by @Tishj in https://github.com/duckdb/duckdb/pull/5157 * Create enum type from query by @lokax in https://github.com/duckdb/duckdb/pull/5126 * Fix #5149: better tracking of query location in column reference, and improve error message by @Mytherin in https://github.com/duckdb/duckdb/pull/5158 * Allow builder to set `GIT_COMMIT_HASH` by @Y-- in https://github.com/duckdb/duckdb/pull/5164 * Fsst bug by @samansmink in https://github.com/duckdb/duckdb/pull/5168 * [Python] Arrow Dataset type requirement is now less strict by @Tishj in https://github.com/duckdb/duckdb/pull/5170 * Fix progress bar of regular table scan by @Mytherin in https://github.com/duckdb/duckdb/pull/5171 * Document highlight features in the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5176 * Support parallel (batch) insertion into tables that have indexes by @Mytherin in https://github.com/duckdb/duckdb/pull/5177 * Support casting of hex strings to integer types by @IanCal in https://github.com/duckdb/duckdb/pull/5160 * [Aggregate] Fix regressions caused by latest distinct HT operator PR by @Tishj in https://github.com/duckdb/duckdb/pull/5169 * R: Remove duckdb:: qualifier by @krlmlr in https://github.com/duckdb/duckdb/pull/5135 * [Compression] Patas Compression (float/double) (variation on Chimp) by @Tishj in https://github.com/duckdb/duckdb/pull/5044 * [C-API] Decimal casting to other type fixes by @Tishj in https://github.com/duckdb/duckdb/pull/4526 * Default NULL handing for CARDINALITY function by @lokax in https://github.com/duckdb/duckdb/pull/5073 * Update OpenSSL to 1.1.1s by @sjaenick in https://github.com/duckdb/duckdb/pull/5184 * Box renderer: Always display "0 rows" if there are no rows by @Mytherin in https://github.com/duckdb/duckdb/pull/5188 * chore: request OS version and architecture in bug reports by @Mause in https://github.com/duckdb/duckdb/pull/5191 * String to struct cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5147 * Optimize String Split by @Mytherin in https://github.com/duckdb/duckdb/pull/5186 * Nicer looking progress bar by @Mytherin in https://github.com/duckdb/duckdb/pull/5187 * Correctly call Reset on cast_chunk in CSV writer to prevent string heap from continuously accumulating data by @Mytherin in https://github.com/duckdb/duckdb/pull/5199 * Increase vector size to 2048 by @Mytherin in https://github.com/duckdb/duckdb/pull/5193 * Issue #5131: Time Zone 2022f … by @hawkfish in https://github.com/duckdb/duckdb/pull/5198 * jemalloc "extension" for Linux by @lnkuiper in https://github.com/duckdb/duckdb/pull/4971 * Further clarify database invalidation error, unify db/transaction invalidation, and move errors to error manager by @Mytherin in https://github.com/duckdb/duckdb/pull/5213 * fix: build NodeJS bindings for M1 by @Mause in https://github.com/duckdb/duckdb/pull/5189 * Arrow extension by @samansmink in https://github.com/duckdb/duckdb/pull/5195 * Fix distinct aggregate race: insert next event before scheduling tasks by @Mytherin in https://github.com/duckdb/duckdb/pull/5219 * Avoid exporting SQLite symbols from our sqlite_api_wrapper when building the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/5217 * buffermanager accounting by @jkub in https://github.com/duckdb/duckdb/pull/5134 * Allow NULL bytes in strings by @Mytherin in https://github.com/duckdb/duckdb/pull/5218 * Use cmake's find_package to trace git executable by @bleskes in https://github.com/duckdb/duckdb/pull/5220 * Issue #5197: Deterministic TimeZone Abbreviations by @hawkfish in https://github.com/duckdb/duckdb/pull/5214 * Issue #5239: DATE_DIFF Microseconds Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/5242 * Various CI Improvements/Speed Ups by @Mytherin in https://github.com/duckdb/duckdb/pull/5228 * Issue #5240: DATE_TRUNC Statistics Orientation by @hawkfish in https://github.com/duckdb/duckdb/pull/5241 * Improvements to Out-of-Core Hash Join by @lnkuiper in https://github.com/duckdb/duckdb/pull/4970 * Add support for extension aliases by @Mytherin in https://github.com/duckdb/duckdb/pull/5226 * Physical batch insert: correctly optimistically flush batches to disk that are close to our row group size by @Mytherin in https://github.com/duckdb/duckdb/pull/5231 * Fix Python stub test by @Mytherin in https://github.com/duckdb/duckdb/pull/5245 * DISTINCT grouped aggregate lowered memory consumption optimization by @Tishj in https://github.com/duckdb/duckdb/pull/5227 * fix: bump node-gyp version by @Mause in https://github.com/duckdb/duckdb/pull/5221 * json_extract bugfixes and memory accounting bugfix by @lnkuiper in https://github.com/duckdb/duckdb/pull/5204 * [Python] Add support for strided `float32` and `float64` data by @Tishj in https://github.com/duckdb/duckdb/pull/5256 * Issue #4978 - 4. Cardinality estimator assertion errors and filter errors by @Tmonster in https://github.com/duckdb/duckdb/pull/5232 * Adding total_uncompressed_size to parquet column chunk metadata by @hannes in https://github.com/duckdb/duckdb/pull/5216 * Issue #5258: Inverse Percentile NULLs by @hawkfish in https://github.com/duckdb/duckdb/pull/5260 * Issue #5205: TIMESTAMPTZ Casting by @hawkfish in https://github.com/duckdb/duckdb/pull/5229 * 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