Live data from Hacker News

Text-to-SQL is dead, long live text-to-SQL

exasol.com

51–52 of 52 posts

Re: Text-to-SQL is dead, long live text-to-SQL

#51
post #45

Earlier quoted context omitted.

> This is solving a problem few people have. They assume your table name, column names and relationships is confidential information. For most people such metadata is not confidential. For most businesses, it really really is. In general, people (businesses) are incredibly sensitive about any possibility of data leakage, even just the metadata. There are lots of companies who would pay for this, and they tend to have…

This would be a (small, granted) red flag for me about a company. As a data architect I work really hard to make sure our model is legible and obvious - the way which the model is adopted to our problem area is certainly a difficult problem that is valuable to have solved. But minor details of that schema should be extremely boring.

Like, I've never really been sure why people care about this so much. However, when I worked for a data observability company where we took in and did work on a lot of this metadata, it became apparent that lots of our customers cared.

Re: Text-to-SQL is dead, long live text-to-SQL

#52
post #27
post #19

Earlier quoted context omitted.

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).

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.

Agreed, and it's an amazingly well-maintained GitHub repo: https://github.com/tobymao/sqlglot

Big kudos to Toby and the team.

Post reply on HN