SqlRender: Rendering Parameterized SQL and Translation to Dialects

A rendering tool for parameterized SQL that also translates into different SQL dialects. These dialects include Sql Server, Oracle, PostgreSql, Amazon RedShift, and Microsoft PDW.

Install the latest version of this package by entering the following in R:
install.packages("SqlRender")
AuthorMartijn J. Schuemie [aut, cre], Marc A. Suchard [aut],
Date of publication2017-03-24 19:12:31 UTC
MaintainerMartijn Schuemie <schuemie@ohdsi.org>
LicenseApache License 2.0
Version1.3.0
https://github.com/OHDSI/SqlRender

View on CRAN

Files

inst
inst/sql
inst/sql/oracle
inst/sql/oracle/test.sql
inst/sql/sql_server
inst/sql/sql_server/test.sql
inst/java
inst/java/SqlRender.jar
inst/csv
inst/csv/replacementPatterns.csv
inst/doc
inst/doc/UsingSqlRender.R
inst/doc/UsingSqlRender.pdf
inst/doc/UsingSqlRender.Rmd
tests
tests/testthat.R
tests/testthat
tests/testthat/test-splitSql.R tests/testthat/test-translateSql.R tests/testthat/test-helperFunctions.R tests/testthat/test-renderSql.R
NAMESPACE
NEWS
R
R/HelperFunctions.R R/RenderSql.R
vignettes
vignettes/UsingSqlRender.Rmd
README.md
MD5
java
java/org
java/org/ohdsi
java/org/ohdsi/sql
java/org/ohdsi/sql/MainClass.java
java/org/ohdsi/sql/SqlSplit.java
java/org/ohdsi/sql/SqlRender.java
java/org/ohdsi/sql/SqlTranslate.java
java/org/ohdsi/sql/StringUtils.java
java/org/ohdsi/sql/TestSqlRender.java
java/SqlRender.jardesc
build
build/vignette.rds
DESCRIPTION
man
man/translateSqlFile.Rd man/snakeCaseToCamelCase.Rd man/camelCaseToSnakeCase.Rd man/createRWrapperForSql.Rd man/renderSqlFile.Rd man/loadRenderTranslateSql.Rd man/writeSql.Rd man/renderSql.Rd man/readSql.Rd man/splitSql.Rd man/translateSql.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.