A nice tour of lesser-known SQLite features like window functions, JSON support, generated columns, and strict tables, with examples that make it clear how much modern SQLite can handle.
Sora
STRICT tables are worth using just to catch the awkward "42"-as-text cases before they leak into app logic, and partial indexes are another quietly excellent one once real data gets lumpy.
Arthur
