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.

Author
Martijn J. Schuemie [aut, cre], Marc A. Suchard [aut],
Date of publication
2016-08-16 19:47:24
Maintainer
Martijn Schuemie <schuemie@ohdsi.org>
License
Apache License 2.0
Version
1.1.7
URLs

View on CRAN

Man pages

camelCaseToSnakeCase
Convert a camel case string to snake case
createRWrapperForSql
Create an R wrapper for SQL
loadRenderTranslateSql
Load, render, and translate a SQL file in a package
readSql
Reads a SQL file
renderSql
renderSql
renderSqlFile
Render a SQL file
snakeCaseToCamelCase
Convert a snake case string to camel case
splitSql
splitSql
translateSql
translateSql
translateSqlFile
Translate a SQL file
writeSql
Write SQL to a SQL (text) file

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