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.remove double quotes
- 2.replace spaces and dashes with underscores
- 3.cast to upper case
- 4.delete anything that is not letters, numbers, or underscores
- 5.if first character is a number, add an underscore to the beginning
Type | Description |
---|---|
string | text to make SQL safe; works on column names, table names, row values, etc... |
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}}
Last modified 1yr ago