query method

QueryBuilder query(
  1. String table
)

Returns a QueryBuilder targeting table.

// All rows where age > 18, sorted by name, page 2
final result = await db.query('users')
    .where('age', greaterThan: 18)
    .orderBy('name')
    .limit(20)
    .offset(20)
    .get();

// Single row lookup
final user = await db.query('users').where('id', equals: id).first();

// Count with filter
final adminCount = await db.query('users')
    .where('role', equals: 'admin')
    .count();

Implementation

QueryBuilder query(String table) => QueryBuilder(this, table);