This package is considered a duplicate. The official version of this package is found at:https://ohdsi.r-universe.dev/SqlRender

Package: SqlRender 1.19.2

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.2.tar.gz
SqlRender_1.19.2.tar.gz(r-4.5-noble)SqlRender_1.19.2.tar.gz(r-4.4-noble)
SqlRender_1.19.2.tgz(r-4.4-emscripten)SqlRender_1.19.2.tgz(r-4.3-emscripten)
SqlRender.pdf |SqlRender.html✨
SqlRender/json (API)
NEWS

# Install 'SqlRender' in R:

install.packages('SqlRender', repos = c('https://cran.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:

openjdk

5.96 score 13 packages 3.9k downloads 2 mentions 22 exports 4 dependencies

Last updated 19 hours agofrom:157474ffe2. Checks:1 OK, 2 WARNING. Indexed: no.

Target	Result	Latest binary
Doc / Vignettes	OK	Mar 13 2025
R-4.5-linux	WARNING	Mar 13 2025
R-4.4-linux	WARNING	Mar 13 2025

Exports:camelCaseToSnakeCase camelCaseToSnakeCaseNames camelCaseToTitleCase createRWrapperForSql getTempTablePrefix launchSqlRenderDeveloper listSupportedDialects loadRenderTranslateSql readSql render renderSql renderSqlFile snakeCaseToCamelCase snakeCaseToCamelCaseNames sparkHandleInsert splitSql supportsJava8 translate translateSingleStatement translateSql translateSqlFile writeSql

Dependencies:backports checkmate rJava rlang

Using SqlRender

Martijn J. Schuemie

Rendered fromUsingSqlRender.Rmdusingknitr::rmarkdownon Mar 13 2025.

Last update: 2024-10-09
Started: 2016-08-16

Citation

Readme and manuals

Help Manual

Help page	Topics
Convert a camel case string to snake case	camelCaseToSnakeCase
Convert the names of an object from camel case to snake case	camelCaseToSnakeCaseNames
Convert a camel case string to title case	camelCaseToTitleCase
Create an R wrapper for SQL	createRWrapperForSql
Get the prefix used for emulated temp tables for DBMSs that do not support temp tables (e.g. Oracle, BigQuery).	getTempTablePrefix
Launch the SqlRender Developer Shiny app	launchSqlRenderDeveloper
List the supported target dialects	listSupportedDialects
Load, render, and translate a SQL file in a package	loadRenderTranslateSql
Reads a SQL file	readSql
Render SQL code based on parameterized SQL and parameter values	render
Deprecated: Render SQL code based on parameterized SQL and parameter values	renderSql
Render a SQL file	renderSqlFile
Convert a snake case string to camel case	snakeCaseToCamelCase
Convert the names of an object from snake case to camel case	snakeCaseToCamelCaseNames
Handles Spark Inserts	sparkHandleInsert
Split a single SQL string into one or more SQL statements	splitSql
Determine if Java virtual machine supports Java	supportsJava8
Translates SQL from one dialect to another	translate
Translates a single SQL statement from one dialect to another	translateSingleStatement
Deprecated: Translates SQL from one dialect to another	translateSql
Translate a SQL file	translateSqlFile
Write SQL to a SQL (text) file	writeSql