https://www.sqlite.org/cli.html#changing_output_formats:
The sqlite3 program is able to show the results of a query in 14 different output formats:
- ascii
- box
- csv
- column
- html
- insert
- json
- line
- list
- markdown
- quote
- table
- tabs
- tcl
Use .mode [MODE]
to change between these