I'm new to IntelliJ, so I apologize in advance if I misunderstand the concept on how to work with sql (files) via IntelliJ Ultimate.
In my daily work I have to deal a lot with databases, this also means that I have to query sometimes the same information again and again. Hence I store those queries usually in sql files.
So if I happen to use IntelliJ to write a query in the console and like to save/export it to a file I can only use F5 or Refactor -> Copy. For this I had to search through your filetracker https://youtrack.jetbrains.com/issue/IDEA-134312. I don't understand why the sql console toolbar doesn't have an action "Save" or "Save As"? I find this not really intuitive and many of my colleagues didn't even know that it was possible to save the content of a sql console to a file.
I have a similar issue when trying to load/open an existing sql file from the filesystem. The sql console doesn't have an action to load the content of an existing file into it. So by using File -> Open I can open it and I can execute the content. However I don't understand why the content is not automatically loaded into a sql console window but I would have to do this myself by using the shortcut or the action in the db view.
I find this simple topic rather strangely solved not only in IntelliJ but in DataGrip as well. Is there a particular reason why it is as it is or is this a work in progress thing?
Thanks in advance!