SQLite JSON Boolean Coercion

SQLite json_extract coerces JSON booleans and missing keys into SQL scalars, so branching logic that assumes consistent boolean types mis-buckets rows during migrations and conditional queries, especially when both true values and absent keys collapse into the same branch.