TableOrViewStatements<Tbl extends HasResultSet, Row> extension

Easily-accessible methods to compose common operations or statements on tables or views.

on

Methods

all() Selectable<Row>

Available on ResultSetImplementation<Tbl, Row>, provided by the TableOrViewStatements extension

Selects all rows that are in this table.
count({Expression<bool> where(Tbl row)?}) Selectable<int>

Available on ResultSetImplementation<Tbl, Row>, provided by the TableOrViewStatements extension

Counts the rows in this table.
select({bool distinct = false}) SimpleSelectStatement<Tbl, Row>

Available on ResultSetImplementation<Tbl, Row>, provided by the TableOrViewStatements extension

Composes a SELECT statement on the captured table or view.
selectOnly({bool distinct = false}) JoinedSelectStatement<Tbl, Row>

Available on ResultSetImplementation<Tbl, Row>, provided by the TableOrViewStatements extension

Composes a SELECT statement only selecting a subset of columns.