[FREE] SQL Query Results

[tfs]

I have a need to do some reporting from the SMF database.  I'm specifically after trouble tickets generated via SimpleDesk.  The information is spread across multiple tables in a complex way, and I've created some SQL queries that can return what I'm looking for.  My accountant is the one who needs this info, and she is not computer savvy enough for me to give her access to phpMyAdmin in order to run these SQL queries.

What I'm looking for is a mod that can allow someone to select from a pre-defined list of SQL queries, display the results, and if desired, save the results to CSV.

It would need to allow an admin to add/remove/edit the pre-defined list of SQL queries.

Running the queries would need to be available to a non-admin user, via a permission.

This would be for SMF 2.0.2.

Has anyone seen a mod that can do that?  Anyone interested in writing it?

[tfs]

I'm sorry to see the lack of interest in this, as it seems like something that could be useful for a great many things.

Would anyone care to make a cost estimate for if I were able to pay for it?

[Night09]

Are you returning single results per query or arrays of results needing editing possibly ? Im just interested to know what the expected outcome is from the queries you need to do. I have a few ideas about this but need a bit more info.

[tfs]

I'd just want to return the direct result of a SQL query, whatever it is that the query returns.  Whether it be a simple select * from one table, or complex joins.

Basically I'm looking for the query window in phpMyAdmin, though without the possibility of updates or deletes.

If I were to think beyond my wildest dreams it would be that I'd like to be able to HTML link the rows to a URL in the forum.  Keeping in mind that I'm querying tickets from SimpleDesk, it would be cool if the rows returned in the query could link to the actual tickets in the help desk.