Live data from Hacker News

Show HN: Dataherald AI – Natural Language to SQL Engine

github.com

31–40 of 108 posts

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#31

How is this approach different from Nalir? https://dl.acm.org/doi/10.1145/2588555.2594519

In this demonstration, we show that NaLIR, while far from being able to pass the Turing test

2014, so it (and previous similar projects) are not going to be able to compete with contemporary LLMs.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#32

How is this approach different from Nalir? https://dl.acm.org/doi/10.1145/2588555.2594519

In this demonstration, we show that NaLIR, while far from being able to pass the Turing test 2014, so it (and previous similar projects) are not going to be able to compete with contemporary LLMs.

yes, exactly. recent advancements in LLMs have changed the game entirely

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#33
Not to dismiss the effort here, but wondering if this should go even further than bridging natural language to SQL. With recent work on LLMs showing promising capabilities in handling complex data structures, maybe the real play is to cut out the SQL altogether. Direct interaction with LLM-optimized data stores could yield more efficient, flexible, and fine-tuned results, eliminating the translational losses that might occur in the NL-to-SQL paradigm.

Like instead of shoehorning LLMs into old paradigms, why not conceive data storage systems inherently designed for LLM interfacing?

There's a latent inefficiency in using SQL as a bridge. It feels like trying to fit a new narrative into an old framework

And yes, rethinking database architectures from the ground up is daunting and demands more background in storage systems but given where machine learning and data interaction are heading, maybe we should consider it.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#34
When I look at all the LLM SQL tools, I think: what a cheap and accessible way to get the wrong answers.

SQL is easy. Knowledge management is hard. Does the LLM know that there was a bug in June that changed the data? Does it know that this one column is improperly named and confusing? Does it know that you recently released a mobile app the data from which is in a different table?

No, of course not, those things are never explicitly documented and so are invisible to an LLM.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#35

When I look at all the LLM SQL tools, I think: what a cheap and accessible way to get the wrong answers. SQL is easy. Knowledge management is hard. Does the LLM know that there was a bug in June that changed the data? Does it know that this one column is improperly named and confusing? Does it know that you recently released a mobile app the data from which is in a different table? No, of course not, those things are…

A less sarcastic take:

This only works if you have perfect data engineering. But if you have perfect data engineering, point and click tools like Looker will work too.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#36

Not to dismiss the effort here, but wondering if this should go even further than bridging natural language to SQL. With recent work on LLMs showing promising capabilities in handling complex data structures, maybe the real play is to cut out the SQL altogether. Direct interaction with LLM-optimized data stores could yield more efficient, flexible, and fine-tuned results, eliminating the translational losses that mig…

Curious what recent work you are referencing? Lots of new so I don’t want to miss things. In my experimentation I basically wrote off LLMs from doing any math directly. That includes aggregations or precise calculations. I’ve been playing with sql generation and allowing the db to do its thing.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#37

Not to dismiss the effort here, but wondering if this should go even further than bridging natural language to SQL. With recent work on LLMs showing promising capabilities in handling complex data structures, maybe the real play is to cut out the SQL altogether. Direct interaction with LLM-optimized data stores could yield more efficient, flexible, and fine-tuned results, eliminating the translational losses that mig…

SQL is definitely an old technology. However it is still the main language for interfacing with structured data, even for newer tools like Clickhouse. Down the road it is conceivable that it will be replaced with something else, but the cost of migrating existing data to those will be so high I imagine no-one will take the step to proactively move.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#38

When I look at all the LLM SQL tools, I think: what a cheap and accessible way to get the wrong answers. SQL is easy. Knowledge management is hard. Does the LLM know that there was a bug in June that changed the data? Does it know that this one column is improperly named and confusing? Does it know that you recently released a mobile app the data from which is in a different table? No, of course not, those things are…

A less sarcastic take: This only works if you have perfect data engineering. But if you have perfect data engineering, point and click tools like Looker will work too.

Sort of. Having perfect data engineering is a requirement if you want to connect an LLM straight to your data warehouse. For real world scenarios, you need a way to add context over time (including examples of how to answer questions from messy data). The same way a new team member would need to be on-boarded the tool needs to learn the context of the data and business logic, store it under supervision from an admin and be able to retrieve it in generating the SQL.

Re: Show HN: Dataherald AI – Natural Language to SQL Engine

#39
post #37

Not to dismiss the effort here, but wondering if this should go even further than bridging natural language to SQL. With recent work on LLMs showing promising capabilities in handling complex data structures, maybe the real play is to cut out the SQL altogether. Direct interaction with LLM-optimized data stores could yield more efficient, flexible, and fine-tuned results, eliminating the translational losses that mig…

SQL is definitely an old technology. However it is still the main language for interfacing with structured data, even for newer tools like Clickhouse. Down the road it is conceivable that it will be replaced with something else, but the cost of migrating existing data to those will be so high I imagine no-one will take the step to proactively move.

SQL makes the most sense if humans are going to be programming deterministically, but if we're talking about natural language input I can't help but think that compiling natural language to SQL feels a little shortsighted as a long term strategy.

Surely it makes sense for a MVP, but I'm curious about how much we're potentially forfeiting in terms of innovation by anchoring so deeply to it with all the possibilities afforded by generative AI. In holding onto SQL, might we be forestalling the development or adoption of a more evolved language? With Dataherald's proposition, how do you envision maintaining that cutting edge, ensuring you're not just prolonging the lifespan of a fading tech, but genuinely pushing the envelope forward?

I suppose one intriguing possibility in my mind is that Dataherald could serve as a bridge or runtime. As you continue to develop and refine the tool, do you see a future where it might support more abstract querying languages or even emerging data interaction paradigms? This could potentially mitigate some transition pains when the tech ecosystem eventually shifts.

Post reply on HN