General Usage Filters
Apply filters using column references
You may apply filters using column references.
| Operator | Description | Example |
|---|---|---|
| and_() | Creates an AND SQL condition | and_(table.a > 23, table.b == u’blue’) |
| or_() | Creates an OR SQL condition | or_(table.a > 23, table.b == u’blue’) |
| not_() | Inverts the condition | not_(and_(table.a > 23, table.b == u’blue’)) |
| in_() | Test if values are with a tuple of values | table.column.in_((1, 2, 3)) |
| notin | Inverts the IN condition | table.column.notin((1, 2, 3)) |
| any_() | Applies the SQL ANY() condition to a column | table.column.any((‘red’, ‘blue’, ‘yellow’)) |
| between | Applies the SQL BETWEEN condition | table.column.between(23, 46) |
| startswith | Applies the SQL LIKE ‘%’ | table.column.startswith(‘abc’) |
| contains | Applies the SQL LIKE ‘%%’ | table.column.contains(‘mno’) |
| endswith | Applies the SQL LIKE ‘%%’ | table.column.endswith(‘xyz’) |
| is_ | Applies the SQL is the IS for things like IS NULL | table.column.is_(None) |
| isnot | Applies the SQL is the IS for things like IS NOT NULL | table.column.isnot(None) |
| like | Applies the SQL LIKE method | table.column.like(‘%foobar%’’) |
| notlike | Applies the SQL NOT LIKE method | table.column.notlike(‘%foobar%’) |
| ilike | Applies the SQL ILIKE method | table.column.ilike(‘%foobar%’) |
| notilike | Applies the SQL NOT ILIKE method | table.column.notilike(‘%foobar%’) |
| NULL, Null, null | Alias for Python None | |
| TRUE, true | Alias for Python True | |
| FALSE, false | Alias for Python False | |
| > | Greater Than | table.column > 23 |
| < | Less Than | table.column < 23 |
| >= | Greater than or equal to | table.column >= 23 |
| <= | Less than or equal to | table.column <= 23 |
| == | Equal | table.column == 23 table.column == ‘blue’ |
| != | Not Equal | table.column != 23 table.column != ‘blue’ |
Last modified April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)