durcno@1.0.0-alpha.6

Minor Changes

• daff8b6 - Thanks to @almahdi404 !

  impr(columns)!: map bigint and bigserial to JS bigint

  The bigint and bigserial column types now map to JavaScript's native bigint instead of number.

  PostgreSQL's 64-bit integer (bigint) can exceed Number.MAX_SAFE_INTEGER (2^53 - 1), making number an unsafe representation. Using bigint ensures full precision for all values.

  Breaking change for bigint and bigserial columns: values read from the database and values passed in queries/filters must now use bigint literals (e.g. 1n instead of 1).

  // Before
  await db.from(Users).select().where(eq(Users.id, 1));
  // After
  await db.from(Users).select().where(eq(Users.id, 1n));

  The Zod validator for these columns has also been updated to use z.coerce.bigint().

Patch Changes

• d62d5fd - Thanks to @almahdi404 !

  perf(filters): remove toSQL in favor of direct query mutation

  All filter classes previously implemented both toSQL(): string and toQuery(query: Query): void. Query builders conditionally called one or the other depending on whether a prepared statement was being built, creating redundant string allocations.

  The toSQL() method has been removed from every filter class (EqualValCondition, InCondition, AndCondition, OrCondition, array filters, etc.) and from the abstract Filter base class. Query builders now call toQuery() unconditionally, appending directly to query.sql via += without intermediate string returns or joins.

  This eliminates unnecessary string concatenation overhead and reduces the number of code paths that had to be maintained in sync.