For an upcoming project one of the requests is that the client needs to be able to run a few custom queries on a specific section (queries are fixed, we know what these will be in advance) and then save the output to an xml file on the server. Bonus points if we can do this with a cron job, say daily.
I've been looking at several plugins (Sprout reports, Zenbu) but none really do what I need out of the box.
How would I go about handling this? Sorry if this question is too general, just looking for pointers on where to start. Any input appreciated!