Users can put placeholders in the query (e.g. :student_id, :year) and then get prompted for those when they run the query. Results page supports filtering and sorting, and saving to CSV/Excel.
This wasn't intended as an end-user tool because few users know SQL or the database schema -- a few do. I wrote it because we get a lot of one-off or once-a-quarter requests for reports and CSV for Excel.
This wasn't intended as an end-user tool because few users know SQL or the database schema -- a few do. I wrote it because we get a lot of one-off or once-a-quarter requests for reports and CSV for Excel.