1. A system for using rules generated based on hierarchical structures for querying SQL-compatible databases, the system comprising: a storage device; and one or more processors in communication with the storage device, wherein the storage device has sets of instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform actions including: storing a hierarchical data structure at a data store, the hierarchical data structure including a plurality of nodes, each node of the plurality of nodes: being positioned at a level of a plurality of levels in the hierarchical data structure; representing an object of a plurality of objects; being connected to one or more other nodes in the hierarchical data structure, each of the one or more other nodes being positioned at a different level than the level at which the node is positioned; storing a predefined rule for each node of the plurality of nodes; for each node of multiple of the plurality of nodes: identifying a pointer identified for a parent node of the node using the hierarchical data structure; reading data from a memory location referenced by the pointer; identifying a rule for the parent node based on the read data; generating a generated rule for the node based on the rule for the parent node as added to the predefined rule for the node that did not previously account for the rule of the parent node; and storing the generated rule in a structured query language (SQL) format in association with an identifier of the node; detecting a change in the hierarchical data structure, the change comprising an addition or deletion of one or more nodes of the hierarchical data structure or a change in one or more connections between nodes of the hierarchical data structure; in response to detecting the change in the hierarchical data structure: identifying an affected node of the plurality of nodes, which is affected by the change in the hierarchical data structure; automatically generating an updated rule for the affected node based on a rule for the parent node as added to the predefined rule for the affected node that did not previously account for the rule of the parent node; wherein automatically updating comprises storing, by the one or more processors, the updated rule in the SQL format in association with the identifier of the affected node; compiling the updated rule to form a compiled SQL query; executing the compiled SQL query on an SQL compatible database that stores transaction data for each node of the plurality of nodes; based at least in part on the transaction data, receiving a plurality of transaction data sets corresponding to the updated rule; generating an output based on the plurality of transaction data sets; parsing each of the plurality of transaction data sets to identify a value; and generating an output variable by combining the values, the output including the output variable.