From what I understand, the query2sheet* functions always return a complete XLSX file since the blob returned is finalized with the finish function.
An incremental approach (ie. call query2sheet multiple times to have an XLSX file with a tab for each query) is highly requested.