extensions/json1 library

Experimental bindings to the json1 sqlite extension.

Note that the json1 extension might not be available on all runtimes. When using this library, it is recommended to use a NativeDatabase with a dependency on sqlite3_flutter_libs.

Extensions

JsonbExtensions on Expression<Uint8List>
Defines extensions for the binary JSONB format introduced in sqlite3 version 3.45.
JsonExtensions on Expression<String>
Defines extensions on string expressions to support the json1 api from Dart.

Functions

jsonbGroupArray(Expression<Object> value, {OrderBy? orderBy, Expression<bool>? filter}) Expression<Uint8List>
Returns a binary representation of a JSON array containing the result of evaluating value in each row of the current group.
jsonbGroupObject(Map<Expression<String>, Expression<Object>> values) Expression<Uint8List>
Returns a binary representation of a JSON object consisting of the provided keys and values in the current group.
jsonGroupArray(Expression<Object> value, {OrderBy? orderBy, Expression<bool>? filter}) Expression<String>
Returns a JSON array containing the result of evaluating value in each row of the current group.
jsonGroupObject(Map<Expression<String>, Expression<Object>> values) Expression<String>
Returns a JSON object consisting of the keys and values from the provided values map.