Adds, modifies, and/or deletes elements of a JSON Object (it runs the RFC-7396 MergePatch algorithm to apply a given patch against the given JSON input).
Walks the JSON value provided as its first argument and returns a table consisting of one row for each array element or object member. It only walks the immediate children of the top-level array or object, or just the top-level element itself if the top-level element is a primitive value.
Walks the JSON value provided as its first argument and returns a table consisting of one row for each array element or object member. It recursively walks through the JSON substructure starting with the top-level element.
JSON Operators
SQLite also includes the following operators for working with JSON:
Extracts a subcomponent from a JSON document and returns an SQL representation of that subcomponent.
JSON Support in SQLite
Starting from SQLite 3.38.0 (released on 22 February 2022), JSON functions and operators are built into SQLite. Prior to SQLite 3.38.0, you would need to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support.