translateSql: Deprecated: Translates SQL from one dialect to another

In SqlRender: Rendering Parameterized SQL and Translation to Dialects

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", "snowflake", "synapse", "spark", "redshift", and "iris" 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 documentation built on April 11, 2025, 6:14 p.m.