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

• Expression<Uint8List>

Methods

json() → Expression<String>

Reads this binary JSONB structure and emits its textual representation as minified JSON.

jsonArrayLength([String? path]) → Expression<int>

Assuming that this is an expression evaluating to a binary JSONB array, returns the length of the array.

jsonEach(DatabaseConnectionUser database, [String? path]) → JsonTableFunction

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>

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

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