There is a prototype for three new output modes for the SQLite CLI on trunk.
New modes are:
* JSON
* markdown
* table (looks like MySQL output)
The JSON output seems to work well since JSON is a well-defined format.
The other two modes are in limbo, though. Issues include:
1. How to display BLOB values
2. How to distinguish between NULL and the four-character string 'NULL'
3. How to display strings with special characters like \\n
4. For markdown mode, should it escape characters that have
special meaning to markdown, like \|, \[, \', and \*
Even thought the table and markdown modes are currently on trunk, they
might not survive there until the next release.