Don't qualify column name in certain scenarios
Currently SQL Complete has an option to automatically qualify column names. Unfortunately, turning the option on means turning it on for everything.
I love that SQL Complete qualifies the column name with the table name in regular SELECT statements such as:
SELECT t1.Column1, t2.Column2 FROM dbo.Table1 t1 JOIN dbo.Table2 t2 ON t1.Column1 = t2.Column1
However, I find it unnecessary when you are dealing with only one table in an UPDATE/INSERT/DELETE statement. For example qualification is unnecessary in the following statements:
UPDATE dbo.Table1 SET Column2 = 123 WHERE Column1 = 10
or
INSERT INTO dbo.Table1 (Column1, Column2) ...
or
DELETE FROM dbo.Table1 WHERE Column1 = 10
If any of the above queries are changed to reference an additional table, for example in an UPDATE statement with a FROM clause, or when you introduce a sub-query, then qualifications would become necessary in the columns being referenced.
I'd like to suggest that you add a configuration option to ignore column qualification for INSERT/UPDATE/DELETE statements that don't need it.
![](https://secure.gravatar.com/avatar/37fde14d43fd57875515679bfa1f3100?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)