Tagged articles
Boolean Literals
11 articles · Page 1 of 1
This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.
Boolean LiteralsSQLSQLite
0 likes · 10 min read

This article explores SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—detailing how each feature works, its syntax, and practical code examples, while also clarifying limitations compared to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, with code examples and comparisons to other databases, highlighting its reliability and suitability for production use.
Boolean LiteralsSQLSQLite
0 likes · 11 min read


ITPUBMar 21, 2025 · Databases
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.
Boolean LiteralsFILTER clauseRename Column
0 likes · 11 min read

This article reviews the SQL enhancements added to SQLite between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, INSERT … ON CONFLICT (upsert), column renaming, and related API updates.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column‑renaming support, and other API changes, while comparing SQLite's capabilities to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 11 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.
Boolean LiteralsSQLSQL features
0 likes · 12 min read

SQLite, often underestimated, introduced several powerful SQL enhancements in 2018—including boolean literals, window functions, FILTER clauses, UPSERT syntax, and column renaming—bringing its capabilities closer to major RDBMSes while retaining its lightweight, file‑based design.
Boolean LiteralsSQLSQLite
0 likes · 11 min read

The article reviews SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—explaining their syntax, behavior with NULLs, and practical examples, while also noting SQLite's reliability and deployment advantages despite lacking a network layer.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article reviews the SQLite enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column renaming, and related API changes, while comparing them to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 11 min read

SQLite, often underestimated, has added powerful SQL capabilities in 2018—including true/false literals, advanced boolean checks, window functions, FILTER clauses, upsert support via INSERT ON CONFLICT, and column renaming—bringing its feature set closer to major databases while retaining its lightweight, file‑based architecture.
Boolean LiteralsSQLSQLite
0 likes · 12 min read
