The Query Log is an extremely useful resource for debugging and understanding queries sent to the database. When the Query Log is opened, the log will record any query executed from the software and allows the user to copy the contents to another utility for further analysis. The Query Log is opened by selecting the Query Log option in the View menu. The log opens in a new window embedded in the tool and contains a table with two columns: a number of the order the query was run and a column to capture the query sent to the database. The following screenshot shows an open Query Log with a query processed.
The SQL of a Query can also also be easily exported to a file through the File menu. To export SQL to a text file, access the File menu | Export |SQL option and a window will appear to save the document to a user-defined location.