The tradeoff of this approach is that developer also needs to know SQL and not just Python.
I personally think that this is the reason why ORMs are popular.
No need to learn SQL.
You just need to know one programing language.
I personally came to professional programming more than 10+ years ago. At that time there were no ORMs for the web, just write PHP + SQL. After some time ORM started to show up.
Other perspectives are welcome.