...
The Query Builder is an unstructured window that allows a user to run preloaded SQL (Structured Query Language) statements against the production database. This feature is typically used to produce ad hoc reports at very short notice (faster than having us build a report for you). This window is not editable in the production database. To add queries, you must create them in the UAT environment and then ask us to promote them when you are ready to move them to production. This feature has the following advantages and limitations:
...
| Rw ui steps macro | |||||
|---|---|---|---|---|---|
To create a new query, click the ADD button. 
Enter the description and select a group from the dropdown. 
Write a new query in the Query Text field using the standard SQL (Structured Query Language) language and existing table structure. 
Click SAVE. 
Test a new query. Then, call the Database Administrator and ask him to evaluate it for efficiency, fix the errors if it's not written well, and then promote it into production. Running a query is only available in production. |
...