Optimize SQL queries with dull aliases from initial MySQL compatibility pass
& fully resolve remaining issues causing #570