In fact for a while you could only have adhoc views, but my knowledge is 6 months out of date.

Yes definitely do that. I bundle the sqlite in the app store updates and then mount that as an external db and pull from itself - its a bit awkward but it worked. I had to write the external db stuff, but it was pretty easy.