Currently when I need to make mass changes that aren't supported in any of bulk change options I have to do this on a one by one basis. Super time consuming to say the least. Also we wish to be able to schedule the batch updates instead of having to run these manually. Use Case: We need to be able to batch update patron registration information to all CAPs (makes it easier for staff to read). It's a relatively simple thing to do in SQL however I can't run the script for it. Another use case is staff on a regular basis don't edit the patron expiration date correctly based on patron code when a patron record is created. We currently have to do this manually, one by one, on a weekly schedule.

The ability to have some capacity to make changes via SQL is critical. One of the biggest issues we have faced since migrating a year and a half ago is the realization that we don't have any capacity to make large scale changes behind the scenes - something I did as needed in our old ILS (Symphony).