1. A system, comprising: a memory that stores computer executable components; and a microprocessor that executes the following computer executable components stored in the memory: an interface component that receives from a structured query language (SQL) reporting platform frontend an SQL query and transmits a translated query to an SQL backend that operates on a data table, wherein the SQL query is a non-nested group by query with multiple instances of a first scoped operator and multiple instances of a second scoped operator, and the data table includes a nested field; and a translation component that translates the SQL query to the translated SQL query, wherein the translated SQL query is a nested query, and the translation component replaces the multiple instances of the first scoped operator with a first unique alias and the multiple instances of the second scoped operator with a second unique alias in the translated SQL query.