SQLite Forum

New Caveat (bug?) Interrupt does not Interrupt during Columnar output
An observation, at least on Windows.  Because the CLI columnar output functions have to read the entire query result before generating output to the console/stdout, you can no longer "interrupt" a query while the output is rendering -- the signal handler only interrupts the query execution but the query execution is already complete by the time the output starts.

This means that, for example, if the table t1 contains 1 million rows, in .mode list you can interrupt with ^C (SIGINT) after seeing the first few scroll on the screen.  However, in .mode box or other columnar output format in which the query must have run to completion before output is produced, you can no longer interrupt the output.