Query evaluator to provide full support for SQL, out-of-core query processing and limited forms of query evaluation