I tried to learn SQLAlchemy to avoid writing explicit SQL, but except for the most trivial relationships it requires me to write several times more code in an arcane DSL to accomplish the same thing, at which point, why bother?

And SQLAlchemy Core, among many other SQL generators, gives the lie to "The state of things is bimodal: you either write raw SQL, or you use an ORM."