All I want is to have a workflow somewhat similar to:
Which is super simple and even though it doesn't support advanced features (like multiple databases) it does know how to add/remove columns which is a common use case.
sqlalchemy-migrate has an insanely complex workflow in comparison and both tutorials (1, 2) referenced by the docs are either outdated or irrelevant.
In addition to this, since it interacts directly with the database, you can simply run the queries against the database without actually using the ORM. Plus, SQLAlchemy is much more powerful than Django, albeit with a little higher learning curve.
SQLAlchemy ORM is similar to Django ORM, but at the same time, they differ. SQLAlchemy ORM uses a different concept, Data Mapper, compared to Django's Active Record approach.
I think you already tried your hand on DJango :). These are the functionality right now not available with current SQLAlchemy. Suggested by @madjar you can use development version of Alembic or you can use sqlalchemy-migrate. Relevant post is already in stack overflow.
The creator of SQLAlchemy recently started working on Alembic. While it's still young (version 0.1), it may suits your needs.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With