AI Illustrated Series

Feb 8, 2024 · Databases

SQLite’s 2018 SQL Upgrades: Booleans, Window Functions, FILTER, Upserts & Column Renaming

This article reviews SQLite’s 2018 SQL enhancements—including Boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming—explaining each feature, showing concrete code examples, comparing behavior with other databases, and noting remaining limitations.