Only escape identifiers with double quotes if necessary

[pensivebrian]

Currently, our in auto suggestions, we're a little overzealous in our escaping of identifiers with double quotes. We should only escape when necessary.

For example, the query select * from "HumanResources"."Employee" shouldn't need any escaping.

[amjith]

Anything with an upper-casing will be auto-escaped because postgres didn't believe in uppercase. If that's not a problem in mssql then there is no need for this escaping.

[ajilius]

I think the only identifiers that should need quoting are:
(1) names that do not conform to the identifier name rules (ie, start with digit, contain embedded space, etc.)
(2) reserved words

[jefflomax]

For most of us, "dbo" is the only schema, and table names never need any escaping. Where I work, all column names are unique, so aliasing of any kind is a rarity.

We should have a way to make all queries in the simplest and most readable form:
select * from Employees
not select * from "dbo"."Employees"
And at the moment, if I do type select * from Employees, then the DRI based join hints don't work.