The SQLite documentation for its command line client indicates that its possible to filter output of SQLite queries through UNIX utilities:
The default output mode is "list".
List mode is especially useful when you are going to send the output of a query to another program (such as AWK) for additional processing.
example of output produced at an SQLite command prompt
sqlite> select * from todos; 1|finish reading getting started section of the vim manual 2|finish app feature
then, if I try adding a pipe to the command, I just get a new prompt
sqlite> select * from todos; | grep vim ...>
Is it possible to send output to a unix utility using a pipe from the SQLite command line, or is it only possible to filter SQLite output if you are actually writing a C application and using the SQLite C library?