Live data from Hacker News

Show HN: Natural Language to SQL "Text-to-SQL" API

dataherald.com

21–30 of 41 posts

Re: Show HN: Natural Language to SQL "Text-to-SQL" API

#21

Can I trust the generated output SQL? I want to turn something like this into a frontend for my customers to use.

Hey man, I'm building something in this area, but focused on building specific functions on an iterative basis, skim through the video here https://v2.connectedflow.app/ , is this something that you'd use? (Mind you, we're 2 weeks into it)

Re: Show HN: Natural Language to SQL "Text-to-SQL" API

#22
> 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 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
post #22

> 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…

This is a good point and one that we’ve grappled with a lot. My point of view after working on 30+ company deployments is that it depends on the use case. Here’s an example: you have a very analytical BizOps lead at a mid market company. He/she is smart, knows data, can do pivot tables, the whole shabang. But every time they need to get data that isn’t in the BI tool they issue a jira ticket for the data analyst to process / fetch because they don’t know SQL well enough.

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

#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!!!!!!!!!!!!!

While the agent does execute the query to recover from errors, the SQLalchemy call execution is limited to a few rows only so if the server is locked there is probably something else going on ;)

Re: Show HN: Natural Language to SQL "Text-to-SQL" API

#28
How does someone take structured data from a database and turn it into unstructured data for an LLM? I know RAG is a thing but they talk in terms of documents not tables and fields.

Could 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

#29
Hi 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?

Re: Show HN: Natural Language to SQL "Text-to-SQL" API

#30

Hi 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?

Anuj[at]dataherald.com
Post reply on HN