SQLite return SELECT in CSV format

In SQLite, how to get a SELECT result in csv format?

In MySQL would be something like...

SELECT tag_name FROM tags FIELDS TERMINATED BY ','

I already tried it in SQLite but it doesn't work.