How to generate SQL queries which supports MSSQL instead of SQLite

ServiceNow / picard

PICARD - Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models. PICARD is a ServiceNow Research project that was started at Element AI.

https://arxiv.org/abs/2109.05093

Apache License 2.0

341 stars 122 forks source link

How to generate SQL queries which supports MSSQL instead of SQLite #99

Closed b4zyuvaraj closed 2 years ago

b4zyuvaraj commented 2 years ago

Hi @tscholak

I want to execute the SQL queries in MSSQL instead of SQLite. Is there any possibilities or configuration changes which generates the MSSQL queries?

Thanks Yuvaraj

tscholak commented 2 years ago

MSSQL is currently not supported. Numerous changes would be necessary to support MSSQL:

The idioms and grammar of MSSQL would need to be added to the PICARD parser,
The Spider databases and text-to-SQL data would need to be translated from SQLite to MSSQL,
The models would need to be retrained to produce MSSQL code instead of SQLite code.