News for hackers. Stuff that matters.
Re:Text2SQL is dead – long live text2SQL by shortrounddev2 on Tuesday October 28, 2025 @11:34AM (#45734235)
I've always found it odd that most databases don't expose a kind of query bytecode API that SQL can be converted to. It would allow more kinds of languages, different SQL dialects, compile-time optimizations, and perhaps ORM could be compiled directly into your target database spec. Would reduce the amount of string operations by client code, at least
Re:Text2SQL is dead – long live text2SQL by exagolo on Tuesday October 28, 2025 @01:00PM (#45735488)
For translation between dialects, you could use projects such as SQLGlot. The advantage of SQL is the standardization over many decades (yes, I know that it's still a mess with the different dialects).
Re:Text2SQL is dead – long live text2SQL by jinjin2 on Tuesday October 28, 2025 @02:03PM (#45736497)
SQLGlot is amazing. In many ways it helps erase the differences and bridge between dialects. It is so useful for moving complex queries between platforms.
Re:Text2SQL is dead – long live text2SQL by exagolo on Wednesday October 29, 2025 @10:28AM (#45747299)
Agreed, and it's an amazingly well-maintained GitHub repo: https://github.com/tobymao/sqlglot

Big kudos to Toby and the team.