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>
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.