News for hackers. Stuff that matters.

fkyimeanit

Re:Getting AI to write good SQL on Friday May 16, 2025 @11:35PM (#44011846)
"Text to SQL", "text to regex", "text to shell", etc. will never fundamentally work because the reason we have computer languages is to express specific requirements with no ambiguity.

With an AI prompt you'll have to do the same thing, just more verbosely.

You will have to do what every programmer hates, write a full formal specification in English.

Re:Getting AI to write good SQL on Friday May 16, 2025 @11:28PM (#44011821)
Because the testing pipeline was generated by AI, and code-reviewed by AI, reading a PR description generated by AI.
Re:Getting AI to write good SQL on Friday May 16, 2025 @11:24PM (#44011802)
>you get the added benefit of writing queries in JSON instead of raw SQL

You should have written your comment in JSON instead of raw English.