Agreed. The only thing it probably doesn't satisfy here is lightweight (being built on Eclipse). But actually one of the things that keeps me with it is that being built on Eclipse I can use a whole bunch of Eclipse plugins that have have from that environment and they work great.
Just tried that and it did autocomplete, for example 'dal' to 'django_admin_log'. It did not auto-suggest it while typing, but when I pressed control-space it expanded it.
I tried many free alternatives and for a long time I am using valentina studio. It requires registration for free version license key. It has nearly all features that I need with in free version.
Agree as well! Best SQL IDE for Oracle/PostgreSQL. It uses the same IDE framework that eclipse use. So you can quickly get familiar with and even use the same shortcuts.