I was wondering if we have a package for storing and executing SQL queries and if yes, can it offer it's services via a service contract.
Situation:
Tom is writing a new version of the Cronjob package, that allows you to store SQL queries to execute on reports. Timo is writing a mailinglist manager that allows you to query users and additional information and store these queries. We are thinking about adding a reporting part to the Survey Module, that allows you to query specific information about a survey responses without having to look at all the information at once (e.g. show me all users that answer with yes on question y in section x).
Idea:
Have one central place to store these SQL queries. Besides the usual suspects, it would store what kind of SQL query this is (at least what package it comes from) and a description. This way we can exchange queries between packages and don't have to deal with security and approval functionality within each seperate package (again). Meaning, if an admin approved a query for the survey package, the cronjob package should not have to reapprove the same query again if it wants to use it.
Does this make sense to you and would this be of general use?