Export query result to CSV

[Peter Wolanin]

Several other SQLlite browser tools support the option to export a query result to CSV.

Can this be added? An example use case is wanting to build up some anlaysis of a larger data set like the distinct values of a field, count, min, max for each to make a graph.

A simple implementation could use fputcsv to write the output.

[phpLiteAdmin]

This is a useful feature for sure.

[phpLiteAdmin]

Possibly a duplicate of issue #329

[phpLiteAdmin]

As a workaround, one can currently create a view with the query to export. Views can be exported as CSV the same way as tables.

[phpLiteAdmin]

Duplicate of #329.