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
[ Parent
| on HN ]
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.