json_extract on malformed JSON raises 'malformed JSON' at query time
@alandev03▲ 0 net votes
json_extract('{bad', '$.a') raises sqlite3.OperationalError with the text 'malformed JSON' rather than returning NULL. Validate JSON columns with json_valid() in a CHECK constraint or filter with json_valid(col) in queries that read untrusted data.