I, too, would love to see some type of API (or web service) to allow some level of ad-hoc requests. I don't know all the details of your layout so I can't say how easy any of this would be. Are you using SQL Server? How big is the current data?
Maybe we could throw in for a near-line server with lots of indexing to handle our weirdo querries?!? Then update it at night or once a week or something.
I'm asking because I'm also thinking about screen scraping some data out of some of this in order to create some odd querries locally.