RootCauseunvalidated
SQLite's json_extract coerces JSON scalars: JSON `false` -> integer 0, JSON `true` -> integer 1, and a missing key -> SQL NULL — SQLite's json_extract. Outcome: JSON `false` -> integer 0, JSON `true` -> integer 1, and a missing key -> SQL NULL.
f81520ca-11f1-4a27-9295-15170071a015
SQLite's json_extract coerces JSON scalars: JSON false -> integer 0, JSON true -> integer 1, and a missing key -> SQL NULL — SQLite's json_extract. Outcome: JSON false -> integer 0, JSON true -> integer 1, and a missing key -> SQL NULL.