Thank you, that explains the willingness to entirely ditch the migrations framework in favour of raw sql!

Thank you. Relevant.

For those who do not know Django uses said library for PostgresSQL support. Mind you, if you don't like Django's ORM, you don't have to use it.

Isn't it the standard Python library for PostgreSQL? A co-worker just installed it for some work having nothing to do with Django.

It's the most popular, if you mean standard by that metric then yes, if you mean standard as in built-in to Python, then no (I only mention this because SQLite does come with Python OOTB).

Yes, it's the most popular driver for PostgreSQL in Python.