Duckdb

This preview release of DuckDB is named "Ceruttii" after a [long-extinct relative of the present-day Harleqin Duck](https://en.wikipedia.org/wiki/Harlequin_duck#Taxonomy) (Histrionicus Ceruttii).
Binary builds are listed below. 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.

SQL

- 2064: `RANGE`/`GENERATE_SERIES` for timestamp + interval
- 1905: Add `PARQUET_METADATA` and `PARQUET_SCHEMA` functions
- 2059, 1995, 2020 & 1960: Window `RANGE` framing, `NTH_VALUE` and other improvements

APIs

- [Many Arrow integration improvements](https://github.com/duckdb/duckdb/pulls?q=is%3Apr+is%3Aclosed+arrow)
- [Many ODBC driver improvements](https://github.com/duckdb/duckdb/pulls?q=is%3Apr+is%3Aclosed+odbc)
- 1815: Initial version: SQLite UDF API
- 2001: Support DBConfig in C API

Engine

- 1975, 1876 & 2009: Unified row layout for sorting, aggregate & joins
- 1930 & 1904: List Storage
- 2050: CSV Reader/Casting Framework Refactor & add support for `TRY_CAST`
- 1950: Add Constant Segment Compression to Storage
- 1957: Add pipe/stream file system

This preview release of DuckDB is named "Mollissima" after the Common Eider (Somateria mollissima).
Binary builds are listed below. Feedback is very welcome.

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 for details.

Major changes:

SQL
- 1847: Unify catalog access functions, and provide views for common PostgreSQL catalog functions
- 1822: Python/JSON-Style Struct & List Syntax
- 1862: 1584 Implementing `NEXTAFTER` for float and double
- 1860: `FIRST` implementation for nested types
- 1858: `UNNEST` table function & array syntax in parser
- 1761: Issue 1746: Moving `QUANTILE`

APIs

- 1852, 1840, 1831, 1819 and 1779: Improvements to Arrow Integration
- 1843: First iteration of ODBC driver
- 1832: Add visualizer extension
- 1803: Converting Nested Types to native python
- 1773: Add support for key/value style configuration, and expose this in the Python API

Engine
- 1808: Row-Group Based Storage
- 1842: Add (Persistent) Struct Storage Support
- 1859: Read and write atomically with offsets
- 1851: Internal Type Rework
- 1845: Nested join payloads
- 1813: Aggregate Row Layout
- 1836: Join Row Layout
- 1804: Use Allocator class in buffer manager and add a test for a custom allocator usage

This preview release of DuckDB is named "Jamaicensis" after the [blue-billed Ruddy Duck (Oxyura jamaicensis)](https://en.wikipedia.org/wiki/Ruddy_duck). Binary builds are listed below. Feedback is very welcome.

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 for details.

Also note: Due to changes in the internal storage (1530), databases created with this release wil require somewhat more disk space. This is transient as we are working hard to finalise the on-disk storage format.

Major changes:

Engine
- 1666: External merge sort, 1580: Parallel scan of ordered result and 1561: Rework physical ORDER BY
- 1520 & 1574: Window function computation parallelism
- 1540: Add table functions that take a subquery parameter
- 1533: Using vectors, instead of column chunks as lists
- 1530: Store null values separate from main data in a Validity Segment

SQL
- 1568: Positional Reference Operator `1` etc.
- 1671: `QUANTILE` variants and 1685: Temporal quantiles
- 1695: New Timestamp Types `TIMESTAMP_NS`, `TIMESTAMP_MS` and `TIMESTAMP_NS`
- 1647: Add support for UTC offset timestamp parsing to regular timestamp conversion
- 1659: Add support for `USING` keyword in `DELETE` statement
- 1638, 1663, 1621 & 1484: Many changes arount `ARRAY` syntax
- 1610: Add support for `CURRVAL`
- 1544: Add `SKIP` as an option to `READ_CSV` and `COPY`

APIs
- 1525: Add loadable extensions support
- 1711: Parallel Arrow Scans
- 1569: Map-style UDFs for Python API
- 1534: Extensible Replacement Scans & Automatic Pandas Scans and 1487: Automatically use parquet or CSV scan when using a table name that ends in `.parquet` or `.csv`
- 1649: Add a QueryRelation object that can be used to convert a query directly into a relation object, 1665: Adding from_query to python api
- 1550: Shell: Add support for Ctrl + arrow keys to linenoise, and make Ctrl+C terminate the current query instead of the process
- 1514: Using `ALTREP` to speed up string column transfer to R
- 1502: R: implementation of Rstudio connection-contract tab

This preview release of DuckDB is named "Falcata" after the Falcated Duck (Mareca falcata). Binary builds are listed below. Feedback is very welcome.

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 for details.

Major Changes:

Engine
- 1356: **Incremental Checkpointing**
- 1422: Optimize Top N Implementation

SQL
- 1406, 1372, 1387: Many, many new aggregate functions
- 1460: `QUANTILE` aggregate variant that takes a list of quantiles & 1346: Approximate Quantiles
- 1461: `JACCARD`, 1441 `LEVENSHTEIN` & `HAMMING` distance scalar function
- 1370: `FACTORIAL` scalar function and ! postfix operator
- 1363: `IS (NOT) DISTINCT FROM`
- 1385: `LIST_EXTRACT` to get a single element from a list
- 1361: Aliases in the `HAVING` clause (fixes issue 1358)
- 1355: Limit clause with non constant values

APIs:
- 1430 & 1424: **DuckDB WASM builds**
- 1419: Exporting the appender api to C
- 1408: Add blob support to C API
- 1432, 1459 & 1456: Progress Bar
- 1440: Detailed profiler.

This preview release of DuckDB is named "Jubata" after the [Australian Wood Duck](https://en.wikipedia.org/wiki/Australian_wood_duck) (Chenonetta jubata). Binary builds are listed below. Feedback is very welcome.

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 for details.

Major changes:
SQL
- 1231: Full Text Search extension
- 1309: Filter Clause for Aggregates
- 1195: `SAMPLE` Operator
- 1244: `SHOW` select queries
- 1301: `CHR` and `ASCII` functions & 1252: Add `GAMMA` and `LGAMMA` functions

Engine
- 1211: (Mostly) Lock-Free Buffer Manager
- 1325: Unsigned Integer Types Support
- 1229: Filter Pull Up Optimizer
- 1296: Optimizer that removes redundant `DELIM_GET` and `DELIM_JOIN` operators
- 1219: `DATE`, `TIME` and `TIMESTAMP` rework: move to epoch format & microsecond support

Clients
- 1287 and 1275: Improving JDBC compatibility
- 1260: Rework client API and prepared statements, and improve DuckDB -> Pandas conversion
- 1230: Add support for parallel scanning of pandas data frames
- 1256: JNI appender
- 1209: Write shell history to file when added to allow crash recovery, and fix crash when .importing file with invalid
- 1204: Add support for blobs to the R API and 1202: Add blob support to the python api

Parquet
- 1314: Refactor and nested types support for Parquet Reader

This preview release of DuckDB is named "Serrator" after the Red-breasted merganser (Mergus serrator). Binary builds are listed below. Feedback is very welcome.

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 for details.

Major changes:

SQL:
- 1179: Interval Cleanup & Extended `INTERVAL` Syntax
- 1147: Add exact `MEDIAN` and `QUANTILE` functions
- 1129: Support scalar functions with `CREATE FUNCTION`
- 1137: Add support for (`NOT`) `ILIKE`, and optimize certain types of `LIKE` expressions

Engine
- 1160: Perfect Aggregate Hash Tables
- 1133: Statistics Rework & Statistics Propagation
- 1144: Common Aggregate Optimizer, 1143: CSE Optimizer and 1135: Optimizing expressions in grouping keys
- 1138: Use predication in filters
- 1071: Removing string null termination requirement

Clients
- 1112: Add DuckDB node.js API
- 1168: Add support for Pandas category types
- 1181: Extend DuckDB::LibraryVersion() to output dev version in format `0.2.3-devXXX` & 1176: Python binding: Add module attributes for introspecting DuckDB version

Parquet Reader:
- 1183: Filter pushdown for Parquet reader
- 1167: Exporting Parquet statistics to DuckDB
- 1162: Add support for compression codec in Parquet writer & 1163: Add ZSTD Compression Code and add ZSTD codec as option for Parquet export
- 1103: Add object cache and Parquet metadata cache