The clean solution is quite simple - if you don’t want non IT people writing software then buy a product to solve the issue or hire some experienced professional developers. The problem is that a lot of time the clean solution isn’t feasible because of constraints or culture and you end up with something in the “dirty” solution end of spectrum.