Described herein is a computer implemented method. The method comprises processing clauses included in an original SQL query to add each clause to either a set of caching clauses or a set of non-caching clauses and determining whether a subscription should be created. In response to determining the subscription should be created, the method comprises creating the subscription by generating a first stage SQL query based on the set of caching clauses, causing execution of the first stage SQL query to obtain a set of first stage query results from a database; and storing the set of first stage query results in a cache.