sqlite-knowledge-patch

What problem does it solve?

This Skill keeps SQLite query authors and extension developers from using outdated APIs, functions, and behaviors that postdate the model training cutoff, reducing runtime errors and compatibility bugs.

Core Features & Use Cases

• Updated SQL functions: Documents new functions such as json_pretty, unistr, jsonb_each/jsonb_tree, and percentile/median aggregates so generated queries use current APIs.
• Behavior and syntax changes: Notes numeric literal underscores, variadic iif/if semantics, negative JSON array indexing, and new strftime specifiers to prevent subtle logic errors.
• C API and pragma guidance: Calls out sqlite3_setlk_timeout, sqlite3_set_errmsg, sqlite3_db_status64, new DBCONFIG options, and PRAGMA wal_checkpoint=NOOP for native extensions, tooling, and runtime configuration.
• Use Case: When updating a codebase or generating SQL for modern SQLite, consult this patch to apply correct functions, FTS5 options, and build/runtime flags.

Quick Start

Load the sqlite-knowledge-patch before writing or reviewing SQLite code to ensure generated SQL, virtual table definitions, and native extension code use the correct functions and APIs introduced in SQLite 3.46–3.51.