And I actually think the level of capability you're talking about is within closer reach than most people realize. Certainly it's much easier now than it was even 10 years ago. Probably not something that a non-programmer can accomplish on day 1, but I'm not sure there's many crafts that can be learned that quickly.
- script without a main function
- to personal or ad hoc codebase for non-tech workplace
- to packaged code to cope with namespaces + type hints + general best practices
- to code that reads like good code from the major open source project
is long, but the slope is easy. There are no discontinuities. Basically anyone who can use Python to glue together networkx/sklearn etc. can eventually write software tools that are useful and stable enough to distribute.