DuckDB 2.0 LTS adds server mode, triggers and VARIANT type

DuckDB released version 2.0.0 on October 21, 2026, as an LTS release supported until at least October 2027. It adds the Quack server mode, SQL triggers, a VARIANT type for semi-structured data, async I/O and a new PEG parser. Database files written by 2.0 cannot be opened by earlier versions.

• Release built from nearly 20,000 commits since version 1.5
• DuckDB 2.0 database files are unreadable by older versions
• Quack server listens only on localhost by default
• DuckDB 1.4 support ends in late November 2026