make_insert: Create an SQL INSERT INTO query.

In sqlq: 'SQL' Query Builder

Create an SQL INSERT INTO query.

Description

Create a QueryInsert instance.

Usage

make_insert(tabl, fields, values)

Arguments

tabl	A table name.
fields	A character vector containing field names.
values	A list of lists/vectors of values, each reprensenting a row to insert.

Value

An instance of QueryInsert.

Examples

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

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