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.

AuthorMartijn J. Schuemie [aut, cre], Marc A. Suchard [aut],
Date of publication2017-01-16 14:15:54
MaintainerMartijn Schuemie <schuemie@ohdsi.org>
LicenseApache License 2.0
Version1.2.0
https://github.com/OHDSI/SqlRender

View on CRAN

Files in this package

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

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

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