I think pgcli (for postgres) still remains a better option. It has code completion.
The other is developing a complex query and running it again and again, while watching the result, or maybe running multiple queries and comparing the result, etc. That is more of a task for text editor that can execute queries than a CLI query tool.
Now, I don't think this is worth the 30 USD. Something like the upcoming 0xDBE might be worth it, especially since you can avoid stupid Oracle SQL Developer that hands every time there's a network problem.
Or maybe you should just script that so that you have the entire process automated? You could even write the script in Sublime Text if that makes you feel better :)
I created a small Python/Flask application with integrated Ace editor that run in tabs for this exact use case..
https://pypi.python.org/pypi/Pygmie
It has been a HUGE time saver for me. It also has a query history that is saved to browsers local storage. So no more lost queries due to a system/server crash.