I've been a professional developer since I left university 11 years ago. Back then, people were asking "what will programming look like in 10 years". And in those 10 years, programming hasn't changed much. Game development is still largely done in C++; application development may have shifted to .NET/Java a lot more, and there is so much more focus on web-based applications, but the actual coding is very similar. We haven't all moved to using visual tools instead of writing code, hell we still write raw SQL queries rather than have it all abstracted out of sight.
So I'd be pretty cautious about making any predictions of big changes in the next ten years.
If you are using .NET then you are unlikely to have a need for raw SQL queries.
Id say programming is changing quite a bit, especially in my field of scientific computing. Staticaly compiled libraries are quickly losing ground to specialized JIT compilers for various programming domains (lots of activity there in the python ecosystem). Language interop is becoming the norm, even for small projects.
I once believed in 'one language to rule them all', but now I think seemless interop is much more important for the future. In some contexts, functional semantics are great. In some, nothing but a pain in the ass. In some context, dynamic programming techniques are a ridiculous slowdown. In some, a very useful feature.
Rather than cramming that all into one language, which is never going to happen elegantly, id say its all about the interop. Python and .NET have the right idea here.