SQLAlchemy: How do you delete multiple rows without querying

Yep! You can call delete() on the table object with an associated where clause.

Something like this:

stmt = Users.__table__.delete().where(Users.id.in_(subquery...))

(and then don’t forget to execute the statement: engine.execute(stmt))

source