SQLAlchemy analog of Posgresql FILTER

Asked Dec 18 '21 at 09:51

Active Dec 18 '21 at 11:17

Viewed 27 times

I'm trying to convert this query to SQLAlchemy

SELECT count(*) FILTER(where condition) as cnt FROM table

Can someone give me minimal example of this? Can't find anything in the docs.

edited Dec 18 '21 at 11:17

double-beep

asked Dec 18 '21 at 09:51

karambaq

Is [this](https://docs.sqlalchemy.org/en/14/changelog/migration_10.html#feature-gh134) what you want? – snakecharmerb Dec 18 '21 at 10:13
1

https://stackoverflow.com/questions/37328779/sqlalchemy-func-count-on-boolean-column has an example of using `FILTER` with SQLA. – Ilja Everilä Dec 18 '21 at 11:13

0 Answers0