I feel totally confident solving problems with PLs I wouldn't have touched with a ten-foot pole just a year back, due to AI.
Example: The legacy application I am currently maintaining and replacing is totally borked with piles of spagetti-code and shitty, amateurish or simply non-existent architecture. However, I do have to add logic to this already unmaintainable system so I often just push larger portions of that logic further down into the DB and SQL.
SQL _is_ turing complete, but actually developing applications using mostly or only SQL is reserved for very strange/special people still stuck in the 70ies mainframe era or something. Beyond some joins I would never do anything with this PL and move all more complex logic into the application layer.
But with AI writing SQL I feel confident to do such a thing. I _can_ understand what the code does and fix smaller mistakes the AI makes, but actually looking up the syntax and writing it myself would be a complete waste of time and energy to me. With AI absolutely not. It is strange using this PL I normally wouldn't and in this specific scenario it is a stop-gap for reasons unrelated to the tech-stack, but the AI puts out solid code and even corrects my SQL quick-hacks for commits I did myself.
For me the state of things right now is the following: Current AI is basically an API documentation you can talk to, with a premium expert attached. For all PLs that have enough documentation and demo-code available online and enough code-repos of functioning open-source projects for AIs to source information from, AI is a totally viable main programmer if you take your time to lead it well, hand-hold it along the way and double-check the code it generates and avoid any "vibe-coding" bullsh1t.
I would totally feel confident in taking on projects and tasks with APIs or PLs I haven't used yet but am interested in and consider wide-spread enough for AI to know well. I've actually considered doing something like that, like some Rust CLI project or something, just to learn the PL along the way.
And I expect all this AI progging to only improve even further, and quite quickly so.