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:
Downloads:
Reverse dependencies:
| Reverse depends: | CommonDataModel |
| Reverse imports: | Achilles,Characterization,CohortGenerator,DatabaseConnector,FeatureExtraction,PatientLevelPrediction,ResultModelManager,SelfControlledCaseSeries |
| Reverse suggests: | allofus,CDMConnector,CohortConstructor,DrugExposureDiagnostics,TreatmentPatterns |
Linking:
Please use the canonical formhttps://CRAN.R-project.org/package=SqlRenderto link to this page.