sql: Represent a character vector as a SQL statement

In decisionpatterns/sql.template: Light-weight, mustache-based SQL templating

Description

Creates a string with class 'sql'

Usage

sql(x)

is.sql(x)

## S3 method for class 'sql'
print(x, ...)

as.sql(x)

## S3 method for class 'character'
as.sql(x)

Arguments

x	character; string to convert to a SQL statement
...	additional arguments

Details

There is nothing magical here. An object of sql is just a string ... i.e. an one-element character vector. It is coerced to a string by 'collapsing' the vector with \n.

See Also

sql_read for reading SQL from a connection

Examples

  stmt = "SELECT * FROM table"

  sql(stmt)

  is.sql(stmt)        # FALSE
  is.sql( sql(stmt) ) # TRUE

  as.sql(stmt)

decisionpatterns/sql.template documentation built on July 6, 2020, 8:41 a.m.