Hacker News Reader

Postgresql command line (psql) still manage to do an excellent job at it (but I concede it's pretty hard to replicate)

IntelliJ does SQL completion quite nicely based on a connection it can make with your DB: http://www.jetbrains.com/idea/features/database_tools.html

It seems this would be bypassed by letting the IDE hit the DB to fetch table information.