Functionsยง
- json_
array_ contains - Create a JSON array contains value condition
- json_
contains - Create a JSON field contains condition using json_extract
- json_eq
- Create a JSON field equality condition using SQLite ->> operator
- json_
exists - Create a JSON field exists condition using json_type
- json_
extract - Helper function for JSON extraction using ->> operator
- json_
extract_ text - Helper function for JSON extraction as JSON text using -> operator
- json_gt
- Create a JSON numeric greater-than condition
- json_ne
- Create a JSON field inequality condition
- json_
not_ exists - Create a JSON field does not exist condition
- json_
object_ contains_ key - Create a JSON object contains key condition
- json_
text_ contains - Create a JSON text search condition using case-insensitive matching