translate translates SQL from one dialect to another.
translate(sql = "", targetDialect, oracleTempSchema = NULL)
The SQL to be translated
The target dialect. Currently "oracle", "postgresql", "pdw", "impala", "netezza", "bigquery", and "redshift" are supported
A schema that can be used to create temp tables in when using Oracle or Impala.
A character string containing the translated SQL.
This function takes SQL in one dialect and translates it into another. It uses simple pattern
replacement, so its functionality is limited. Note that trailing semicolons are not removed
for Oracle, which is required before sending a statement through JDBC. This will be done by
translate("USE my_schema;", targetDialect = "oracle")#>  "ALTER SESSION SET current_schema = my_schema;"