Save query result in CSV format directly into zip file

I want to save a query result in CSV format directly into a zip file, without zip the file after save it in csv. How can I do that?

@elaisafonceca the CSV writer can do this directly under Advanced Settings

Hi mlauber!

I mark that option “compress output file (gzip)” and set the name of the file like “C:\users\file.csv” for example. When I run the “csv writer” node the output is a csv file. If a change the file name to “C:\users\file.gz” the output file is a compressed folder but when I open the compressed folder, the file inside looks like this
image

@elaisafonceca how about a compress node?