Execution environment agnostic federated queries

A method for execution environment agnostic federated queries comprising:

• obtaining, by a device, configuration information which includes configurations for multiple execution environments,
• wherein the configuration information indicates sets of execution code associated with the multiple execution environments;
• obtaining, by the device, a federated query for a set of data associated with multiple data sources;
• generating, by the device and based on the federated query and the configuration information, an abstract syntax tree indicating relationships between statements included in the federated query;
• identifying, by the device and based on the abstract syntax tree, one or more homogeneous statements in the federated query, wherein the one or more homogeneous statements are associated with respective data sources of the multiple data sources;
• registering, by the device and in a local database, one or more functions for respective homogeneous statements of the one or more homogeneous statements,
• wherein each function, of the one or more functions, indicates information that enables one or more operations to be performed as indicated by a homogeneous statement associated with that function, and
• wherein each function includes the sets of execution code associated with the multiple execution environments;
• generating, by the device and based on the federated query, a local query for the local database using the one or more functions, wherein the local query calls a subset of execution code, from the sets of execution code associated with the multiple execution environments, that is associated with an execution environment of the multiple execution environments;
• and
• executing, by the device and via the execution environment, the local query to perform the federated query for the set of data while the one or more functions are capable of being executed via the multiple execution environments.

A non-transitory computer-readable medium storing a set of instructions, the set of instructions comprising:

• one or more instructions that, when executed by one or more processors of a device, cause the device to:
• obtain configuration information which includes configurations for multiple execution environments,
• wherein the configuration information indicates sets of execution code association with the multiple execution environments;
• obtain a federated structured query language (SQL) query requesting a set of data from multiple data sources;
• parse, based on the configuration information, the federated SQL query to generate an abstract syntax tree indicating relationships between SQL statements included in the federated SQL query;
• identify, based on the abstract syntax tree, one or more homogeneous SQL statements in the federated SQL query, wherein the one or more homogeneous SQL statements request one or more subsets of data, of the set of data, from respective data sources of the multiple data sources;
• generate, based on executing the one or more homogeneous SQL statements, one or more functions for respective homogeneous SQL statements of the one or more homogeneous SQL statements,
• wherein each function, of the one or more functions, enables the one or more subsets of data to be accessible via a virtual table in a local database, and
• wherein each function includes the sets of execution code associated with the multiple execution environments;
• generate, based on the federated SQL query, a local query to the local database using the one or more functions, wherein the local query accesses a subset of execution code, from the sets of execution code associated with the multiple execution environments, that is associated with an execution environment;
• and
• execute, via the execution environment, the local query to obtain the set of data while the one or more functions are capable of being executed via the multiple execution environments.