make_between: Create a BETWEEN expression.

In sqlq: 'SQL' Query Builder

Create a BETWEEN expression.

Description

Create an ExprBetween instance.

Usage

make_between(field, low, high)

Arguments

field	A character value or an ExprField instance representing the field to check.
low	An atomic single value or an ExprValue instance representing the lower bound.
high	An atomic single value of an ExprValue instance representing the upper bound.

Value

An instance of ExprBetween.

Examples

# To generate a BETWEEN expression checking if the "year" field is between
# 1990 and 2000:
between <- make_between("year", 1990, 2000)

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