Package: SqlRender 1.19.5

Martijn Schuemie

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', 'Snowflake', 'Azure Synapse Analytics Dedicated', 'Apache Spark', 'SQLite', and 'InterSystems IRIS'.

Authors:Martijn Schuemie [aut, cre], Marc Suchard [aut]

SqlRender_1.19.5.tar.gz
SqlRender_1.19.5.tar.gz(r-4.7-any)SqlRender_1.19.5.tar.gz(r-4.6-any)
SqlRender_1.19.5.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
SqlRender/json (API)
NEWS

# Install 'SqlRender' in R:
install.packages('SqlRender', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/ohdsi/sqlrender/issues

Pkgdown/docs site:https://ohdsi.github.io

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

Conda:

openjdk

7.43 score 17 packages 491 scripts 3.6k downloads 2 mentions 22 exports 4 dependencies

Last updated from:4ac9f66d09. Checks:2 WARNING, 2 OK. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-x86_64WARNING144
source / vignettesOK224
linux-release-x86_64WARNING162
wasm-releaseOK131

Exports:camelCaseToSnakeCasecamelCaseToSnakeCaseNamescamelCaseToTitleCasecreateRWrapperForSqlgetTempTablePrefixlaunchSqlRenderDeveloperlistSupportedDialectsloadRenderTranslateSqlreadSqlrenderrenderSqlrenderSqlFilesnakeCaseToCamelCasesnakeCaseToCamelCaseNamessparkHandleInsertsplitSqlsupportsJava8translatetranslateSingleStatementtranslateSqltranslateSqlFilewriteSql

Dependencies:backportscheckmaterJavarlang

Using SqlRender

Martijn J. Schuemie

Rendered fromUsingSqlRender.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-10-09
Started: 2016-08-16