I believe this aphorism applies to programming languages, "everything should be as simple as it can be, but not simpler". And at the risk of not answering the question, the reality is that no one language would ever be sufficient because a programming language is a tool, not a solution. And different jobs/goals require different tools. Therefore, to paraphrase from Malcom Gladwell, there is no such thing as the perfect programming language for non-programmers, only the perfect programming languages.
From there I'd imagine the best thing we can do is discuss features/tools that are used today that would be good for non-programmers. As many commenters have suggested, this will probably appear like the existing suite of tools that non-programmers use.
First, maybe an interactive graphical component that allows a users to define the flow of data. Something like Visio to allow users to draw data & input/output, mixed with a component like MSAccess to define the data model. Then a natural language tool that would take normal language and apply rules on the data (Hypercard). Finally, a visual component (like Excel) to validate that the data is correct and potentially generate reports for other non-programmers.