System and Method for Generative Artificial Intelligence (AI) Model-based Resolution of Ambiguities in Natural Language Query-to-Database Command Query Conversion

A computing system comprising:

• a memory;
• and
• a processor configured to process a natural language query concerning data stored within an electronic database,
• to convert the natural language query into a database command query using a generative AI model,
• to execute the database command query on the electronic database,
• to provide a result associated with executing the database command query to a user,
• to generate a flagged ambiguity by flagging an ambiguity associated with the natural language query using the generative AI model,
• generate, using the generative AI model, a targeted clarifying question for the flagged ambiguity based on the natural language query, the database command query, and the flagged ambiguity;
• prompt a user with the targeted clarifying query for user clarification concerning the flagged ambiguity;
• receive user feedback associated with the targeted clarifying question;
• and
• to revise the database command query by processing the natural language query, the database command query, the result, and the flagged ambiguity using the generative AI model.

A computer program product residing on a computer readable medium having a plurality of instructions stored thereon which, when executed by a processor, cause the processor to perform operations comprising:

• processing a natural language query concerning data stored within an electronic database;
• converting the natural language query into a database command query using a generative AI model;
• executing the database command query on the electronic database;
• providing a result associated with executing the database command query to a user;
• generating a flagged ambiguity by flagging an ambiguity associated with the natural language query using the generative AI model;
• generating, using the generative AI model, a targeted clarifying question for the flagged ambiguity based on the natural language query, the database command query, and the flagged ambiguity;
• prompting a user with the targeted clarifying query for user clarification concerning the flagged ambiguity;
• receiving user feedback associated with the targeted clarifying question;
• and
• revising the database command query by processing the natural language query, the database command query, the result, the flagged ambiguity, and the user feedback using the generative AI model.