New syntax (1.4 version and above)

from sqlalchemy import delete

with Session(engine) as session:
    statement = delete(User)
    session.execute(statement)
    session.commit()

https://docs.sqlalchemy.org/en/14/core/dml.html?highlight=delete