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'.

Version:	1.19.4
Imports:	rJava, rlang, checkmate
Suggests:	testthat, knitr, rmarkdown, shiny, shinydashboard
Published:	2025-09-26
DOI:	10.32614/CRAN.package.SqlRender
Author:	Martijn Schuemie [aut, cre], Marc Suchard [aut]
Maintainer:	Martijn Schuemie <schuemie at ohdsi.org>
BugReports:	https://github.com/OHDSI/SqlRender/issues
License:	Apache License 2.0
URL:	https://ohdsi.github.io/SqlRender/, https://github.com/OHDSI/SqlRender
NeedsCompilation:	no
SystemRequirements:	Java (>= 8)
Materials:	README, NEWS
CRAN checks:	SqlRender results

Documentation:

Reference manual:	SqlRender.html , SqlRender.pdf
Vignettes:	Using SqlRender (source, R code)

Downloads:

Package source:	SqlRender_1.19.4.tar.gz
Windows binaries:	r-devel: SqlRender_1.19.4.zip, r-release: SqlRender_1.19.4.zip, r-oldrel: SqlRender_1.19.4.zip
macOS binaries:	r-release (arm64): SqlRender_1.19.4.tgz, r-oldrel (arm64): SqlRender_1.19.4.tgz, r-release (x86_64): SqlRender_1.19.4.tgz, r-oldrel (x86_64): SqlRender_1.19.4.tgz
Old sources:	SqlRender archive

Reverse dependencies:

Reverse depends:	CommonDataModel
Reverse imports:	Achilles, Characterization, CohortGenerator, DatabaseConnector, DataQualityDashboard, FeatureExtraction, PatientLevelPrediction, ResultModelManager, SelfControlledCaseSeries
Reverse suggests:	allofus, CDMConnector, CohortConstructor, DrugExposureDiagnostics, TreatmentPatterns

Linking:

Please use the canonical form https://CRAN.R-project.org/package=SqlRender to link to this page.