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'))

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

Uses libs:

openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

hades

12.28 score 82 stars 9 packages 496 scripts 4.0k downloads 2 mentions 22 exports 4 dependencies

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

Target	Result	Date
Doc / Vignettes	OK	Nov 08 2024
R-4.5-win	WARNING	Nov 08 2024
R-4.5-linux	WARNING	Nov 08 2024
R-4.4-win	WARNING	Nov 08 2024
R-4.4-mac	WARNING	Nov 08 2024
R-4.3-win	WARNING	Nov 08 2024
R-4.3-mac	WARNING	Nov 08 2024

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 Nov 08 2024.

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

Citation

Development and contributors

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