With the latest LLMs/codex improvements, the quality of SQL generation has improved but how do folks feel about the idea in-general?
- Is it an overkill?
- Will it be helpful such generators act as assistants?
Ha ha.. Back end devs be laughing all day.<p>I mean on super small datasets it might be fine, but na, it's not practical.<p>SQL is more then just `select * from x where y = z`. The generator would have to understand normalisation, de-normalisation, the indexes in play, and the effect ordering the where clauses has on retrieval. The generator would have to understand eager loading and returning after writes optimisation.<p>Don't get me started on transactions and paging.<p>I mean if a LLM can do that.. Well then we have to grab our hats and go home.