neosqlite.collection.expr_evaluator.sql_converters.object module

SQL converters for object operators.

class neosqlite.collection.expr_evaluator.sql_converters.object.ObjectMixin[source]

Bases: BaseSqlMixin

$mergeObjects / $getField / $setField / $unsetField / $objectToArray / $let → SQL.

_convert_object_operator(operator: str, operands: Any) tuple[str, list[Any]][source]

Convert object operators to SQL.

Note: json_patch() works with both JSON and JSONB data types. Only json_extract/jsonb_extract, json_set/jsonb_set have JSONB variants.

_convert_let_operator(operands: Any) tuple[str, list[Any]][source]

Convert $let operator to SQL by inlining variables.

MongoDB syntax: { $let: { vars: { <var1>: <expr1>, … }, in: <expr> } }