CODE EXAMPLE FOR SQL

sqlite csv

-- set output to a csv file
sqlite> .mode csv
sqlite> .output test.csv
sqlite> select * from tbl1;

-- revert output to stdout
sqlite> .output stdout