I see there is no way to create a temporary virtual table. One idea I had was to create a second, in-memory db and attach that, then create the virtual table over there.
Currently I have it working where as soon as I open the db, I use sqlite_master to find any left over virtual tables from before and drop them. Any other ideas? - Andy
