can parse subqueries now yayy. working on joins next.