REPLACE() function

REGEX_REPLACE() is expensive since it's depends on the Google RE2 library and sometimes just a simple replace is needed.

Reference:

• https://my.vertica.com/docs/8.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/REPLACE.htm
• http://docs.aws.amazon.com/redshift/latest/dg/r_REPLACE.html