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.