CTE name as qualifier
Currently, once SQL Prompt decides a CTE column should be qualified, it always uses the CTE name as the qualifier, without a further check for whether it's strictly necessary. Plain tables and views go through an extra step that can remove qualification when it's not needed, but CTEs don't currently have that step, so you'll always see CTE-derived columns qualified, even when there's only one source.
Could SQLPrompt be updated so that CTEs go through the same checks as tables?
For example
;With CTEMT As
(
Select
FirstName
From dbo.Users
)
Select
CTEMT.FirstName -- Avoiding CTE name being added here
From CTE_MT
1
vote
Alan
shared this idea