sqlite3

Query results display format

If you want your query results to be displayed like a table, use the .mode command.

.mode column

If you also want the column names to be displayed, use the .headers command

.headers on