identifierCase.md

identifierCase (experimental)

Converts identifiers to upper- or lowercase. Only unquoted identifiers are converted.

This option doesn't yet support all types of identifiers:

• prefixed variables like @my_var are not converted.
• parameter placeholders like :param are not converted.

NB! The use of this option is generally not recommended, because SQL Formatter leans on the side of detecting as few keywords as possible (to avoid converting them to uppercase when keywordCase: "upper" is used), which on the flip side means that everything else will be labeled as identifiers.

The only reasonable cases to use this option is when you want all your SQL to be either in uppercase or lowercase. But if you only want keywords to be in uppercase, only use the keywordCase: "upper" option.

Options

• "preserve" (default) preserves the original case.
• "upper" converts to uppercase.
• "lower" converts to lowercase.

preserve

select
  count(a.Column1),
  max(a.Column2 + a.Column3),
  a.Column4 AS myCol
from
  Table1 as a
where
  Column6
  and Column7
group by
  Column4

upper

select
  count(A.COLUMN1),
  max(A.COLUMN2 + A.COLUMN3),
  A.COLUMN4 AS MYCOL
from
  TABLE1 as A
where
  COLUMN6
  and COLUMN7
group by
  COLUMN4

lower

select
  count(a.column1),
  max(a.column2 + a.column3),
  a.column4 AS mycol
from
  table1 as a
where
  column6
  and column7
group by
  column4