System and method for database command query migration

A computing system comprising:

• a memory;
• and
• a processor, operatively coupled to the memory, configured to:
• process a request to migrate a database command query in a source dialect to a target dialect,
• parse the request for the database command query in the source dialect, to obtain an example of the target dialect from a plurality of examples of the target dialect by processing the database command query in the source dialect using retrieval-augmented generation (RAG) with the plurality of examples of the target dialect,
• obtain an instruction from a plurality of instructions for instructing a generative artificial intelligence (AI) model to translate the database command query in the source dialect to the target dialect by processing the database command query in the source dialect using retrieval-augmented generation (RAG) with the plurality of instructions, wherein the plurality of instructions formulates the translation as an incremental error correction,
• generate a prompt for the generative AI model using the database command query in the source dialect, the example, and the instruction, wherein the prompt instructs the generative AI model to treat the database command query as an erroneous query in the target dialect, and
• generate a candidate database command query by prompting the generative AI model with the prompt to migrate the database command query in the source dialect to the target dialect, wherein generating the candidate database command query comprises iteratively correcting errors of the database command query with respect to the target dialect.

A non-transitory computer readable medium having a plurality of instructions stored thereon which, when executed by a processor, cause the processor to:

• process a request to migrate a database command query in a source dialect to a target dialect;
• parse the request for the database command query in the source dialect;
• obtaining an example of the target dialect from a plurality of examples of the target dialect by processing the database command query in the source dialect using retrieval-augmented generation (RAG) with the plurality of examples of the target dialect;
• obtain an instruction from a plurality of instructions for instructing a generative artificial intelligence (AI) model to translate the database command query in the source dialect to the target dialect by processing the database command query in the source dialect using retrieval-augmented generation (RAG) with the plurality of instructions, wherein the plurality of instructions formulates the translation as an incremental error correction;
• generate a prompt for the generative AI model using the database command query in the source dialect, the example, and the instruction, wherein the prompt instructs the generative AI model to treat the database command query as an erroneous query in the target dialect;
• generate a candidate database command query by prompting the generative AI model with the prompt to migrate the database command query in the source dialect to the target dialect, wherein generating the candidate database command query comprises iteratively correcting errors of the database command query with respect to the target dialect;
• verify a candidate database command query in the target dialect generated by the generative AI model by processing the candidate database command query in the target dialect for semantic similarity to the database command query in the source dialect;
• and
• perform an operation on a database using the candidate database command query in the target dialect.