DuckDB 2.0 alpha is out, offering significant speed improvements over the previous version, especially for large data sets and recursive queries. The new features include a separate download pool for async I/O, improved handling of JSON data with VARIANT type, and enhanced triggers and query optimization capabilities.