RFE Clearer display of JOIN results

[ysalmon]

To help beginners understand JOINs, it would be nice if SQLiteStudio could display results from JOIN queries by indicating more clearly from which table the columns originate.

I am not entirely sure how this could be done but here are some ideas :

• when a field explicitly has a table qualifier (eg. SomeTable.SomeField) and no AS clause, use that (and not just SomeField or SomeField:1 in case of ambiguity) in the column ;
• do the same if a field is unique among the joined tables and not explicitely qualified ?
• when there is a *, add a new header above the existing one to show the tables from which the fields come (of course this only works if the FROM clause only contains actual tables/views and not subrequests…).

[pawelsalawa]

SQLiteStudio follows column naming strategy from the official SQLite.exe tool. Nonetheless I understand it could be improved. Couple of problems I see here:

1. If we add table names to header, they will become extreamly wide.
2. Not all rows in a single column may come from the same table. UNION selects combine different tables in the same column.

If you hold your mouse over a cell, it will pop up a tooltip, where information about table for this particular row & column. I know it many cases it's just not very handy.

I think the best compromise would be to have an option in configuration to enable table (and database) in headers, so for learning JOINs purpose, this option could be enabled. Such prefixes would be shown below actual column names, maybe using different font and/or color. It would make header a bit taller, but we would avoid them being extra-wide. It would also not matter whether the AS keyword was used - the table (and db) names could always be present.

The only problem that remains - what to put into the header if a single column has data from several different tables? (the UNION select)

[ysalmon]

I did not know about the tooltip ; it is useful indeed, even though it behaves a bit strangely when the mouse cursor moves.