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 version 8 or higher (https://www.java.com/)
Bug report File report

Key Metrics

Version 1.13.1
Published 2023-03-21 1 day ago
Needs compilation? no
License Apache License 2.0
CRAN checks SqlRender results

Downloads

Last 24 hours 179 -45%
Last 7 days 1.198 -17%
Last 30 days 4.873 +39%
Last 90 days 10.872 +36%
Last 365 days 46.459 +37%

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

r-oldrel

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
stringr
shiny
shinydashboard

Reverse Imports

DatabaseConnector

Reverse Suggests

CDMConnector
DrugExposureDiagnostics