One of our founders, Glenn Weinstein, authored a fantastic utility a few years back that allows for any admin to run and test SOQL queries from within their Salesforce org... right from a custom tab! We recently converted the SOQL Query tool to Visualforce and thought we'd share it with the community. It's on the Force.com code share and is available to everyone.
We added some new features, including desc and select *
We have a toolbox of useful utilities we use to quickly show value and get a jump on projects. The SOQL Query Tool has been on of the key ones the past few years. We're looking forward to your feedback.
If you want to download a read-only version from your SVN client, you can run the following command:
svn checkout http://soql-query-tool.googlecode.com/svn/trunk/ soql-query-tool-read-only