Pre-generation of structured query language (SQL) from application programming interface (API) defined query systems

摘要

A method is provided for receiving source code that includes an application programming interface (API) defined query written to communicate with an API. The API is configured to provide access to an object relational model (ORM) for converting, during execution of the source code, the API defined query into a dynamic structured query language (SQL) query comprising SQL statements. The method also includes generating a static SQL query that includes SQL statements. The static SQL query is generated in response to the ORM and to the API, by a computer, prior to the source code being executed.