Talk by Catherine Devlin at PyOhio 2022.
Description: You've spent too much time learning tool after tool to avoid writing SQL, when there's a really good way to interact with databases; it's called SQL. Just use it! But not alone; there's a class of simple tools that help you keep your SQL well-organized and tie it cleanly into your Python code:
For database migrations, Agnostic
Instead of an ORM, PugSQL
For ETL transformations, dbt
PyOhio talk listing: https://www.pyohio.org/2022/program/t...