Added .as() method for SELECT statements allowing to alias the subqueries.