Can I trust the generated output SQL? I want to turn something like this into a frontend for my customers to use.
Show HN: Natural Language to SQL "Text-to-SQL" API
21–30 of 41 posts
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#22This is actually an example of why I don't think LLM SQL generators are actually going to be that valuable to most companies. The biggest hurdle for people to get "value" from their data is rarely the SQL part - it's actually knowing what the question is trying to answer. When someone asks that question, do they mean the average rent of new listings from that month? Rent paid by all renters? All sizes and building types? These are all "right" answers, just to very different questions. And no amount of data dictionaries, dbt models, or other context can help narrow that down.
(Not trying to take anything away from this team, who have built a pretty well made product. I just think their approach doesn't quite get to the underlying business problem.)
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#23> what was the average rent in Los Angeles in May 2023? This is actually an example of why I don't think LLM SQL generators are actually going to be that valuable to most companies. The biggest hurdle for people to get "value" from their data is rarely the SQL part - it's actually knowing what the question is trying to answer. When someone asks that question, do they mean the average rent of new listings from that mo…
The dataherald engine is perfect. They are able to use natural language, admittedly with a few iterations, to get the cut of data that they seek. This cuts down hours, or even days from their inquiry.
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#24``` select * from dbo.bigdata ```
three rows down
FUCKING HELL, OUR SQL SERVER IS LOCKED UP!!!!!!!!!!!!!
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#25Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#26Do you keep customer query data? Curious about what data you retain of your customers.
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#27>tell me how much data I have in my largest table and show me all of the data ``` select * from dbo.bigdata ``` three rows down FUCKING HELL, OUR SQL SERVER IS LOCKED UP!!!!!!!!!!!!!
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#28Could the LLM derive that same California sales answer from just knowing the dataset, but not by writing sql?
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#29As a consultant, I’m considering this as part of an offering to a client. Was hoping to chat more about the security/privacy and operational model of the hosted vs open-source offerings. Who should I reach out to?
Re: Show HN: Natural Language to SQL "Text-to-SQL" API
#30Hi dataherald team. Firstly, congratulations on the launch. I’ve been in the data space for a while and know all the effort it must be to get this up and running. As a consultant, I’m considering this as part of an offering to a client. Was hoping to chat more about the security/privacy and operational model of the hosted vs open-source offerings. Who should I reach out to?