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" <youngsanger-re5jqeeqqe8avxtiumw...@public.gmane.org> Newsgroups: gmane.comp.db.sqlite.general To: "General Discussion of SQLite Database" <sqlite-users-czdrofg0bjidnm+yrof...@public.gmane.org> 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 > sqlite-users-czdrofg0bjidnm+yrof...@public.gmane.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users