sq_insert: Create an Insert Statment

In smbache/squr: Structured Query Utility for R

Description

Insert blocks are special parameters in squr and provide an easy way of constructing INSERT INTO ... Values (...) type constructs. They are marked in the SQL source with @label:insert.

Usage

sq_insert(.into, ..., .data = parent.frame(), .split = 75, .quote = "[")

Arguments

.into	The name of the table to insert into.
...	Names of the values to insert, either as character or one-sided formulas. It is also possible to specify AsIs variables by wrapping the value in I(.).
.data	Data or environment to lookup the names.
.split	integer specifying the maximum number of value-pairs in each INSERT block.
.quote	The quote to use for table and column names.

smbache/squr documentation built on May 15, 2021, 3:45 a.m.