Only comparison operators should be used inside SQLAlchemy filter expressions. Use == instead of is, != instead of is not, sqlalchemy.and_ instead of and, sqlalchemy.or_ instead of or, sqlalchemy.not_ instead of not, and sqlalchemy.in_ instead of in_.
delete-where-no-execute
.delete().where(…) results in a no-op in SQLAlchemy unless the command is executed, use .filter(…).delete() instead.