Thoughts on SQLAlchemy

Originally posted on mastodon.technology.

I've recently been using SQLAlchemy's ORM for a Python web app I'm developing. I really like the idea of declaring tables using a class, which provides you with an object class too.

For querying, I'm still a bit undecided. I like .filter_by(), .first(), and .all(), but I'm worried that losing visibility into the direct SQL queries being used makes it easier to forget about indexes. Then again, this project is small enough that I expect to not even need indexes.