TableOrViewOperations<Tbl extends HasResultSet, Row> class Null safety

A capture of a table and a generated database.

Table operations can be captured with DatabaseConnectionUser.from, which may make some common operations easier to write:

  • Use from(table).select() or from(table).selectOnly() instead of select(table) or selectOnly(table), respectively.
  • Use from(table).insert() instead of insert(table). You can also use from(table).insertOne, or TableOperations.insertOnConflictUpdate to insert rows directly.
  • Use from(table).update() instead of update(table). You can also use from(table).replace() to replace an existing row.
  • Use from(table).delete(), from(table).deleteOne() or from(table).deleteWhere to delete rows easily.
Available Extensions


hashCode int
The hash code for this object. [...]
read-only, inherited
runtimeType Type
A representation of the runtime type of the object.
read-only, inherited


noSuchMethod(Invocation invocation) → dynamic
Invoked when a non-existent method or property is accessed. [...]
select({bool distinct = false}) SimpleSelectStatement<Tbl, Row>
Composes a SELECT statement on the captured table or view. [...]
selectOnly({bool distinct = false, bool includeJoinedTableColumns = true}) JoinedSelectStatement<Tbl, Row>
Composes a SELECT statement only selecting a subset of columns. [...]
toString() String
A string representation of this object. [...]


operator ==(Object other) bool
The equality operator. [...]