Duckdb

This is a preview release of DuckDB.
Starting from this release, releases get named as well. Names are chosen from species of ducks (of course). We start with "Clypeata".

*Note*: 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.

Binary builds are listed below. Feedback is very welcome. Major changes:

SQL
- 1057: Add PRAGMA for enabling/disabling optimizer & extend output for query graph
- 1048: Allow CTEs in subqueries (including CTEs themselves) and 987: Allow CTEs in CREATE VIEW statements
- 1046: Prettify Explain/Query Profiler output
- 1037: Support FROM clauses in UPDATE statements
- 1006: STRING_SPLIT and STRING_SPLIT_REGEX SQL functions
- 1000: Implement MD5 function
- 936: Add GLOB support to Parquet & CSV readers
- 899: Table functions information_schema_schemata() and information_schema_tables() and 903: Add table function information_schema_columns()

Engine
- 984: Parallel grouped aggregations and 1045: Some performance fixes for aggregate hash table
- 1008: Index Join
- 991: Local Storage Rework: Per-morsel version info and flush intermediate chunks to the base tables
- 906: Parallel scanning of single Parquet files and 982: ZSTD Support in Parquet library
- 883: Unify Table Scans with Table Functions
- 873: TPC-H Extension
- 884: Remove NFC-normalization requirement for all data and add COLLATE NFC

Client
- 1001: Dynamic Syntax Highlighting in Shell
- 933: Upgrade shell.c to 3330000
- 918: Add in support for Python datetime types in bindings
- 950: Support dates and times output into arrow
- 893: Support for Arrow NULL columns

This is a preview release of DuckDB. Binary builds are listed below. Feedback is very welcome. Major changes:

Engine
- 770: Enable Inter-Pipeline Parallelism
- 835: Type system updates with 779: `INTERVAL` Type, 858: Fixed-precision `DECIMAL` types & 819: `HUGEINT` type
- 790: Parquet write support

API
- 866: Initial Arrow support
- 809: Aggregate UDF support with 843: Generic `CreateAggregateFunction()` & 752: `CreateVectorizedFunction()` using only template parameters

SQL
- 824: `strftime` and `strptime`
- 858: `EXPORT DATABASE` and `IMPORT DATABASE`
- 832: read_csv(_auto) improvements: optional parameters, configurable sample size, line number info

This is a preview release of DuckDB. Binary builds are listed below. Feedback is very welcome.

SQL:
- 730: `FULL OUTER JOIN` Support
- 732: Support for `NULLS FIRST`/`NULLS LAST`
- 698: Add implementation of the `LEAST`/`GREATEST` functions
- 772: Implement `TRIM` function and add optional second parameter to `RTRIM`/`LTRIM`/`TRIM`
- 771: Extended Regex Options

Clients:
- Python: 720: Making Pandas optional and add support for PyPy
- C++: 712: C++ UDF API

This is a preview release of DuckDB. Binary are listed below. Feedback is very welcome. Major changes:
New [website](https://www.duckdb.org) [woo-ho](https://www.youtube.com/watch?v=H9cmPE88a_0)!

Engine
- 653: Parquet reader integration

SQL
- 685: Case insensitive binding of column names
- 662: add `EPOCH_MS` function and test cases

Clients
- 681: JDBC Read-only mode for and 677 duplicate()` method to allow multiple connections to same database

This is a preview release of DuckDB. Feedback is very welcome.

SQL
- SQL functions `IF` and `IFNULL` 644
- SQL string functions `LEFT` 620 and `RIGHT` 631
- 641: `BLOB` type support
- 640: `LIKE` escape support

Clients
- 627: Insertion support for Python relation API

This is the sixth preview release of DuckDB. Feedback is very welcome.
[Binary builds are available as well](http://download.duckdb.org/alias/v0.1.7).

SQL
- [Add / remove columns, change default values & column type](https://www.duckdb.org/docs/current/sql/statements/altertable.html) #612
- [Collation support](https://www.duckdb.org/docs/current/sql/expressions/collations.html)
- CSV sniffer `READ_CSV_AUTO` for dialect, data type and header detection 582
- `SHOW` & `DESCRIBE` Tables 501
- String function `CONTAINS` 488
- String functions `LPAD` / `RPAD`, `LTRIM` / `RTRIM`, `REPEAT`, `REPLACE` & `UNICODE` 597
- Bit functions `BIT_LENGTH`, `BIT_COUNT`, `BIT_AND`, `BIT_OR`, `BIT_XOR` & `BIT_AGG` 608

Engine
- `LIKE` optimization rules 559
- Adaptive filters in table scans 574
- ICU Extension for extended Collations & Extension Support 594
- Extended zone map support in scans 551
- Disallow NaN/INF in the system 541
- Use UTF Grapheme Cluster Breakers in Reverse and Shell 570

Clients
- Relation API for C++ 509 and Python 598
- Java (TM) JDBC (R) Client for DuckDB 492 520 550