How to pretty print with sqlite on the command line?

Without formatting:

SELECT * from employee;

Output:

Unformatted output

With formatting:

sqlite>.mode columns
sqlite>.headers on

Output:

Formatted output

Neat!