Package: SqlRender 1.19.0

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:Martijn Schuemie [aut, cre], Marc Suchard [aut]

SqlRender_1.19.0.tar.gz
SqlRender_1.19.0.zip(r-4.5)SqlRender_1.19.0.zip(r-4.4)SqlRender_1.19.0.zip(r-4.3)
SqlRender_1.19.0.tgz(r-4.4-any)SqlRender_1.19.0.tgz(r-4.3-any)
SqlRender_1.19.0.tar.gz(r-4.5-noble)SqlRender_1.19.0.tar.gz(r-4.4-noble)
SqlRender_1.19.0.tgz(r-4.4-emscripten)SqlRender_1.19.0.tgz(r-4.3-emscripten)
SqlRender.pdf |SqlRender.html
SqlRender/json (API)
NEWS

# Install 'SqlRender' in R:
install.packages('SqlRender', repos = c('https://ohdsi.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/ohdsi/sqlrender/issues

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

hades

12.15 score 81 stars 9 packages 490 scripts 3.0k downloads 2 mentions 22 exports 4 dependencies

Last updated 28 days agofrom:c21d7b8798. Checks:OK: 1 WARNING: 6. Indexed: yes.

TargetResultDate
Doc / VignettesOKOct 09 2024
R-4.5-winWARNINGOct 09 2024
R-4.5-linuxWARNINGOct 09 2024
R-4.4-winWARNINGOct 09 2024
R-4.4-macWARNINGOct 09 2024
R-4.3-winWARNINGOct 09 2024
R-4.3-macWARNINGOct 09 2024

Exports:camelCaseToSnakeCasecamelCaseToSnakeCaseNamescamelCaseToTitleCasecreateRWrapperForSqlgetTempTablePrefixlaunchSqlRenderDeveloperlistSupportedDialectsloadRenderTranslateSqlreadSqlrenderrenderSqlrenderSqlFilesnakeCaseToCamelCasesnakeCaseToCamelCaseNamessparkHandleInsertsplitSqlsupportsJava8translatetranslateSingleStatementtranslateSqltranslateSqlFilewriteSql

Dependencies:backportscheckmaterJavarlang

Using SqlRender

Rendered fromUsingSqlRender.Rmdusingknitr::rmarkdownon Oct 09 2024.

Last update: 2024-09-30
Started: 2014-11-28