>Yes it can write SQL but does it understand the index strategy on the destination table or the consequences of running thousands of those queries a minute in a production database? No.

It does if you instruct it well enough.

We're still really early and companies are figuring out how to best use it. It's been 1 year since GPT4 was released. We didn't invent the lightbulb, electric motor, telephone, radio, refrigerators etc. until many years after the invention of electricity.

Right now, LLMs are very useful for many tasks. Over time, they'll continue to get more useful and inventions will be built on top of them.