R Observatory: Metrics for SqlRender version 1.19.6

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

SqlRender

1.19.6

Rendering Parameterized SQL and Translation to Dialects

21packages depend

57.2Kdownloads / year

79.7%test coverage

13/13checks pass

Overview

About

Maintained by Martijn SchuemieFirst published 2016-08-1647 releasesCRAN page ↗GitHub ↗

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

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("SqlRender", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("OHDSI/SqlRender")

Development version from OHDSI/SqlRender. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-sqlrender

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-SqlRender

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-SqlRender

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 2.3 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 5.94

79.7%

Coverage · measured lines

100%

Documentation · exports

3

Dependencies · direct

Check history

OK2026-08-05
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-04-06
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-04
13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 505 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 0% structuredCode of conductNoContributing guideNo

Examples that run: 67%
Documented parameters: 100%
Return-value docs: 77%
References docs: 0%

Downloads

57.2K

CRAN downloads in the past year

Rank #2,165 · ~157/day · ~4.8K/mo

Releases R versions

Daily download trend is not available in this view yet.

3.5K30 days

9.9K90 days

57.2K1 year

Compare downloads with other packages →

Also on384 r2u70 c2d4u

Repository

GitHub ↗ ohdsi/sqlrender

87Stars

85Forks

11Open issues

1Open PRs

30Releases

894Commits

49Contributors

hades

894 commits · Last activity 2026-07-31 · 0% stars, 30d

Stars over time

2024-10-20 · 812026-07-07 · 87

Repository practices

Upstream repositoryBeta

4 development-tooling and community-health practices detected across 3 families in the upstream repository

Checks run against github.com/ohdsi/sqlrender on 2026-08-09.

Continuous integration (1)

GitHub Actions

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

8 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (3)

rJava rlang checkmate

LinkingTo (0)

none

Suggests (5)

testthat knitr rmarkdown shiny shinydashboard

Enhances (0)

none

Dependency license breakdown →

Code & Tests

People & History

People (2)

Maintainer (1)

Martijn Schuemie

Author, Maintainer · added in 1.4.3

Authors (2)

Martijn Schuemie

Author, Maintainer · added in 1.4.3

Marc Suchard

Author · added in 1.4.3

Listed in earlier versions (2)

Martijn J. Schuemie

no longer listed · 1.1.7 to 1.3.7

Marc A. Suchard

no longer listed · 1.1.7 to 1.3.7

Package Timeline

47 releases. Pick two to compare their code metrics. R releases are shown for context.

1.19.6Latest
2026-07-31 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
1.19.5
2026-03-25 · diff ↗
1.19.4
2025-09-27 · diff ↗
1.19.3
2025-08-19 · diff ↗
R
R 4.5.0 released · 2025-04-11
1.19.2
2025-03-13 · diff ↗
1.19.1
2024-11-29 · diff ↗
1.19.0
2024-10-09 · diff ↗
1.18.1
2024-08-21 · diff ↗
1.18.0
2024-05-30 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.17.0
2024-03-20 · diff ↗
1.16.1
2023-10-07 · diff ↗
1.16.0
2023-09-20 · diff ↗
1.15.2
2023-08-10 · diff ↗

Show 42 earlier events

1.15.1
2023-06-29 · diff ↗
1.15.0
2023-05-08 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.14.0
2023-04-13 · diff ↗
1.13.1
2023-03-21 · diff ↗
1.13.0
2023-03-14 · diff ↗
1.12.1
2023-02-21 · diff ↗
1.12.0
2023-01-26 · diff ↗
1.11.1
2023-01-11 · diff ↗
1.11.0
2022-12-02 · diff ↗
1.10.0
2022-09-20 · diff ↗
1.9.2
2022-07-11 · diff ↗
1.9.1
2022-06-29 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.9.0
2022-02-18 · diff ↗
1.8.3
2022-01-07 · diff ↗
1.8.1
2021-09-15 · diff ↗
1.8.0
2021-09-02 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.7.0
2021-03-02 · diff ↗
1.6.8
2020-07-31 · diff ↗
1.6.6
2020-05-19 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.6.5
2020-04-01 · diff ↗
1.6.4
2020-03-17 · diff ↗
1.6.3
2020-01-13 · diff ↗
1.6.2
2019-06-24 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.6.0
2019-02-15 · diff ↗
1.5.3
2018-11-23 · diff ↗
1.5.2
2018-08-17 · diff ↗
1.5.0
2018-05-28 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.4.8
2018-02-26 · diff ↗
1.4.6
2017-11-07 · diff ↗
1.4.3
2017-09-15 · diff ↗
1.3.7
2017-05-03 · diff ↗
R
R 3.4.0 released · 2017-04-21
1.3.0
2017-03-24 · diff ↗
1.2.0
2017-01-16 · diff ↗
1.1.7
2016-08-16
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2016-08-16
Total releases: 47 / 10 yrs
License: Apache License 2.0 OSI
Download size: 448 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("SqlRender")

Format

Schuemie, M., & Suchard, M. (2026). SqlRender: Rendering Parameterized SQL and Translation to Dialects (Version 1.19.6) [Computer software]. https://doi.org/10.32614/CRAN.package.SqlRender

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for SqlRender version 1.19.6 [Data set]. HJJB, LLC. Data release v2026-08-15. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-15, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →