My SQL Editor of choice is SquirrelSQL.
I don't think that I do anything too fancy but I still use it over the one built into IDEA for the following reasons:
- SquirrelSQL allows you to cache tables, views and procedures on startup
- In IDEA I seem to have to click Synchronise on every table to achieve this
- Clicking on a table in SquirrelSQL gives me a view of the columns, primary keys, indexes, content etc etc
- IDEA has the table editor to show the content and copy DDL to see the structure
- Copy DDL fails if you haven't already synchronised the table (why doesn't IDEA syncronise automatically here??)
- SquirrelSQL lets me right click on a table and generate a select script
- SquirrelSQL lets me right click on the results and "Copy as SQL UPDATE-SET statement" or "Copy as SQL INSERT-VALUES statement"
- SquirrelSQL lets me run an explain plan for my query
- SquirrelSQL lets me double click on a row in the output to see the contents to see full data and copy it
- IDEA allows you to use Ctrl-C but there is nothing in the context menu to copy a single cell
- If you have large data IDEA doesn't copy it all e.g. I have 529.82k (204.80k loaded) from an XML_TYPE column. Copy and paste only copies the 204.80k
It doesn't seem like too much, but these are enough to prevent me using IDEA as a DB editor.