Getting AI to write good SQL

Re:Getting AI to write good SQL by hosel on Friday May 16, 2025 @09:00PM (#44011204)

Really? In my experience it’s been pretty good (using Pydantic)! I read over before I execute it, but it’s never done anything malicious.

[ Parent | on HN ]

Re:Getting AI to write good SQL by rectang on Friday May 16, 2025 @09:10PM (#44011259)

I don't trust myself to craft a prompt in natural language which completely specifies my intent as codified with the precision of a programming language.

I also tend to turn to AI for advising me on difficult use cases, and most of the time it's for production code rather than one-offs. The easy cases, I just write myself because it's more mental effort to review code for subtle errors than it is to write it.

[ Parent | on HN ]

Re:Getting AI to write good SQL by yahoozoo on Saturday May 17, 2025 @07:16AM (#44013480)

What is the relevance of Pydantic with SQL?

[ Parent | on HN ]