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.

Classes

JsonTableFunction
Calls json table-valued functions in drift.

Extensions

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

Functions

jsonbGroupArray(Expression<Object> value) 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) 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.