I need a piece of software that does the following:
1. Has a pane for entering an SQL script
2. Has a pane for determining what you want to do with the output
a. Simply write out the raw data
b. paste the data into an excel template
3. A pane which allows the output to be emailed to people. Including a text field.
The idea is an automatic report robot, which allows me to schedule various reports and the tool automatically checks and runs the reports at the scheduled time.
More information will be provided to the freelance who wins the project.
I will need full access to the source code.