I would love it if an AI could build what I’ve been banging my head against for over a year. How many lines of SQL can an LLM write and does it come up with the

I would love it if an AI could build what I’ve been banging my head against for over a year. How many lines of SQL can an LLM write and does it come up with the pipeline architecture all on its own? How does it incorporate subject matter experience to aggregate or transform the data? Like I said, I would love it if I didn’t have to worry about the nitty gritty stuff. But I have not seen that type of performance out of an LLM. Also I don’t get the comparison between LLMs and query optimizers which seem to be much more deterministic and logical about how they choose to build the query plan.