Links

cleanse_name()

Utility to make a string SQL safe so that it can be used as an alias for a new column.
Takes the following actions on a string:
  1. 1.
    remove double quotes
  2. 2.
    replace spaces and dashes with underscores
  3. 3.
    cast to upper case
  4. 4.
    delete anything that is not letters, numbers, or underscores
  5. 5.
    if first character is a number, add an underscore to the beginning

Parameters

Type
Description
string
text to make SQL safe; works on column names, table names, row values, etc...

Example

SELECT *
<div data-gb-custom-block data-tag="-"></div>
, {{math_op}} as {{cleanse_name(math_op)}}
<div data-gb-custom-block data-tag="-"></div>
FROM {{source_table}}