SqlRender (version 1.6.2)

translate: Translates SQL from one dialect to another

Description

translate translates SQL from one dialect to another.

Usage

translate(sql = "", targetDialect, oracleTempSchema = NULL)

Arguments

sql

The SQL to be translated

targetDialect

The target dialect. Currently "oracle", "postgresql", "pdw", "impala", "netezza", "bigquery", and "redshift" are supported

oracleTempSchema

A schema that can be used to create temp tables in when using Oracle or Impala.

Value

A character string containing the translated SQL.

Details

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 splitSql.

Examples

# NOT RUN {
translate("USE my_schema;", targetDialect = "oracle")

# }