1. A non-transitory computer-readable medium having program code stored thereon, the program code executable by a processor to: receive a query filtered on an object of a hierarchical list of values and comprising a first filter value; generate an SQL script based on the first filter value and at least one ancestor value of the first filter value in the hierarchical list of values; and retrieve a data set associated with the query based on the SQL script; wherein generation of the SQL script comprises: determining that the object and the first filter value are associated with a same level of the hierarchical list of values; and determining a key of the first filter value, the key based on the at least one ancestor value of the first filter value, wherein a WHERE statement of the SQL script comprises the key.