System and method for code automation

A method for computer application code automation, the method comprising:

• displaying a first electronic user interface screen presented by a code automation computer server for accepting user input for generating a Structured Query Language (SQL) query, the user input comprising a plurality of SQL tokens;
• receiving, via an electronic user interface presented by the code automation computer server, a first partial portion of the user input for generating the SQL query;
• executing, via a processor associated with the code automation computer server, computer executable instructions for:
• performing a check to identify a possible error or a query performance problem based on the first partial portion of the user input,
• displaying a warning screen when the first partial portion of the user input is associated with a possible error or a query performance problem;
• and
• displaying a second electronic user interface screen for accepting a second partial portion of the user input comprising the plurality of SQL tokens, wherein the second electronic user interface screen is displayed after displaying the warning screen;
• and
• automatically incorporating the generated SQL query into the computer application code and storing the computer application code in a computer readable memory.

A non-transitory computer readable medium having stored thereon computer executable instructions that, when executed by a processor, cause a computer system to perform computer application code automation, by performing the steps of:

• displaying a first electronic user interface screen presented by a code automation computer server for accepting user input for generating a Structured Query Language (SQL) query, the user input comprising a plurality of SQL tokens;
• receiving, via an electronic user interface presented by the code automation computer server, a first partial portion of the user input for generating the SQL query;
• executing, via a processor associated with the code automation computer server, computer executable instructions for:
• performing a check to identify a possible error or a query performance problem based on the first partial portion of the user input,
• displaying a warning screen when the first partial portion of the user input is associated with a possible error or a query performance problem, and
• displaying a second electronic user interface screen for accepting a second partial portion of the user input comprising the plurality of SQL tokens, wherein the second electronic user interface screen is displayed after displaying the warning screen;
• and
• automatically incorporating the generated SQL query into the computer application code.