sqlite3 dev.db -header -column 'SELECT * FROM users;'
Query SQLite with aligned column output
Runs the query and formats the result as aligned columns with a header row, instead of the pipe-separated default. The -header and -column flags are command-line equivalents of the .headers and .mode dot commands. Append ; to end the SQL statement.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.