SQL is the language of datawarehousing. In most meaningful data warehousing projects, business domain data is modeled and queried as star joins. Often SQL queries can be a complicated set of correlated sub-queries, common table expressions, windowing functions etc. Most datwarehouses cannot handle the demands of interactivity when dealing with complex SQL expressions.
With SNAP, you can now express your queries with SQL, using its full power, and get answers in seconds. SNAP eliminates joins behind the scenes but let you keep the logical model of using joins in your SQL. SNAP is built with advanced optimization techniques designed to reduce scans of facts to exactly what is needed in the query.