Skip to content

SqlRender

Rendering Parameterized SQL and Translation to Dialects

v1.19.5 · Mar 24, 2026 · Apache License 2.0

Description

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

Downloads

CRAN

3K

Last 30 days

2312th

10.6K

Last 90 days

57.4K

Last year

Trend: -10.2% (30d vs prior 30d)

r2u CRAN

56

Last 30 days

180

Last 90 days

323

Last year

Trend: +69.7% (30d vs prior 30d)

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 6, 2026
ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 3, 2026
ERROR r-devel-linux-x86_64-debian-gcc

package dependencies

Package required but not available: ‘rJava’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Reverse Dependencies (21)

depends

Dependency Network

Dependencies Reverse dependencies rJava rlang checkmate CommonDataModel Achilles Characterization CohortGenerator CohortMethod DataQualityDashboard DatabaseConnector FeatureExtraction OdysseusCharacterizationModule OdysseusPathwayModule OdysseusSurvivalModule OhdsiReportGenerator PatientLevelPrediction ResultModelManager SelfControlledCaseSeries +6 more reverse deps SqlRender

Version History

47 tracked
updated 1.19.5 ← 1.19.4 diff Mar 25, 2026
new 1.19.4 Mar 10, 2026
updated 1.19.4 ← 1.19.3 diff Sep 26, 2025
updated 1.19.3 ← 1.19.2 diff Aug 18, 2025
updated 1.19.2 ← 1.19.1 diff Mar 12, 2025
updated 1.19.1 ← 1.19.0 diff Nov 28, 2024
updated 1.19.0 ← 1.18.1 diff Oct 8, 2024
updated 1.18.1 ← 1.18.0 diff Aug 20, 2024
updated 1.18.0 ← 1.17.0 diff May 29, 2024
updated 1.17.0 ← 1.16.1 diff Mar 19, 2024
updated 1.16.1 ← 1.16.0 diff Oct 6, 2023
updated 1.16.0 ← 1.15.2 diff Sep 19, 2023
updated 1.15.2 ← 1.15.1 diff Aug 9, 2023
updated 1.15.1 ← 1.15.0 diff Jun 28, 2023
updated 1.15.0 ← 1.14.0 diff May 7, 2023