SQLite from the building side: the planner, full-text search, and point-lookup performance. hosted libSQL is in turso, and SQLite from zig is in zig database patterns.

sargable-queries — bare indexed columns, materialized join keys, join order with a small table, keyset pagination, unary +
fts5 — ambiguous columns in joins, MATCH input sanitizing, UNINDEXED columns, renames and external content
point-lookup-benchmarks — the three defaults that make a SQLite benchmark measure configuration instead of the engine