Dynamic pivot implementation using object aggregation

A system comprising:

• one or more hardware processors of a machine;
• and
• at least one memory storing instructions that, when executed by the one or more hardware processors, cause the system to perform operations comprising:
• receiving a pivot query specifying a pivot column for dynamically determining a pivot value in a dynamic pivot operation, the dynamic pivot operation comprising specifying a distinct pivot value dynamically at runtime;
• identifying, in the pivot query, a subquery indicating dynamic determination of the pivot value;
• based on identifying the subquery indicating the dynamic determination of the pivot value, specifying the distinct pivot value for the pivot column at the runtime by executing the subquery, the executing of the subquery comprising transmitting a query to a data store to obtain the distinct pivot value for the pivot column;
• and
• performing the dynamic pivot operation using the distinct pivot value for the pivot column.

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• receiving a pivot query specifying a pivot column for dynamically determining a pivot value in a dynamic pivot operation, the dynamic pivot operation comprising specifying a distinct pivot value dynamically at runtime;
• identifying, in the pivot query, a subquery indicating dynamic determination of the pivot value;
• based on identifying the subquery indicating the dynamic determination of the pivot value, specifying the distinct pivot value for the pivot column at the runtime by executing the subquery, the executing of the subquery comprising transmitting a query to a data store to obtain the distinct pivot value for the pivot column;
• and
• performing the dynamic pivot operation using the distinct pivot value for the pivot column.