SelectQueryBuilder class

Home > @direct-sqlite/core > SelectQueryBuilder

SelectQueryBuilder class

Isolated type-safe processing context builder managing reading projections.

Signature:

export declare class SelectQueryBuilder<TRow, TSelectedKey extends keyof TRow = keyof TRow>

Remarks

The constructor for this class is marked as internal. Third-party code should not call the constructor directly or create subclasses that extend the SelectQueryBuilder class.

Constructors

Constructor	Modifiers	Description
(constructor)(db, client, tableName, selectedColumns)		Constructs a new instance of the SelectQueryBuilder class

Methods

Method	Modifiers	Description
all()		Resolves all matching entries into a compiled array list.
each()		Streams structural entries row-by-row out of memory to guarantee low garbage collection footprints allowing for iteration, if supported by the SQLite client.
explain()		Inspects virtual machine planning layers showing indexing behaviors.
get()		Pulls the primary single entry record matching the structured query layout.
limit(value)		Sets an upper bound constraint on returned rows.
offset(value)		Configures a skip index boundary offset for row selections.
orderBy(column, direction)		Restructures response sequences based on designated column indices.