The mips thingie currently runs pre-created queries to get counts of things. Any standard queries can be added pretty easily (from a programmer standpoint). It only reports those counts, then lets you see the lists of patients in each category, and lets you provide amplifying data. It also stores those reports, as well as the itemized values.
The same engine can be made to do lots of other things of course, and could even let you run direct queries provided we scrub them for any input like “CREATE, UPDATE, REPLACE, INSERT” or any command that isn’t “SELECT”. That would not be as useful as the GUI provided by something like phpMyAdmin.
The MIPS module migration is now at the alpha testing stage.