Microsoft Power Apps is doing a lot of work to bridge the gap between no-code business/functional analysts who identify solutions and developers who can build the solutions. Tools like Canvas Apps, Model-Driven Apps, Power Automate/Flow, and to an extent the configuration approach to building Portals via data in table rows, mean that you can do a lot heavy lifting just using an MS interface, as with Excel (good comments on that in this thread). There is of course space and need for custom script everywhere, but I think the Scratch mentality underlies the strategy.
Latest Answers