I don't think there is anything in the vanilla sqlite to do this, but... Have a look at src/test8.c in the main (not amalgamation) source code... this may give you some ideas. I don't think it does what you want exactly, but a quick skim through makes me think it has some pointers in the right direction if you're happy to get your fingers dirty!
----- Original Message ----- From: "Matt Young" <[email protected]> Newsgroups: gmane.comp.db.sqlite.general To: "General Discussion of SQLite Database" <[email protected]> Sent: Thursday, May 06, 2010 9:31 AM Subject: Virtual tables > Can I create a virtual table mapped to an existing table in my > database? Does this let me alias a whole table? Thinking out loud, > does this give me ability to write a query on the virtual table, then > remap the virtual table to a current table and execute the query? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
