QueryInsert: Insert query.

In sqlq: 'SQL' Query Builder

Insert query.

Description

Insert query.

Insert query.

Details

This class represents an SQL SELECT query. See the make_insert() factory function to create more easily an INSERT query object.

Super class

sqlq::Query -> QueryInsert

Methods

Public methods

• QueryInsert$new()

• QueryInsert$clone()

Inherited methods

• sqlq::Query$add()
• sqlq::Query$toString()

---

Method new()

Initializer.

Usage

QueryInsert$new(insert, values)

Arguments

insert

A StmtInsert instance.

values

A StmtValues instance.

Returns

Nothing.

---

Method clone()

The objects of this class are cloneable with this method.

Usage

QueryInsert$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

See Also

make_insert

Examples

# To generate a simple INSERT query:
fields <- c('author', 'title', 'year')
insert <- StmtInsert$new(tabl = 'books', fields = make_fields(fields))
values <- make_rows(list(list('John Smith', 'Memories', 1999),
                         list('Barbara', 'My Life', 2010)))
insert <- QueryInsert$new(insert = insert, values = values)

sqlq documentation built on Sept. 16, 2025, 9:10 a.m.