System and method for conversion of text to structured query language

A system for conversion of natural language text to a structured query language query, the system comprising one or more processing units and a data memory, the data memory comprising instructions for the one or more processing units to execute:

• an input module to receive a natural language question;
• a schema module to link schema to the received natural language question using a machine learning model, wherein generation of the machine learning model comprises:
• determining or predicting one or more branching points each representing deviations of generated tokens from ground truth;
• and
• performing a corrective action to replace generated tokens at the branching points;
• a translation module to generate a structured query language query using a trained large language model, the large language model taking as input the natural language question and the schema linked to the received natural language question;
• and
• an output module to output the structured query language query.

Non-transitory computer-readable medium storing instructions that, when executed by one or more processing units, cause the one or more processing units to perform operations comprising:

• receiving a natural language question;
• linking schema to the received natural language question using a machine learning model, wherein generation of the machine learning model comprises:
• determining or predicting one or more branching points each representing deviations of generated tokens from ground truth;
• and
• performing a corrective action to replace generated tokens at the branching points;
• generating a structured query language query using a trained large language model, the large language model taking as input the natural language question and the schema linked to the received natural language question;
• and
• outputting the structured query language query.