CRAN/E | SqlRender

SqlRender

Rendering Parameterized SQL and Translation to Dialects

Installation

About

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', and 'SQLite'.

ohdsi.github.io/SqlRender/
github.com/OHDSI/SqlRender
System requirements Java (>= 8)
Bug report File report

Key Metrics

Version 1.17.0
Published 2024-03-20 39 days ago
Needs compilation? no
License Apache License 2.0
CRAN checks SqlRender results

Downloads

Yesterday 128 0%
Last 7 days 878 +8%
Last 30 days 3.291 -14%
Last 90 days 10.317 -6%
Last 365 days 46.766 +13%

Maintainer

Maintainer

Martijn Schuemie

schuemie@ohdsi.org

Authors

Martijn Schuemie

aut / cre

Marc Suchard

aut

Material

README
NEWS
Reference manual
Package source

Vignettes

Using SqlRender

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

SqlRender archive

Imports

rJava
rlang
checkmate

Suggests

testthat
knitr
rmarkdown
shiny
shinydashboard

Reverse Depends

CommonDataModel

Reverse Imports

Achilles
CohortAlgebra
DatabaseConnector

Reverse Suggests

allofus
CDMConnector
DrugExposureDiagnostics
TreatmentPatterns