I recently started a new Flask app and needed to decide whether to go with SQLAlchmey or Flask-SQLAlchemy. There seemed to be a lot of strong opinions against using Flask-SQLAlchemy so I went with vanilla SQLAlchemy. But now I just discovered that Flask-Security doesn’t support vanilla SQLAlchemy, so I’m starting to regret my decision. And I discovered there is also Flask-SQLAlchemy-Lite.

Any thoughts on which is the best to us? Does Flask-SQLAlchemy-Lite come with the same downsides as Flask-SQLAlchemy?