QueryBuilder class

Laravel-style Query Builder.

Provides a fluent API for building and executing SQL queries. The builder is schema-aware and will automatically filter insert/update data to only include columns that exist in the table.

Getting Started

// Get all users
final users = await DB.table('users').get();

// Get first user matching condition
final user = await DB.table('users').where('id', 1).first();

Selecting Data

// Select specific columns
final names = await DB.table('users')
  .select(['name', 'email'])
  .get();

// With conditions
final activeUsers = await DB.table('users')
  .where('is_active', true)
  .where('role', 'admin')
  .get();

// With ordering and limits
final recent = await DB.table('posts')
  .orderBy('created_at', 'desc')
  .limit(10)
  .get();

Inserting Data

// Insert single record
await DB.table('users').insert({
  'name': 'John Doe',
  'email': 'john@example.com',
});

// Schema-aware: unknown columns are automatically filtered out
await DB.table('users').insert({
  'name': 'Jane',
  'unknown_field': 'ignored', // Won't cause error
});

Updating Data

await DB.table('users')
  .where('id', 1)
  .update({'name': 'Updated Name'});

Deleting Data

await DB.table('users')
  .where('id', 1)
  .delete();