Rendering Parameterized SQL and Translation to Dialects


[Up] [Top]

Documentation for package ‘SqlRender’ version 1.18.0

Help Pages

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