Drizzle Query Builder

Requirements

• Export table(rows), query(table) as named, and query as default. Tables store a snapshot of flat plain-object rows with the same own field set. Values are strings, finite numbers, booleans, or null. Reject unsupported records/values with TypeError. Table.column(key) returns a typed column descriptor, and snapshot() returns fresh record copies.
• Query exposes select(...keys), where(predicate), orderBy(...orders), offset(n), limit(n), and execute(). Every chain method returns an independent new query without changing the source query. Query creation snapshots the table. execute returns fresh projected rows on every call.
• Export eq(column,value) using Object.is, gt(column,finiteNumber) for numeric fields only, and and/or/not predicate combinators. Empty and is true; empty or is false. Multiple where calls are ANDed. Predicates are pure and may read all original fields even after select. Calling where with a non-function or gt with a nonfinite operand throws TypeError.
• Default projection includes all fields. Each select call replaces the prior selection; select() produces an empty object per matching row. Preserve selected key order and safely define arbitrary own string fields such as __proto__. Do not expose internal records to callers.
• Export asc(column) and desc(column). orderBy replaces prior ordering and compares listed columns lexicographically. Ascending type order is null, boolean, number, string; within types use false before true, numeric order, and JavaScript string comparison. Equal keys retain table insertion order. All column keys used at runtime exist on each row.
• Always filter, sort, paginate, then project, regardless of chain call order. offset and limit replace prior values, default to 0 and unlimited, and accept only nonnegative safe integers; otherwise throw RangeError. Zero limit returns []. Invalid ordering directions throw TypeError.
• This is an original bounded exercise inspired by fluent query APIs, not a Drizzle-compatible SQL implementation. Joins, mutations, promises, SQL generation, schemas, missing columns, impure predicates, and nested field values are excluded.

Examples

Input: const users=table([{id:1,score:3},{id:2,score:1}]); query(users).where(gt(users.column("score"),1)).select("id").execute()
Output: [{id:1}]

Input: query(users).limit(1).orderBy(desc(users.column("score"))).offset(1).execute()
Output: [{id:2,score:1}]