left and right sides of joins no longer wrapped in SQL — they're now expected to be SQL already
common table expressions and `WITH` clauses
test suite