SQL

DuckDB 2.0.0 LTS, released October 21, adds triggers, the Quack CONNECT statement, a PEG parser and async I/O; versions before 2.0 cannot read files it creates.

DuckDB's team previewed version 2.0, codenamed Cyanoptera, replacing its PostgreSQL-derived SQL parser with an extensible PEG-based parser and adding client/server mode and triggers.

ClickHouse 26.5 arrives on May 21 with 38 new features, 51 performance optimizations, a 27x Merge table speedup, Iceberg V3 geometry support, and new SQL compatibility aliases for PostgreSQL, Snowflake, and BigQuery.

DuckDB 1.5.0 introduces a VARIANT type that speeds JSON queries up to 100x, promotes GEOMETRY into core, overhauls the CLI, and delivers broad performance gains across more than 6,500 commits from nearly 100 contributors.

SQLite 3.52.0, expected to release around March 11, 2026, will add ALTER TABLE support for NOT NULL and CHECK constraints, a new Query Result Formatter for the CLI, two new JSON array functions, and query planner improvements.