StmtSet: SET statement.

In sqlq: 'SQL' Query Builder

SET statement.

Description

SET statement.

SET statement.

Details

This class represents a SQL SET statement, used in UPDATE queries to set field values. It can hold one or more field/value pairs. The factory function make_set() can be used to create a SET statement more easily.

Super class

sqlq::Statement -> StmtSet

Methods

Public methods

• StmtSet$new()

• StmtSet$add_field()

• StmtSet$getTokens()

• StmtSet$clone()

Inherited methods

• sqlq::Statement$toString()

---

Method new()

Initializer.

Usage

StmtSet$new()

Returns

Nothing.

---

Method add_field()

Add a field/value pair.

Usage

StmtSet$add_field(field, value)

Arguments

field

The field, as an ExprField instance.

value

The value to set, as an Expr instance.

Returns

Nothing.

---

Method getTokens()

Generates the list of tokens representing this statement.

Usage

StmtSet$getTokens()

Returns

A list of Token objects.

---

Method clone()

The objects of this class are cloneable with this method.

Usage

StmtSet$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

See Also

make_set()

Examples

# Create a SET statement with a single field/value pair:
set_stmt <- StmtSet$new()
set_stmt$add_field(ExprField$new("price"), ExprValue$new(9.50))

# Use the created SET statement inside an UPDATE query:
query <- QueryUpdate$new(StmtUpdate$new("books"), set = set_stmt)

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