Sqlite query to a file:

sqlite> .mode ascii
sqlite> .output data.txt
sqlite> .select * from table;

Or dump to a file:

sqlite3 db.sqlite .dump  > dump