Context-sensitive data retrieval and conversion

A system comprising:

• one or more hardware processors;
• and
• one or more one or more non-transitory computer-readable media storing instructions, which when executed by the one or more hardware processors, cause execution of operations comprising:
• receiving a request to retrieve data from a data repository in a first data format;
• wherein a first subset of a plurality of records in the data repository comprises a first subset of the data in the first data format,
• wherein a second subset of the plurality of records comprises a second subset of the data in a second data format that is different from the first data format;
• determining, based on the request, a first context-sensitive operation for converting at least the second subset of data to the first data format;
• transmitting, to the data repository, a query comprising at least one aggregation clause associated with the first context-sensitive operation;
• receiving, responsive to the query, a plurality of results aggregated according to the at least one aggregation clause,
• wherein a first result in the plurality of results comprises first aggregated data, from the first subset of the plurality of records, in the first data format, and
• wherein a second result in the plurality of results comprises second aggregated data, from the second subset of the plurality of records, in the second data format;
• converting, using the first context-sensitive operation, the second aggregated data from the
• second data format to the first data format to obtain first converted aggregated data;
• and
• generating a response to the request, based on the first aggregated data and the first converted aggregated data.

A method comprising:

• receiving a request to retrieve data from a data repository in a first data format;
• wherein a first subset of a plurality of records in the data repository comprises a first subset of the data in the first data format,
• wherein a second subset of the plurality of records comprises a second subset of the data in a second data format that is different from the first data format;
• determining, based on the request, a first context-sensitive operation for converting at least the second subset of data to the first data format;
• transmitting, to the data repository, a query comprising at least one aggregation clause associated with the first context-sensitive operation;
• receiving, responsive to the query, a plurality of results aggregated according to the at least one aggregation clause,
• wherein a first result in the plurality of results comprises first aggregated data, from the first subset of the plurality of records, in the first data format, and
• wherein a second result in the plurality of results comprises second aggregated data, from the second subset of the plurality of records, in the second data format;
• converting, using the first context-sensitive operation, the second aggregated data from the second data format to the first data format to obtain first converted aggregated data;
• and
• generating a response to the request, based on the first aggregated data and the first converted aggregated data,
• wherein the method is performed by at least one device comprising a hardware processor.