I found no way to terminate running query, and an attempt to close SQLiteSpy
while the query is running throws an exception: "Access violation at address
0079a2d2 in module SQLiteSpy.exe. Read of address 00000058." and does NOT exit.
You may use the following infinitely looping code for testing
WITH RECURSIVE r(i) AS (
values(0)
UNION ALL SELECT i+1 AS x FROM r
) SELECT * FROM r
SQLiteSpy 1.9.13