JsonbExtensions extension

Defines extensions for the binary JSONB format introduced in sqlite3 version 3.45.

For details, see https://www.sqlite.org/json1.html#jsonb

on

Methods

json() Expression<String>

Available on Expression<Uint8List>, provided by the JsonbExtensions extension

Reads this binary JSONB structure and emits its textual representation as minified JSON.
jsonArrayLength([String? path]) Expression<int>

Available on Expression<Uint8List>, provided by the JsonbExtensions extension

Assuming that this is an expression evaluating to a binary JSONB array, returns the length of the array.
jsonEach(DatabaseConnectionUser database, [String? path]) JsonTableFunction

Available on Expression<Uint8List>, provided by the JsonbExtensions extension

Calls the json_each table-valued function on this binary JSON buffer, optionally using path as the root path.
jsonExtract<T extends Object>(String path) Expression<T>

Available on Expression<Uint8List>, provided by the JsonbExtensions extension

Assuming that this is an expression evaluating to a binary JSONB object or array, extracts the part of the structure identified by path.
jsonTree(DatabaseConnectionUser database, [String? path]) JsonTableFunction

Available on Expression<Uint8List>, provided by the JsonbExtensions extension

Calls the json_tree table-valued function on this binary JSON buffer, optionally using path as the root path.