Re:Ben Forta – How to Generate SQL Statements with ChatGPT
by getmeinrn on Wednesday July 12, 2023 @01:28PM
(#36698287)
You send the produced query through a parser and a validator. The parser ensures it is syntactically correct, the validator ensures it is only accessing allowed data.
[ Parent
| on HN ]
Re:Ben Forta – How to Generate SQL Statements with ChatGPT
by jmuguy on Wednesday July 12, 2023 @01:30PM
(#36698321)
The SQL it produced for my coworkers ran without error - it just produced undesired results.
Re:Ben Forta – How to Generate SQL Statements with ChatGPT
by getmeinrn on Wednesday July 12, 2023 @01:38PM
(#36698496)
It sounds like your concern is that an LLM is not capable of understanding an english explanation of the query and producing the correct query. I personally have not had many issues here, and the time saved by tweaking a generated query is larger than writing the query myself from scratch. And LLMs will only improve so that these tweaks require less time.