I'm wondering if there's a way to create a case statement with SqlAlchemy, e.g. the postgresql version

Maybe literal SQL is the way to go if there is no easy way of doing it?

Edit
Report