Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

Get Started for Free

SqlRender

Rendering Parameterized SQL and Translation to Dialects

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', and 'SQLite'.

Functions (17)

SqlRender-package

SqlRender: Rendering Parameterized SQL and Translation to Dialects

camelCaseToSnakeCase

Convert a camel case string to snake case

camelCaseToTitleCase

Convert a camel case string to title case

createRWrapperForSql

Create an R wrapper for SQL

launchSqlRenderDeveloper

Launch the SqlRender Developer Shiny app

loadRenderTranslateSql

Load, render, and translate a SQL file in a package

Reads a SQL file

Render SQL code based on parameterized SQL and parameter values

Deprecated: Render SQL code based on parameterized SQL and parameter values

renderSqlFile

Render a SQL file

snakeCaseToCamelCase

Convert a snake case string to camel case

Split a single SQL string into one or more SQL statements

Translates SQL from one dialect to another

translateSingleStatement

Translates a single SQL statement from one dialect to another

translateSql

Deprecated: Translates SQL from one dialect to another

translateSqlFile

Translate a SQL file

Write SQL to a SQL (text) file

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.