LLMs currently can generate a few thousand lines of coherent code but they cannot write a cohesive large scale code base.
But LLMs are very good at writing SQL and Cypher queries that I would spend hours or days figuring out how to write.
Agreed.
I find it interesting that LLMs seem pretty good at spitting out SQL that works well enough. But on the other hand LLMs seem pretty awful at working with CSS. I wonder if this is due to a difference in the amount of training data available for SQL vs CSS, or is this because CSS is a finicky pain in the ass when compared to SQL.
There should be a insane amount of CSS on the web but CSS output is primarily visual so I think that makes it hard for a text only model to generate.