Query

FilterCondition

Bases: BaseModel

to_sql()

Convert filter condition to SQL string

FilterGroup

Bases: BaseModel

A group of filter conditions combined with AND or OR logic. Supports nesting for complex boolean expressions.

to_sql()

Convert filter group to SQL string

Query

Bases: BaseModel

A Query is a Pydantic class representing a rAPId compatible data query. It allows for programmatic definition of data queries. See the rAPId specific documentation on how to write a valid query.

Example

query = Query( **{ "select_columns": ["column_a", "column_b"], "filter": { "logic_operator": "AND", "conditions": [ {"column": "column_one", "operator": ">", "value": 10} ] }, "limit": 5 } )