Earlier quoted context omitted.
That is true, but it was fixed in Django 1.4... in 2012. Technology moves a bit in 4 years.
Yep, but as I said it's still rather limited compared to SQLAlchemy. Stuff like aggregations are cumbersome, and it's really really easy to shoot yourself in the foot and cause O(n) queries (especially in templates and in custom admin views). Things specific to Postgres are rather lacking. While they added support for advanced datatypes like arrays, hstore, intervals and search recently (yay!) you still can't use any…
A GSOC project is currently adding customisable indexes: https://groups.google.com/forum/#!topic/django-developers/XA...