In computing, JavaScript Object Notation (JSON) is an open-standard file format that uses human-readable text to transmit data objects consisting of attribute–value pairs and array data types (or any other serializable value).
SQLite text values can be understood as JSON objects, arrays, or strings. SQLite numeric values and NULL values are interpreted as JSON numbers and nulls, respectively. For functions that accept JSON as their first argument, that argument can be a JSON object, array, number, string, or null.