Package: SqlRender 1.19.1

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.1.tar.gz
SqlRender_1.19.1.zip(r-4.5)SqlRender_1.19.1.zip(r-4.4)SqlRender_1.19.1.zip(r-4.3)
SqlRender_1.19.1.tgz(r-4.5-any)SqlRender_1.19.1.tgz(r-4.4-any)SqlRender_1.19.1.tgz(r-4.3-any)
SqlRender_1.19.1.tar.gz(r-4.5-noble)SqlRender_1.19.1.tar.gz(r-4.4-noble)
SqlRender_1.19.1.tgz(r-4.4-emscripten)SqlRender_1.19.1.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'))

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

Pkgdown site:https://ohdsi.github.io

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

On CRAN:

Conda-Forge:

hadesopenjdk

12.38 score 82 stars 12 packages 488 scripts 3.5k downloads 2 mentions 22 exports 4 dependencies

Last updated 3 months agofrom:a0dad78589. Checks:1 OK, 7 WARNING. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKFeb 27 2025
R-4.5-winWARNINGFeb 27 2025
R-4.5-macWARNINGFeb 27 2025
R-4.5-linuxWARNINGFeb 27 2025
R-4.4-winWARNINGFeb 27 2025
R-4.4-macWARNINGFeb 27 2025
R-4.3-winWARNINGFeb 27 2025
R-4.3-macWARNINGFeb 27 2025

Exports:camelCaseToSnakeCasecamelCaseToSnakeCaseNamescamelCaseToTitleCasecreateRWrapperForSqlgetTempTablePrefixlaunchSqlRenderDeveloperlistSupportedDialectsloadRenderTranslateSqlreadSqlrenderrenderSqlrenderSqlFilesnakeCaseToCamelCasesnakeCaseToCamelCaseNamessparkHandleInsertsplitSqlsupportsJava8translatetranslateSingleStatementtranslateSqltranslateSqlFilewriteSql

Dependencies:backportscheckmaterJavarlang

Using SqlRender

Rendered fromUsingSqlRender.Rmdusingknitr::rmarkdownon Feb 27 2025.

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