In the medium term, knowing an easy programming language (something like Office macros, Python or ActionScript) will be increasingly common for many kinds of jobs (I have witnessed that trend in the finance world already, where traders and other people on the business side often know some C++ with smart pointers…), because the productivity advantage of being able to automate its job is so huge.

And in the long term, as you envision, zero-code programming will of course win. There will still be a need for “hardcore” developers, just like there is still a need for some developers to create and maintain operating systems.

In practice this evolution might not be that easy to see, and for instance there is already a huge number of people tagged as “developers” that are actually doing business tasks, think about the SAP consultants.

You mention DSL’s, and most Java/.Net API’s available can be considered as DSL’s expressed with the Object Oriented constructs; I am very curious to see how tools could enable non-technical people to combine arbitrary API’s together to build mashup applications.

For example, COBOL was designed so business people instead of programmers could build apps. Instead it just created a new class of programmers.
http://www.martinfowler.com/bliki/BusinessReadableDSL.html
The design of VisualBasic had similar intentions.

There are very few areas where it really works (like Spreadsheets mentioned in the Fowler article).

Perhaps one day, we’ll have components that can be put together like legos to create a program but, then again, some people are a lot better wtih legos than most too