Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

translateSql

Deprecated: Translates SQL from one dialect to another

Description

This function has been deprecated. Use translate instead. This new function returns a character vector instead of a list.

Usage

translateSql(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 list containing the following elements:

originalSql

The original parameterized SQL code

sql

The translated SQL

SqlRender

Rendering Parameterized SQL and Translation to Dialects

v1.7.0
Apache License 2.0
Authors
Martijn Schuemie [aut, cre], Marc Suchard [aut]
Initial release
2021-03-01

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.