align aliases
Please, separate options to align aliases for columns and tables..... I love aligned column aliases, but table aliases advance too far right, unnecessarily.

-
Eric Isaacs commented
The alias alignment is a nice feature that improves the readability of the formatted SQL. Still, it sometimes gets lost too far to the right when the selected column values include things like SQL functions and column names. In those cases, the alignment of the column aliases can require scrolling to the right to see them with a great amount of whitespace between the column name and the aliases and they thus become a detriment to the readability of the SQL.
It would be great if we could configure a max number of spaces to align the aliases before which they just ignore any columns that are OVER that max and align as if those wide columns didn't exist.
I'd still like them to align in that case, just skip the really wide columns that otherwise make the alias alignments unhelpful. The wide columns would just not have their aliases aligned at all with the other ones when this max is set and those columns exceed that max.
-
Eric Isaacs commented
I like the aliases when they align close to the table names. But when they go too far right, they're not helpful, as this suggestion implies. Better than this suggestion, having the ability to configure the MAX distance to tab over an aligned alias before it just doesn't align the line with the other aliases would be great. I'd rather have some aligned close to the table names and the problem line skipped than no alignment at all.
-
Niels van de Coevering commented
Yes, suggesting the same
Here's an example query. When enabling the "Align aliases" option under "Lists", the aliases for tables are also aligned, which causes the table aliases to move away to the right from the tables.
SELECT
column1 = GETDATE()
,column2withlongname = HOST_ID()
FROM
sys.all_views [av]
INNER JOIN information_schema.views [v]
ON [v].table_name = av.name
INNER JOIN information_schema.view_column_usage [vcu]
ON [vcu].view_name = av.name;