hassanzohdy/collection/querying

// 1. Key + value (implicit "=" equality)
c.where("active", true);
// 2. Key + operator + value
c.where("age", ">", 18);
c.where("name", "like", "ada");       // case-insensitive substring
c.where("name", "starts with", "A");
c.where("name", "ends with", "a");
c.where("role", "in", ["admin", "mod"]);
c.where("age", "between", [20, 30]);  // inclusive
c.where("score", "between", [0, 100]);
// 3. Operator only (no key — tests the item itself for primitives)
c.where(">=", 18);                    // items that are numbers >= 18

c.where("name", /^A/);

c.where("nickname", "exists");
c.where("deletedAt", "is null");
c.where("config", "is not empty");

c.where("age", "is", "number");            // typeof itemValue === "number"
c.where("handler", "instanceof", MyClass); // itemValue instanceof MyClass
c.where("flag", "is true");
c.where("flag", "is false");

c.whereIn("status", ["active", "pending"]);
c.whereBetween("age", [20, 30]);
c.whereNotBetween("score", [0, 50]);
c.whereNot("status", "banned");
c.whereNull("deletedAt");
c.whereNotNull("email");
c.whereEmpty("tags");
c.whereNotEmpty("tags");
c.whereExists("metadata");
c.whereNotExists("legacyId");

c.filter(item => item.score > 90 && item.verified);

c.reject(item => item.banned);
c.except(item => item.role === "guest"); // alias

collect([1, 2, 3, null]).not(null); // [1, 2, 3]

const user = c.find(u => u.id === 42); // returns item or undefined

c.first(); // first item or undefined
c.last();  // last item or undefined

const admin = c.firstWhere("role", "admin");
const newest = c.lastWhere("status", "active");
const over25 = c.firstWhere("age", ">", 25);