R Observatory: Metrics for SqlRender version 1.19.7

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

SqlRender

1.19.7Package record

Rendering Parameterized SQL and Translation to Dialects

17packages dependsuggested by 5

46.6Kdownloads / year

79.7%test coverage

13/13flavors OK

Overview

About

Maintained by Martijn SchuemieCRAN page ↗GitHub ↗Website ↗Issues ↗

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

Changes in 1.19.7

Bugfixes:

1. Fixing translation of literals to dates on Iris.

2. Fixing translations of FLOAT. This is now translated to DOUBLE in DuckDB, and DOUBLE PRECISION in Posgresql. In all other dialects the current translation was found to be correct.

3. Fixing SQLite, PosgreSQL, and DuckDB translation of ISNUMERIC.

From NEWS.md in the release

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. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

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). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

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

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK14 OK2026-04-06
ERROR13 OK, 1 ERROR2026-04-04
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.19.7

READMEYes · 505 wordsVignettesYes · 1 · dynamicNEWSYes · 0% structured · mentions 1.19.7Citation fileNoWebsiteYes · pkgdown

Help pages: 23 (1 internal)includes a package overview page
Examples that run: 67%12 run in a plain check · 6 never run
Exported functions with examples: 82%
Documented parameters: 100%
Return-value docs: 77%
Help pages citing references: 0%

Vignettes (1)

Using SqlRender

How these are measured

Downloads

46.6K

CRAN downloads in the past year

Rank #1,799 · ~128/day · ~3.9K/mo

Releases R versions

Daily download trend is not available in this view yet.

5K30 days

11.3K90 days

46.6K1 year

Compare downloads with other packages →

Also on465 r2u6 autocran61 c2d4u

How downloads are counted

Repository

ohdsi/sqlrender ↗Organization: OHDSI

89Stars

88Forks

16Open issues

1Open PRs

31Releases

910Commits

50Commit identities

hades

910 commits · Last activity 2026-09-18 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 83%
Median days to close, 50 most recently updated closed issues: 28
Median days to close, 50 most recently updated closed PRs: 4

Stars over time

2025-09-02 · 822026-08-29 · 89

How these are measured

PracticesBeta

9 development-tooling and community-health practices detected across 6 families in the upstream repository

Checks run against github.com/ohdsi/sqlrender on 2026-10-18.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows

Governance and community (1)

PR template

Docs source (2)

pkgdown

GitHub Pages site last deployed 2026-09-18

Coverage (1)

Coverage reporting

Show all practicesHide 2 practices

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies

8 external dependencies (excludes base and recommended)

Installing SqlRender adds 4 packages (4 with compiled code, 1.6 MB of source tarballs). Heaviest: rlang 766 KB, rJava 624 KB, checkmate 247 KB.

Depends (0)

none

Imports (3)

rJava rlang checkmate

LinkingTo (0)

none

Suggests (5)

testthat knitr rmarkdown shiny shinydashboard

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

17direct

2indirect

Imports 17

Suggested by 5

Show all 22 packagesHide all 22 packages

Depends, Imports or LinkingTo, most downloaded first

DatabaseConnector FeatureExtraction CommonDataModel CohortGenerator DataQualityDashboard ResultModelManager PatientLevelPrediction Characterization CohortMethod SelfControlledCaseSeries Achilles OhdsiReportGenerator CohortIncidence SelfControlledCohort OdysseusPathwayModule OdysseusCharacterizationModule OdysseusSurvivalModule

Suggests, most downloaded first

CDMConnector CohortConstructor DrugExposureDiagnostics TreatmentPatterns allofus

How these are counted

Code & Tests

People & History

People (2)

Martijn Schuemie

Author, Maintainer · added in 1.4.3

Marc Suchard

Author · added in 1.4.3

Maintainer since 1.1.7 (2016)

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

Releases (48)

Pick two releases to compare their code metrics.

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

Show 43 earlier eventsHide 43 earlier events

1.15.2
record
2023-08-10 · diff ↗
1.15.1
record
2023-06-29 · diff ↗
1.15.0
record
2023-05-08 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.14.0
record
2023-04-13 · diff ↗
1.13.1
record
2023-03-21 · diff ↗
1.13.0
record
2023-03-14 · diff ↗
1.12.1
record
2023-02-21 · diff ↗
1.12.0
record
2023-01-26 · diff ↗
1.11.1
record
2023-01-11 · diff ↗
1.11.0
record
2022-12-02 · diff ↗
1.10.0
record
2022-09-20 · diff ↗
1.9.2
record
2022-07-11 · diff ↗
1.9.1
record
2022-06-29 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.9.0
record
2022-02-18 · diff ↗ ·
added 3 exports
camelCaseToSnakeCaseNames, snakeCaseToCamelCaseNames, sparkHandleInsert
1.8.3
record
2022-01-07 · diff ↗ ·
added 2 exports
getTempTablePrefix, listSupportedDialects
1.8.1
record
2021-09-15 · diff ↗ ·
added 1 export
supportsJava8
1.8.0
record
2021-09-02 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.7.0
record
2021-03-02 · diff ↗
1.6.8
record
2020-07-31 · diff ↗
1.6.6
record
2020-05-19 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.6.5
record
2020-04-01 · diff ↗
1.6.4
record
2020-03-17 · diff ↗ ·
added 1 export
camelCaseToTitleCase
1.6.3
record
2020-01-13 · diff ↗
1.6.2
record
2019-06-24 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.6.0
record
2019-02-15 · diff ↗ ·
added 3 exports
render, translate, translateSingleStatement
1.5.3
record
2018-11-23 · diff ↗
1.5.2
record
2018-08-17 · diff ↗
1.5.0
record
2018-05-28 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.4.8
record
2018-02-26 · diff ↗
1.4.6
record
2017-11-07 · diff ↗
1.4.3
record
2017-09-15 · diff ↗ ·
added 1 export
launchSqlRenderDeveloper
1.3.7
record
2017-05-03 · diff ↗
R
R 3.4.0 released · 2017-04-21
1.3.0
record
2017-03-24 · diff ↗
1.2.0
record
2017-01-16 · diff ↗
1.1.7
record
2016-08-16
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2016-08-16
Total releases: 48 / 10 yrs
License: Apache License 2.0 OSI
Download size: 449 KB

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.7) [Computer software]. https://doi.org/10.32614/CRAN.package.SqlRender

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

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.7 [Data set]. HJJB, LLC. Data release v2026-10-21. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-21, 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 →