The trickiest bit isn't parsing per-se, but disambiguating references, so grammar alone isn't enough. And unfortunately, disambiguating references doesn't work

The trickiest bit isn't parsing per-se, but disambiguating references, so grammar alone isn't enough. And unfortunately, disambiguating references doesn't work the same way everywhere - for instance, tables on Hive will shadow a CTE.