When I was at Coveo, I participated in the development of a plugin for the Visual Studio Code text editor. This plugin adds support for Salesforce local development. No need to work with the Salesforce console!!! Furthermore, it adds syntax highlighting and autocompletion to apex pages.
In addition, my contribution to the project was to develop the comparison functionality with the source code on Salesforce and the local one on your computer. It is then possible to see the differences before pushing them to the server with the Deploy command.
Also, it is possible with the extension, to launch SOQLrequests from the editor. The returned result is then displayed in the editor in a new window. Two formats are presented, an HTML table and JSON. For installation in Visual Studio Code, open the Extensions panel and look for vsforce. That's all!