StmtSelectAll: SELECT * statement.

In sqlq: 'SQL' Query Builder

SELECT * statement.

Description

SELECT * statement.

SELECT * statement.

Details

This class represents a SQL SELECT * statement. It can be used to select all fields from a table, with optional distinct keyword to remove duplicate results.

Super classes

sqlq::Statement -> sqlq::StmtSelect -> StmtSelectAll

Methods

Public methods

• StmtSelectAll$new()

• StmtSelectAll$getTokens()

• StmtSelectAll$clone()

Inherited methods

• sqlq::Statement$toString()

---

Method new()

Initializer

Usage

StmtSelectAll$new(distinct = FALSE)

Arguments

distinct

Set to TRUE enable distinct keyword and remove duplicate results.

Returns

Nothing.

---

Method getTokens()

Generates the list of tokens representing this statement.

Usage

StmtSelectAll$getTokens()

Returns

A list of Token objects.

---

Method clone()

The objects of this class are cloneable with this method.

Usage

StmtSelectAll$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

Examples

# Create a SELECT * statement:
select_all <- StmtSelectAll$new()

# Use the created SELECT * statement inside a SELECT query:
query <- QuerySelect$new(select = select_all,
                         from = StmtFrom$new("books"))

# Create a SELECT DISTINCT * statement:
select_distinct_all <- StmtSelectAll$new(distinct = TRUE)

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