Change Case directive

The UPPERCASE, LOWERCASE, and TITLECASE directives change the case of column values they are applied to.

Syntax

lowercase :column
uppercase :column
titlecase :column

The directive performs an in-place change of case.

Using this record as an example:

{
  "id": 1,
  "gender": "male",
  "fname": "Root",
  "lname": "JOLTIE",
  "address": "67 MARS AVE, MARSCIty, Marsville, Mars"
}

Applying these directives

uppercase :gender
titlecase :fname
titlecase :lname
lowercase :address

results in this record:

{
  "id": 1,
  "gender": "MALE",
  "fname": "Root",
  "lname": "Joltie",
  "address": "67 mars ave, marscity, marsville, mars"
}