how can u backup the data in your db to a csv using sql?
>sqlite3 database.sqlite sqlite> .headers on sqlite> .mode csv sqlite> .output backup.csv sqlite> SELECT * FROM tablename; sqlite> .quit
when your query is fulfilled, you can save as CSV format. you would want to view query as "grid".
bcp database.schema.tablename | out 'filename .csv'