1. A non-transitory computer readable medium having stored thereon instructions that, when executed, are configurable to cause one or more processors to: receive a user database query in a structured query language with the one or more processors; parse the user database query and automatically generate, with the one or more processors, a set of parallel database sub queries that in combination are equivalent to the user database query in results that are expected to be returned, wherein individual database sub queries in the set of parallel database sub queries are compared against other optimizable filters against the user database query; perform one or more runtime prequeries to gather optimization information for a selected tenant of a multitenant environment corresponding to the user database query; optimize each database sub query based on the lowest calculated cost of data access, wherein each database sub query is fully optimized utilizing a database query optimizer; execute, with the one or more processors, the set of parallel database sub queries against multiple database tables, if a cost of data access of the user database query is expected to be more than a cost of data access of a new database query formed by combining the returned results of the set of parallel database sub queries, the forming of the new database query being accomplished by at least forming a clause that combines the set of parallel database sub queries into a database query equivalent to the user database query; and return, with the one or more processors, results of the new database query.