SQLFilter type: sql_filter#

class lumen.transforms.sql.SQLFilter(*, conditions, controls, name)#: Translates Lumen Filter query into a SQL WHERE statement.

Parameters#

conditions

type: list[Any]
default: []
List of filter conditions expressed as tuples of the columnname and the filter value.

SQLFilter.apply(sql_in)#

Given an SQL statement, manipulate it, and return a new SQL statement.

Parameters:: sql_in (string) – The initial SQL query to be manipulated.
Returns:: New SQL query derived from the above query.
Return type:: string

SQLFilter.to_spec(context: Dict[str, Any] | None = None) → Dict[str, Any]#

Exports the full specification to reconstruct this component.