quepy icon indicating copy to clipboard operation
quepy copied to clipboard

support for sql_92

Open naveenkumarmarri opened this issue 9 years ago • 3 comments

Hi,

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

naveenkumarmarri avatar Feb 13 '16 16:02 naveenkumarmarri

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!

rafacarrascosa avatar Mar 16 '16 13:03 rafacarrascosa

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.

chrisspen avatar Apr 16 '17 03:04 chrisspen

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.

akanimax avatar Sep 18 '17 07:09 akanimax