News for hackers. Stuff that matters.
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.
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.