Json
Represents the structure of the virtual table returned by SQLite's JSON table-valued functions, specifically json_each() and json_tree(). This sealed class defines the common columns available in the result set of these functions.
The json_each() and json_tree() functions are used to iterate over elements of a JSON array or object, returning one row for each element.
Author
MOHAMMAD AZIM ANSARI
See also
Inheritors
Properties
The primitive value for non-container types. It's null if the value is an object or array.
The full path to the current element from the root of the JSON structure.
A unique integer ID for the current element within the JSON structure.
The key for the current element. For a JSON object, this is the property name. For a JSON array, it's the integer index. Null for top-level elements if the input is just a value.
The ID of the parent element, or null for the root element.
The path to the parent of the current element. For json_tree, it also includes an index for the element itself.
The data type of the value, such as 'object', 'array', 'string', 'integer', 'real', 'true', 'false', or 'null'.
The value of the current element. For objects or arrays, this is a JSON string representation. For primitive values (string, number, boolean, null), it's the value itself.