Duckdb

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

This is the fifth preview release of DuckDB. Feedback is very welcome.
Binary builds can be found here: http://download.duckdb.org/alias/v0.1.6/

SQL
- 455 Table renames `ALTER TABLE tbl RENAME TO tbl2`
- 457 Nested list type can be created using `LIST` aggregation and unpacked with the new `UNNEST` operator
- 463 `INSTR` string function, 477 `PREFIX` string function, 480 `SUFFIX` string function

Engine
- 442 Optimized casting performance to strings
- 444 Variable return types for table-producing functions
- 453 Rework aggregate function interface
- 474 Selection vector rework
- 478 UTF8 NFC normalization of all incoming strings
- 482 Skipping table segments during scan based on min/max indices

Python client
- 451 `date` / `datetime` support
- 467 `description` field for cursor
- 473 Adding `read_only` flag to `connect`
- 481 Rewrite of Python API using `pybind11`

R client
- 468 Support for prepared statements in R client
- 479 Adding automatic CSV to table function `read_csv_duckdb`
- 483 Direct scan operator for R `data.frame` objects

This is the fourth preview release of DuckDB. Feedback is very welcome. Note: The v0.1.4 version was skipped because of a Python packaging issue.

Binary builds can be found here:
http://download.duckdb.org/rev/59f8907b5d89268c158ae1774d77d6314a5c075f/

Major changes:
- 409 Vector Overhaul
- 423 Remove individual vector cardinalities
- 418 `DATE_TRUNC` SQL function
- 424 `REVERSE` SQL function
- 416 Support for `SELECT table.* FROM table`
- 414 STRUCT types in query execution
- 431 Changed internal string representation
- 433 Rename internal type `index_t` to `idx_t`
- 439 Support for temporary structures in read-only mode
- 440 Builds on Solaris & OpenBSD


*Note*: This release contains a bug in the Python API that leads to crashes when fetching strings to NumPy/Pandas 447

This is the third preview release of DuckDB. Feedback is very welcome.
Binary builds can be found here:
http://download.duckdb.org/rev/59f8907b5d89268c158ae1774d77d6314a5c075f/

Major changes:
* 388 Major updates to shell
* 390 Unused Column & Column Lifetime Optimizers
* 402 String and compound keys in indices/primary keys
* 406 Adaptive reordering of filter expressions