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.
Example
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:
Created in 2020 by Google Inc.