translateSql

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

A rendering tool for parameterized SQL that also translates into
different SQL dialects.  These dialects include 'Microsoft SQL Server', 'Oracle',
'PostgreSql', 'Amazon RedShift', 'Apache Impala', 'IBM Netezza', 'Google BigQuery', 'Microsoft PDW', 'Snowflake',
'Azure Synapse Analytics Dedicated', 'Apache Spark', 'SQLite', and 'InterSystems IRIS'.

Martijn Schuemie

SqlRender

Rendering Parameterized SQL and Translation to Dialects

Marc Suchard

translateSql function

<dl><dt>sql</dt>
<dd>The SQL to be translated</dd>
<dt>targetDialect</dt>
<dd>The target dialect. Currently "oracle", "postgresql", "pdw", "impala",
"netezza", "bigquery", "snowflake", "synapse", "spark", "redshift", and
"iris" are supported</dd>
<dt>oracleTempSchema</dt>
<dd>A schema that can be used to create temp tables in when using Oracle or
Impala.</dd></dl>

Arguments

Deprecated: Translates SQL from one dialect to another — translateSql

<dl>

<dt>sql</dt>
<dd>The SQL to be translated</dd>


<dt>targetDialect</dt>
<dd>The target dialect. Currently "oracle", "postgresql", "pdw", "impala",
"netezza", "bigquery", "snowflake", "synapse", "spark", "redshift", and
"iris" are supported</dd>


<dt>oracleTempSchema</dt>
<dd>A schema that can be used to create temp tables in when using Oracle or
Impala.</dd>

</dl>

translateSql: Deprecated: Translates SQL from one dialect to another

Description

Usage

Value

Arguments