Display table name/alias in columns with the same name when displaying results of join queries.

[Astroxslurg]

When I join multiple tables I cannot distinguish between columns with the same name in output. E.g. if i join 3 tables together and every table has an "id"-column each of the columns has the same name making it very hard to tell which of the columns belong to which table.

Is there a way to make mssql-cli display table names or aliases in these results?

[chrisg123]

Off the top of my head could you not just "AS" the fields ? (table1.id AS table1_id table2.id AS table2_id...etc)