address_table = Table('address', metadata, autoload=True)
addresses = session.query(address_table).filter(address_table.c.retired == 1)
How to delete rows from a table using an SQLAlchemy query without ORM?