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.zip(r-4.7)SqlRender_1.19.5.zip(r-4.6)SqlRender_1.19.5.zip(r-4.5)
SqlRender_1.19.5.tgz(r-4.6-any)SqlRender_1.19.5.tgz(r-4.5-any)
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://ohdsi.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:

hades openjdk

12.05 score 87 stars 17 packages 491 scripts 3.6k downloads 2 mentions 22 exports 4 dependencies

Last updated from:3779e2b962. Checks:7 WARNING, 2 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	WARNING	146
source / vignettes	OK	182
linux-release-x86_64	WARNING	144
macos-release-arm64	WARNING	110
macos-oldrel-arm64	WARNING	131
windows-devel	WARNING	86
windows-release	WARNING	92
windows-oldrel	WARNING	118
wasm-release	OK	110

Exports:camelCaseToSnakeCase camelCaseToSnakeCaseNames camelCaseToTitleCase createRWrapperForSql getTempTablePrefix launchSqlRenderDeveloper listSupportedDialects loadRenderTranslateSql readSql render renderSql renderSqlFile snakeCaseToCamelCase snakeCaseToCamelCaseNames sparkHandleInsert splitSql supportsJava8 translate translateSingleStatement translateSql translateSqlFile writeSql

Dependencies:backports checkmate rJava rlang

Using SqlRender

Martijn J. Schuemie

Rendered fromUsingSqlRender.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-09-30
Started: 2014-11-28

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Convert a camel case string to snake case	camelCaseToSnakeCase
Convert the names of an object from camel case to snake case	camelCaseToSnakeCaseNames
Convert a camel case string to title case	camelCaseToTitleCase
Create an R wrapper for SQL	createRWrapperForSql
Get the prefix used for emulated temp tables for DBMSs that do not support temp tables (e.g. Oracle, BigQuery).	getTempTablePrefix
Launch the SqlRender Developer Shiny app	launchSqlRenderDeveloper
List the supported target dialects	listSupportedDialects
Load, render, and translate a SQL file in a package	loadRenderTranslateSql
Reads a SQL file	readSql
Render SQL code based on parameterized SQL and parameter values	render
Deprecated: Render SQL code based on parameterized SQL and parameter values	renderSql
Render a SQL file	renderSqlFile
Convert a snake case string to camel case	snakeCaseToCamelCase
Convert the names of an object from snake case to camel case	snakeCaseToCamelCaseNames
Handles Spark Inserts	sparkHandleInsert
Split a single SQL string into one or more SQL statements	splitSql
Determine if Java virtual machine supports Java	supportsJava8
Translates SQL from one dialect to another	translate
Translates a single SQL statement from one dialect to another	translateSingleStatement
Deprecated: Translates SQL from one dialect to another	translateSql
Translate a SQL file	translateSqlFile
Write SQL to a SQL (text) file	writeSql