search

machinalis / quepy

A python framework to transform natural language questions to queries in a database query language.
Other
1.25k stars 296 forks source link

support for sql_92 #32

Open naveenkumarmarri opened 8 years ago

naveenkumarmarri commented 8 years ago

Hi,

Is there any support for legacy sql systems like mysql and oracle

rafacarrascosa commented 8 years ago

Hi, sorry for the delay, it is just that I'm on a 1bit/sec connection and this page has just loaded since I opened it on Feb 13. Not. I'm joking. Sorry for the delay.

Officially: No, Quepy translates to SPARQL and MQL (which is obsolete since Freebase went down). You might have some luck getting a SPARQL -> SQL translator, there are a few projects that do this.

Cheers!

chrisspen commented 7 years ago

This is unfortunate. I'm also interested in SQL support, since that's what the vast majority of production databases use, and translating a production SQL database to a triple-store so you can use SPARQL isn't feasible. As far as I know, there is no such thing as a "SPARQL -> SQL translator". We're not talking about querying a triple store stored in a SQL database. We're talking about querying an arbitrary non-triple based SQL schema, which is not translatable from SPARQL.

akanimax commented 6 years ago

I have been looking for a natural language to sql converter and quepy is the closest what I could find. I am actually planning to generate some synthetic data for training a Deep learning network for Natural Language 2 SQL conversion. I found this dataset: https://github.com/salesforce/WikiSQL Unfortunately, that is very little data. I am currently using quepy in sparql mode and will later worry about translating those queries into sql. Since this issue has not been closed, I thought, I'd ask around for other options and views.