Tools like that can be extremely productive, and easy for people of no or low programming ability to utilize.
But just like excel, it's a double edged sword, as people "specialize" in it and create monstrous abomination applications way larger than the tool is fit to sustain. It becomes a rat maze of gotchas and obscure tricks, and nobody but the original creator really knows what's going on.
> nobody but the original creator really knows what's going on
That’s true of most “serious” codebases too! Writing code that others can understand takes time and expertise (both expensive), and it’s often not worth it for one-off tools.
A friend of mine spent a very lucrative few years in the late 90s, early 00s doing Excel contracting. Usually for banks who seemed to have quite a lot of these monstrous abominations and a wish to make them far more monstrous going by conversations back then.
Paid for their Porsche 911 until the .com bust broke contracting generally.
>> Tools like that can be extremely productive, and easy for people of no or low programming ability to utilize.
Absolutely. BUT, in the early days, the value of return for end users is higher than the cost of development and maintenance. If the tool is useful and grows, it's going to flip where the cost of development and maintenance is higher the the return, and some tough decisions need to be made.
But just like excel, it's a double edged sword, as people "specialize" in it and create monstrous abomination applications way larger than the tool is fit to sustain. It becomes a rat maze of gotchas and obscure tricks, and nobody but the original creator really knows what's going on.