I would like to run a query in squirrel and directly send the results to a file through the query.
For example MySQL allows me the below syntax to send the query result to a file on the local drive.
SELECT ... INTO OUTFILE 'file_name'
SELECT * from table INTO OUTFILE 'C:\file.csv'
The reason I would like such a feature is we run a lot of pre-defined queries everyday and save it in a csv file for further processing, and there's currently a manual process of saving the output (or the query result through SQL2File) to a csv file, which we would like to eliminate if we have the feature described above.