SQL is case-insenstive for all SQL functions (e.g. DATE(col_1) & date(col_1) are identical).

But the convention is to use upper case. So DATE(col_1) is the convention.

I have not come across a parser or linter that auto-capitalises. Is there a way to take a sql script, and auto capitalise it to convention?

CodePudding user response：

Using an online sql formatter may cause information security violations depending on the company. If there is a risk, I recommend using the notepad replace all feature, but a little effort is needed.