JsonExtensions extension

Defines extensions on string expressions to support the json1 api from Dart.

on

Methods

json() Expression<String>
Reads this expression as a JSON structure and outputs the JSON in a minified format.
jsonArrayLength([String? path]) Expression<int>
Assuming that this string is a json array, returns the length of this json array.
jsonb() Expression<Uint8List>
Reads this expression as a JSON structure and outputs the JSON in a binary format internal to sqlite3.
jsonEach(DatabaseConnectionUser database, [String? path]) JsonTableFunction
Calls the json_each table-valued function on this string, optionally using path as the root path.
jsonExtract<T extends Object>(String path) Expression<T>
Assuming that this string is a json object or array, extracts a part of this structure identified by path.
jsonTree(DatabaseConnectionUser database, [String? path]) JsonTableFunction
Calls the json_tree table-valued function on this string, optionally using path as the root path.