ExprBetween: This class represents an SQL BETWEEN expression.

In sqlq: 'SQL' Query Builder

This class represents an SQL BETWEEN expression.

Description

This class represents an SQL BETWEEN expression.

This class represents an SQL BETWEEN expression.

Details

Used to generate SQL expression BETWEEN / AND.

Super classes

sqlq::Statement -> sqlq::Expr -> ExprBetween

Methods

Public methods

• ExprBetween$new()

• ExprBetween$getTokens()

• ExprBetween$clone()

Inherited methods

• sqlq::Statement$toString()

---

Method new()

Initializer.

Usage

ExprBetween$new(field, low, high)

Arguments

field

An ExprField instance representing the field to check.

low

An ExprValue instance representing the lower bound.

high

An ExprValue instance representing the upper bound.

Returns

Nothing.

---

Method getTokens()

Generates the list of tokens representing this statement.

Usage

ExprBetween$getTokens()

Returns

A list of Token objects.

---

Method clone()

The objects of this class are cloneable with this method.

Usage

ExprBetween$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

Examples

# To generate "i BETWEEN 1 AND 10":
ExprBetween$new(ExprField$new("i"), ExprValue$new(1L), ExprValue$new(10L))

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