microsoft / IRNet

An algorithm for cross-domain NL2SQL
MIT License
264 stars 81 forks source link

How to convert sql to SemQL format to test IRNET for wikisql #40

Closed anshudaur closed 4 years ago

anshudaur commented 4 years ago

Hi All,

I am stuck at parsing sql query of wikisql to irnet sql format especially for "sql" key : for instance, WIKISQL -> "sql":{"sel":5,"conds":[[3,0,"SOUTH AUSTRALIA"]],"agg":0} IRNET SEMQL -> "sql": { "except": null, "from": { "conds": [], "table_units": [ [ "table_unit", 1 ] ] }, "groupBy": [], "having": [], "intersect": null, "limit": null, "orderBy": [], "select": [ false, [ [ 3, [ 0, [ 0, 0, false ], null ] ] ] ], "union": null, "where": [] } }

Any help is appreciated.

Thanks Anshu