The new SQL console in IDEA is a nice addition. However, the current state is quite raw and unpolished.
While having familiar completion for columns etc is very nice, I'm still using external tools at the moment for any SQL querying.
Let me try to compile a list of "blocking" problems:
1) Console in implemented as a pane tab
Whatever type of text I edit, I expect to do it in the editor pane of the IDEA.
Having it in a small tab at the bottom sucks, since:
a) I'm limited to this really small region of my screen
b) When looking at query results, the effective "editing area" is reduced even further
I'd expect to edit SQL in a regular editor tab. This is where I perform all of my other editing after all.
The results of a query execution, however, would fit perfectly well in a bottom-docked results pane.
Of course there's the question of "but is it really an editor file?".
I don't care - make it some kind of virtual file, perhaps showing the name of the datasource in the editor tab?
2) Results need a table
Please present results in a simple table component. 'Nuff said.
3) Completion for tables/columns
Having completion for all the functions supported by my current SQL dialect is nice.
However, most of them (>90%) I will invoke very rarely.
At the moment the completion suggestions for functions easily dwarf/pollute the completion suggestions for table/column names.
Here's an idea: provide SQL function completion only after invoking code completion the second time.
Similar to the new extended smart completion in Diana, you could initially show a message like "Invoke code completion again to receive SQL function suggestions".
Of course I have tons of other requests and ideas, but I think above 3 are simply critical for an acceptable user experience.