down to the point where all tables are already known
(and subqueries converted to joins, if needed)