neosqlite.collection.expr_evaluator.sql_converters.array module

SQL converters for array operators.

class neosqlite.collection.expr_evaluator.sql_converters.array.ArrayMixin

Bases: BaseSqlMixin

$size / $in / $isArray / $slice / $indexOfArray / $sum / $avg → SQL.

_convert_array_operator(operator: str, operands: Any) → tuple[str, list[Any]]

Convert array operators to SQL.

_convert_array_transform_operator(operator: str, operands: Any) → tuple[str, list[Any]]

Convert $filter / $map / $reduce to SQL.

Uses json_each to iterate array elements and the AggregationContext variable mechanism to substitute $$var references with the current element column (“value”) in the SQL expression.

_convert_extreme_n(operands: Any, direction: str) → tuple[str, list[Any]]

Convert $maxN / $minN to SQL (shared implementation).