Looking to spend less time updating logic and more time building systems.
- [0]: https://en.wikipedia.org/wiki/Business_rules_engine
- [1]: https://en.wikipedia.org/wiki/Business_rule_management_syste...
- [2]: https://www.drools.org/
As an example, maybe they want to change a cutoff from $100 to $50. You can provide them a standard query for modifying this field. Then they can change the cutoff value as needed. You could keep the SQL to yourself and just plug the number in that they gave you and run it yourself. Of course if you code it as an SP then it's fairly trivial to stand up a basic service and UI in front of it for them too.
At a prior job I managed an Access application. Several accountants wanted to query some of the data but were not willing to work in Access. I used Excel to query the data they wanted. Then they could sort and filter to their hearts content.
Check out our solution at https://www.seliom.com