Ask HN: Anyone struggling to get value out of coding LLMs?

Re:Ask HN: Anyone struggling to get value out of coding LLMs? by daveguy on Monday May 26, 2025 @11:20AM (#44098312)

> I just rewrote 300ish advanced PostgreSQL queries to mysql queries.

Translation from one set of tokens to another is exactly the primary use case of LLMs. This is exactly what it should be good at. Developing new queries, much less so. Translation from one set of database queries to another was already very well defined and well covered before LLMs came about.

[ Parent | on HN ]

Re:Ask HN: Anyone struggling to get value out of coding LLMs? by skydhash on Monday May 26, 2025 @03:52PM (#44101030)

Also, both are formal grammar so if you really wanted to create a 1:1 translator, it's possible to do so (see virtual machines). But it's not as useful per se as no one really switch databases on a whim. If you really want to do so, you want to do it correctly.

[ Parent | on HN ]

Re:Ask HN: Anyone struggling to get value out of coding LLMs? by theappsecguy on Tuesday May 27, 2025 @09:52AM (#44107028)

I mean, using a good ORM with DB adapter options could achieve this in minutes. Sure, LLM has utility here for raw queries, hardly "replace SWEs" type of utility though

[ Parent | on HN ]

Re:Ask HN: Anyone struggling to get value out of coding LLMs? by DonHopkins on Tuesday May 27, 2025 @11:22AM (#44107840)

A good reason to have "300ish advanced PostgreSQL queries" is because an "ORM with DB adapter" is inadequate for your requirements.

[ Parent | on HN ]