Except that the table name isn't necessarily going to be that x. If you are matching employees with their managers then you have two employees tables in that ex

Except that the table name isn't necessarily going to be that x. If you are matching employees with their managers then you have two employees tables in that expression so you have to work with aliases. At which point autocompletion breaks down.