A Preview of DuckDB v2.0

DuckDB v2.0, set to launch this fall, boasts a range of headline features. Dubbed “Cyanoptera,” the new version introduces a server mode, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, and a cutting-edge storage format. These enhancements, born from over 10,000 commits since the v1.5 release in March, position DuckDB as a robust server solution.

Key SQL-level improvements include the CONNECT statement, replacing the remote.query workaround, enabling remote query routing across DuckDB processes. The VARIANT type, a JSON on steroids, enables efficient storage and processing of semi-structured data. Triggers are now fully supported, facilitating audit tables and other use cases.

The SQL dialect also sees growth with FETCH FIRST 2 ROWS ONLY, OVERLAY(), UNNEST in GROUP BY, and MERGE / UPDATE semantics for multi-matched rows. Asynchronous I/O and a revamped C API further bolster performance.