Output from CSV mode is not properly quoted. An example (from sqlite3):
sqlite> .mode csv sqlite> .header on sqlite> create table "Foo" ( foo, bar ); sqlite> insert into "Foo" values ( 1, 2 ); sqlite> insert into "Foo" values ( 3, 4 ); sqlite> insert into "Foo" values ( "5,6", "7,8 ""9" ); sqlite> select * from "Foo"; foo,bar 1,2 3,4 5,6,7,8 "9
The last line of output isn't correct. It should be quoted as
"5,6","7,8 ""9"
instead. It would also be correct to fully quote everything.