More Casing/Capitalization Options
Regardless of the source table, we would like the option to force table, column, and alias names to lower case. (We integrate databases from multiple sources and our queries look like a mess when half of the columns are upper case and half are lower).
Example:
SELECT dp.PROJID AS cpprojid,
pld.suffix AS projectsegment,
IP.projectnumber AS innprojid
FROM DEL.PROJ AS dp
INNER JOIN DEL.viewprojectlvldetail AS pld
ON pld.PROJID = dp.projid
LEFT OUTER JOIN inn.PROJ AS IP
ON dp.PROJID LIKE IP.cpproj_id + '%'
I think this is hard to read. We'd prefer the keywords to standout as uppercase and standardize all out table/column/alias names as lower case so they're easier to read and all of our servers/databases are of a Collation that can support it.
Preferred format:
SELECT dp.projid AS cpprojid,
pld.suffix AS projectsegment,
ip.projectnumber AS innprojid
FROM del.proj AS dp
INNER JOIN del.viewprojectlvldetail AS pld
ON pld.projid = dp.projid
LEFT OUTER JOIN inn.proj AS ip
ON dp.projid LIKE ip.cpproj_id + '%'