ITPUB

Mar 21, 2025 · Databases

What New SQL Features Did SQLite Add Between Versions 3.22 and 3.26?

This article reviews the SQL enhancements introduced in SQLite from version 3.22.0 through 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming support, while comparing SQLite's capabilities to other major database engines.