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

4.2K

Last 30 days

1916th

10.9K

Last 90 days

57.4K

Last year

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

CRAN Check Status

14 OK
Show all 14 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-macos-arm64 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 (18)

depends

Dependency Network

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

Version History

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
updated 1.14.0 ← 1.13.1 diff Apr 12, 2023
updated 1.13.1 ← 1.13.0 diff Mar 20, 2023
updated 1.13.0 ← 1.12.1 diff Mar 13, 2023
updated 1.12.1 ← 1.12.0 diff Feb 20, 2023
updated 1.12.0 ← 1.11.1 diff Jan 25, 2023