At the same time, I'm constantly amazed at how accessible LLMs have made automating things with Python. I'm seeing more non-SDEs describe what they want to do and then iterate on a solution with the LLM.
So I see more happening in this space, but it's a little more deterministic and a little less abstracted than the current products are headed.
I also see Gitlab or GitHub dabbling in this area. At some point you need to deploy the code. GitHub actions, workspaces, and pages are not that far off from a product that could cater to this need.
RAG is just an LLM plus regular procedural code acting on the LLM output. So are "reasoning" agents, because the reasoning is done via LLM predictions. "Agents" are just RAG applications that have access to your screen, keyboard, and mouse. It's LLMs all the way down.