I found the way to send results of a SQL Query ran using the same IB Console. You go to the main menu:
fter executing an SQL statement you may want to save the results in a file. This is called Exporting in IBConsole. To export the current result set, select QueryàSave Output To File… from the main menu. This opens the Export To dialog box, allowing you to specify the path and the name of the file.
By default, the export file will be saved with a .txt extension, which can be disabled by selecting All Files (*.*) from the Save as type drop down menu. Press Save on the Export to dialog to save the data to the specified file.