Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Describe SQL using natural language, and execute against real data

news.ycombinator.com

Post reply on HN
Print view View original

11–20 of 37 posts

Re: Show HN: Describe SQL using natural language, and execute against real data

#11

Post by napoleond »

tillvz wrote: post #6

Hey that's very cool and works surprisingly well! At Veezoo ( http://www.veezoo.com ) we have been tackling this problem for over 5 years now. Under the hood we are using our own models. With GPT-3 we're a bit worried about the lack of fine-grained control needed for productive use-cases and obv. also lock in. Will try out against the same dataset and see how it compares!

Nice! Yeah I have no doubt that a specialized model could beat this general one, although I find the output from the general one to be uncanny at times. Would love to hear your expert opinion on how they compare!

Re: Show HN: Describe SQL using natural language, and execute against real data

#12

Post by napoleond »

i_like_apis wrote: post #5

This is pretty cool. I thought it was funny in that in the weather dataset that "NULL" comes in first for the win for some questions: > what is the all time rainiest city? > what are the top 5 most dry states? The query conversion is impressive!

The weather dataset has a bit of an unorthodox schema IMO, which gives the model more trouble than usual. That’s kind of the point of this demo, though: to what extent is generated SQL like this useful—despite its flaws—in the context of real-world datasets? Jury is still out :)

Re: Show HN: Describe SQL using natural language, and execute against real data

#13

Post by tluyben2 »

tillvz wrote: post #6

Hey that's very cool and works surprisingly well! At Veezoo ( http://www.veezoo.com ) we have been tackling this problem for over 5 years now. Under the hood we are using our own models. With GPT-3 we're a bit worried about the lack of fine-grained control needed for productive use-cases and obv. also lock in. Will try out against the same dataset and see how it compares!

Nice product, will give it a spin. For the banking market. Do you have an API exposed as well to feed questions and get (json) data? Our clients would definitely need it integrated fully.

Re: Show HN: Describe SQL using natural language, and execute against real data

#14

Post by mritchie712 »

tluyben2 wrote: post #13
tillvz wrote: post #6

Hey that's very cool and works surprisingly well! At Veezoo ( http://www.veezoo.com ) we have been tackling this problem for over 5 years now. Under the hood we are using our own models. With GPT-3 we're a bit worried about the lack of fine-grained control needed for productive use-cases and obv. also lock in. Will try out against the same dataset and see how it compares!

Nice product, will give it a spin. For the banking market. Do you have an API exposed as well to feed questions and get (json) data? Our clients would definitely need it integrated fully.

not OP, but this is exactly what ThoughtSpot Everywhere is for:

https://www.thoughtspot.com/everywhere

Re: Show HN: Describe SQL using natural language, and execute against real data

#16

Post by napoleond »

paulfitz wrote: post #15

For google-trends it translated "Is there anything cat-related that people are excited about?" to something very reasonable that worked (answer: popcat apparently). Nice!

Really? Wow, I would not have expected that to work. Might be one advantage of using this general model instead of a more specialized one.

Re: Show HN: Describe SQL using natural language, and execute against real data

#17

Post by cafed00d »

Wow, this is absolutely brilliant!

How can I extend this to use other datasets? There seem to be quite a few interesting publicly available datasets out there: https://console.cloud.google.com/marketplace/browse?filter=s...

and I'm wondering if: 1. Is there a paid-for version of your app/website where I can plug in a diff dataset? 2. Have you considered sharing the source code for others to recreate and plug in diff datasets? 3. Or, :sweat_smile:, perhaps this is as simple as adding new datasets to the drop-down menu? say, finance data / Bitcoin transactions data?

Regardless, really cool app!

Re: Show HN: Describe SQL using natural language, and execute against real data

#18

Post by tillvz »

tluyben2 wrote: post #13
tillvz wrote: post #6

Hey that's very cool and works surprisingly well! At Veezoo ( http://www.veezoo.com ) we have been tackling this problem for over 5 years now. Under the hood we are using our own models. With GPT-3 we're a bit worried about the lack of fine-grained control needed for productive use-cases and obv. also lock in. Will try out against the same dataset and see how it compares!

Nice product, will give it a spin. For the banking market. Do you have an API exposed as well to feed questions and get (json) data? Our clients would definitely need it integrated fully.

Currently we don't have such an API exposed. Main reason is the focus on offering a complete self-service analytics solution (i.e. offering next to the NL2SQL also important UI/UX components)

Still we have other ways of integrating it with other systems e.g. exporting to CRMs. Also on the branding side it's possible to have it in the companies corporate identity.

And just let me know if you wanna get a quick tour, happy to show you around :)!

Post reply on HN