Mike, thanks for this reply and your work on SQLAlchemy. My employer uses your framework, but not yet the newest versions featuring async.
Previously, and still in my personal projects, I have been a Django and Django ORM person.
I got away with by and large avoiding SQL statements in building web apps and have sometimes struggled to understand why SQL statements seemed much more forward-facing in SQLAlchemy in comparison.
Then I listened to your recent Talk Python podcast episode with M. Kennedy [1] and it helped me understand where the framework is coming from with regards to expectations for SQL capability from a developer that wants to use SQLAlchemy.
I believe the focus was much more so on the dark secrets you mention above, though and colored in how you discovered those.
If anyone wants to learn more about async or SQLAlchemy, I highly recommend listening.
As an aside, it was also cool to hear you talking about your project because for me, it humanized you as the maintainer. You sounded pretty chill, which was for some reason not what I was expecting.
I hope you can make it back on to that podcast with less of a gap between appearances next time.
[1] https://talkpython.fm/episodes/show/344/sqlalchemy-2.0