Nit should only be showing the column names right?
Owell those are the column names
Oin sql, you can refer to a column by User.email and email and they are identical (assuming the table is called User)
Oit becomes more important with left joins etc. where you can have multiple different tables and you want to keep it sane, so you would use User.email and User.yada yada etc.
I@oof2win2 is correct. When joining tables, subqueries, CTEs and a column name exists in more than 1 data source in query context, its generally a good idea to refer to it prefixed by the data source.
Some engines, in some SQL clauses might even throw an error due to ambiguous references, so it becomes a must.
Some engines, in some SQL clauses might even throw an error due to ambiguous references, so it becomes a must.
NAwsome thank you @oof2win2 and @Igal