sqlite dialect and all sqlite tests. subqueries can now have their columns selected as tables