I am new to Salesforce and so far I have found three ways to run queries:
- Developer Console
- Force.com IDE (Eclipse)
These work for quick ad-hoc queries but for writing more complex queries e.g. to assess data quality the functionality is lacking. I'd like to have syntax highlighting, line numbering, auto-completion, auto-formatting, etc. I've used Oracle SQL Developer extensively and it would be perfect, but as far as I can tell it can't connect to SFDC without ODBC drivers which are very expensive.
The official Force.com Explorer appears to have been abandoned (Has Force.com Explorer been abandoned?) so that isn't an option. What about the FuseIT SFDC Explorer (http://www.fuseit.com/Solutions/SFDC-Explorer.aspx)? Any other suggestions?