FilterCondition()| Name | Type |
|---|---|
| column | Required[str | sql.Composable] |
| operator | Required[FilterOperator] |
| value | ScalarType | list[ScalarType] | tuple[ScalarType, ScalarType] |
| cast | FilterCast |
A single filter condition.
column is never inserted into the query as raw SQL when it is a
str: it names either a JSONB key (when the store's metadata_columns
is a string) or one of the configured metadata columns (when it is a list).
To filter on a custom SQL expression, pass a trusted
:class:psycopg.sql.Composable instead. operator must be one of the
supported operators and cast one of the supported casts; both are
validated at runtime. value is always passed as a SQL literal.