Unified data access and querying

A system comprising:

• one or more processors;
• and
• one or more computer-readable memories coupled to the one or more processors and having instructions stored thereon that are executable by the one or more processors to perform operations comprising:
• obtaining, by a compound database, metadata from data sources to support querying the data sources to generate reports based on unified data manipulation over data from the data sources, wherein each data source of the data sources is of a respective data source type and associated with a different respective set of query execution capabilities from a plurality of query execution capabilities, wherein a query execution capability for a data source defines one or more data manipulation operations that are supported by the data source and a respective data source type;
• receiving a request, by the compound database and from a query panel, to generate a report that is associated with at least one data source, wherein the request includes a data model for the report including one or more data manipulation operations to be performed over data of the at least one data source, wherein at least one of the data manipulation operations is not natively supported by a data source of the at least one data source;
• and
• generating, as a generated query, a query based on the request to obtain data from the at least one data source to generate the report, wherein generating the query comprises:
• splitting the query based on a number of data sources of the at least one data source associated with the request to generate the report;
• transforming the query into at least one sub-queries corresponding to each of the at least one data source, wherein a sub-query is defined based on a data source type of a respective data source and a data manipulation operation that is included in the request, wherein at least one data manipulation operations of the one or more data manipulation operations included in the request is not-supported by a data source of the at least one data source associated with the request to generate the report;
• and
• generating the report based on executing the query through the compound database at the at least one data source.

A non-transitory, computer-readable medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations comprising:

• obtaining, by a compound database, metadata from data sources to support querying the data sources to generate reports based on unified data manipulation over data from the data sources, wherein each data source of the data sources is of a respective data source type and associated with a different respective set of query execution capabilities from a plurality of query execution capabilities, wherein a query execution capability for a data source defines one or more data manipulation operations that are supported by the data source and a respective data source type;
• receiving a request, by the compound database and from a query panel, to generate a report that is associated with at least one data source, wherein the request includes a data model for the report including one or more data manipulation operations to be performed over data of the at least one data source, wherein at least one of the data manipulation operations is not natively supported by a data source of the at least one data source;
• and
• generating, as a generated query, a query based on the request to obtain data from the at least one data source to generate the report, wherein generating the query comprises:
• splitting the query based on a number of data sources of the at least one data source associated with the request to generate the report;
• transforming the query into at least one sub-queries corresponding to each of the at least one data source, wherein a sub-query is defined based on a data source type of a respective data source and a data manipulation operation that is included in the request, wherein at least one data manipulation operations of the one or more data manipulation operations included in the request is not-supported by a data source of the at least one data source associated with the request to generate the report;
• and
• generating the report based on executing the query through the compound database at the at least one data source.