...
To Export as a SQL Query, the User must specify a Delimiter and optionally specify the Enclosure. The Filename 'Prefix' field and 'Extension' may also be optionally selected. These will set the name of the file after it is Exported. SQL must be entered manually as a SQL Query in the 'SQL Query' tab. SQL Select into File Command (MySQL Only) allows you to set the SQL query to a file on the server. This is good if you need to view a lot of data that is limited by Adhoc and Import limitations.
Note: Contact PCR if your Organization is on Oracle DB, for help getting a query.
...