News for hackers. Stuff that matters.
Re:How and why the Relational Model works for databases by faho on Monday January 17, 2022 @08:51AM (#29966523)
If you add the table name you could, and that's what "x." here is.

So yes, you can autocomplete

SELECT employee.Na<TAB>

to "employee.Name", but it requires you to type the table name "employee." first.

But with the from-first style you can autocomplete even bare column names - you know you have "name" (possibly even "employee.name" and "supervisor.name") and "employeeID".

Re:How and why the Relational Model works for databases by irishsultan on Tuesday January 18, 2022 @10:10AM (#29980281)
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.