Introduction | SQL parameterization | Substituting parameter values | Default parameter values | If-then-else | Translation to other SQL dialects | Functions and structures supported by translate | String concatenation | Bitwise operators | Table aliases and the AS keyword | Temp tables | Implicit casts | Case sensitivity in string comparisons | Schemas and databases | Optimization for massively parallel processing | Debugging parameterized SQL | Developing R packages that contain parameterized SQL | Spark SQL
Package: SqlRender 1.19.5
Martijn Schuemie
SqlRender: Rendering Parameterized SQL and Translation to Dialects
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', 'SQLite', and 'InterSystems IRIS'.
Authors:
SqlRender_1.19.5.tar.gz
SqlRender_1.19.5.zip(r-4.7)SqlRender_1.19.5.zip(r-4.6)SqlRender_1.19.5.zip(r-4.5)
SqlRender_1.19.5.tgz(r-4.6-any)SqlRender_1.19.5.tgz(r-4.5-any)
SqlRender_1.19.5.tar.gz(r-4.7-any)SqlRender_1.19.5.tar.gz(r-4.6-any)
SqlRender_1.19.5.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
SqlRender/json (API)
| # Install 'SqlRender' in R: |
| install.packages('SqlRender', repos = c('https://ohdsi.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/ohdsi/sqlrender/issues
Pkgdown/docs site:https://ohdsi.github.io
Last updated from:3779e2b962. Checks:7 WARNING, 2 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | WARNING | 160 | ||
| source / vignettes | OK | 244 | ||
| linux-release-x86_64 | WARNING | 158 | ||
| macos-release-arm64 | WARNING | 84 | ||
| macos-oldrel-arm64 | WARNING | 104 | ||
| windows-devel | WARNING | 124 | ||
| windows-release | WARNING | 91 | ||
| windows-oldrel | WARNING | 99 | ||
| wasm-release | OK | 355 |
Exports:camelCaseToSnakeCasecamelCaseToSnakeCaseNamescamelCaseToTitleCasecreateRWrapperForSqlgetTempTablePrefixlaunchSqlRenderDeveloperlistSupportedDialectsloadRenderTranslateSqlreadSqlrenderrenderSqlrenderSqlFilesnakeCaseToCamelCasesnakeCaseToCamelCaseNamessparkHandleInsertsplitSqlsupportsJava8translatetranslateSingleStatementtranslateSqltranslateSqlFilewriteSql
