JsonbExtensions extension

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

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.