With the Data Explorer plugin, you have a button to export in CVS or JSON (and, recently, even one to show a graph).
You can also allow specific groups to access the query (if we are not talking about admin users here)
Then, the user can see a Reports on the group page. He can run the query, and then he can export the results to CSV.
Would that work?