LOWER returns the lower-cased version of a string.
LOWER
Supported input column types: STRING
Output column type: STRING
NULL-values: If the value is NULL, the result is NULL
LOWER ( table.column )
LOWER ( "Table1"."Column1" )