READ USECASES // FetchWhereZero QueryBuilder::table('tenants')->fetchOne('name, email'); // FetchWhereOne QueryBuilder::table('tenants') ::where('id', 5) ::fetchOne(); // FetchWhereTwo QueryBuilder::table('tenants') ::where('email', 'a@b.com') ::where('is_active', 1) ::fetchOne(); // FetchWhereThree QueryBuilder::table('tenants') ::where('email', 'a@b.com') ::where('is_active', 1) ::where('plan', 'pro') ::orderBy('created_at') ::limit(1) ::fetchOne(); // CountWhereZero QueryBuilder::table('tenants')::count(); // all active tenants QueryBuilder::table('tenants')::fetchAll(); // with a single where QueryBuilder::table('tenants') ::where('is_active', 1) ::fetchAll(); // multiple where clauses — chain them QueryBuilder::table('tenants') ::where('is_active', 1) ::orWhere('plan', 'pro') ::fetchAll(); // with order and limit QueryBuilder::table('tenants') ::where('is_active', 1) ::where('plan', 'pro') ::orderBy('created_at', 'ASC') ::limit(10) ::fetchAll(); WRITE USECASES // UpdateAnyRow — 1 field, 1 where QueryBuilder::table('tenants') ::where('id', 5) ::update(['plan' => 'pro']); // UpdateAnyRowTwo — 2 fields, 1 where QueryBuilder::table('tenants') ::where('id', 5) ::update(['plan' => 'pro', 'is_active' => 1]); // UpdateAnyRowThree — 3 fields, 1 where QueryBuilder::table('tenants') ::where('id', 5) ::update([ 'plan' => 'pro', 'is_active' => 1, 'updated_at' => AppDateTime::now(), ]); // UpdateRowWhereTwo — 1 field, 2 wheres QueryBuilder::table('tenants') ::where('id', 5) ::where('email', 'a@b.com') ::update(['plan' => 'pro']); // UpdateRowTwoWhereTwo — 2 fields, 2 wheres QueryBuilder::table('tenants') ::where('id', 5) ::where('email', 'a@b.com') ::update(['plan' => 'pro', 'is_active' => 1]); // OR condition QueryBuilder::table('tenants') ::where('id', 5) ::orWhere('email', 'a@b.com') ::fetchAll(); // Insert QueryBuilder::table('tenants')::insert([ 'name' => $data['name'], 'slug' => $data['slug'], 'email' => $data['email'], 'plan' => $data['plan'] ?? 'free', 'is_active' => 1, 'created_at' => AppDateTime::now(), ]);