[tomhallett]

I 100% agree. This is why I think that LLM's will help encourage better coding practices, not worse. The more that you can write "clean code" (things which are named correctly, follow the single responsibility pricinciple, don't violate the law of demeter, build the correct data-models/data-marts), then the easier it will be for LLM's to assist senior engineers in writing code/sql faster.

And if there is an interface given to people who will struggle to evaluate the correct-ness of something, ie: a Business Intelligence tool for people who don't know/care about the data model, then the question becomes "How can the tool facilitate getting the people who can verify the correctness of the sql/code do so in an efficient manner?" I'm thinking like a short-term pull-request, where the "code committer" is the LLM and the reviewer is a human. Said in another way: the chatbot is going in reverse, where chatgpt is asking the questions and the human gives the answers...... haha