System, method, and computer program to generate platform and database agnostic queries

A system for generating platform and database agnostic queries for reducing application development and testing time of an application, the system comprising:

• a processor;
• and
• a memory operatively connected to the processor via a communication interface, the memory storing computer readable instructions, when executed, causes the processor to:
• implement an object relational model to build a system as a query generator, wherein the query generator is written in a preconfigured language;
• cause the query generator to:
• receive a configuration file that includes instructions to perform certain operations;
• interpret the configuration file;
• invoke, in response to interpreting the configuration file, a predefined application programming interface (API);
• and
• automatically generate, in response to invoking the API, a set of platform and database agnostic queries,
• wherein in generating the set of platform and database agnostic queries, the system is further configured to:
• detect whether the application is undergoing target database changes;
• generate, in response to detecting, nested queries, conditional statements, looping statements, common table expression, temporary table, and inline queries based on calling corresponding API;
• and
• dynamically generate target database supported stored procedures based on the nested queries, the conditional statements, the looping statements, the common table expression, the temporary table, and the inline queries.

A non-transitory computer readable medium configured to store instructions for generating platform and database agnostic queries for reducing application development and testing time of an application, the instructions, when executed, cause a processor to perform the following:

• implementing an object relational model to build a system as a query generator, wherein the query generator is written in a preconfigured language;
• causing the query generator to:
• receive a configuration file that includes instructions to perform certain operations;
• interpret the configuration file;
• invoke, in response to interpreting the configuration file, a predefined application programming interface (API);
• and
• automatically generate, in response to invoking the API, a set of platform and database agnostic queries,
• wherein in generating the set of platform and database agnostic queries, the instructions, when executed, further cause the processor to perform the following:
• detecting whether the application is undergoing target database changes;
• generating, in response to detecting, nested queries, conditional statements, looping statements, common table expression, temporary table, and inline queries based on calling corresponding API;
• and
• dynamically generating target database supported stored procedures based on the nested queries, the conditional statements, the looping statements, the common table expression, the temporary table, and the inline queries.