durcno@1.0.0-alpha.5

Minor Changes

• c68fc6f - Thanks to @almahdi404 !

  feat(query-builders): add prepare support to shortcut queries

  The shortcut query methods $count, $exists, $first, $sum, $avg, $min, $max, and $distinct now support prepared statements via db.prepare().

  Each of these query classes (CountQuery, ExistsQuery, FirstQuery, AggregateQuery, DistinctQuery) gains a new TPrepare extends boolean generic parameter. When in prepare mode, the WHERE clause is built using toQuery() (which inlines $N parameter placeholders) instead of toSQL().

  The Base class threads TPrepare through BuildFilterExpression in the overload signatures, so Arg<T> values are accepted only when called via db.prepare() and are rejected by the type system otherwise.

  // Prepared shortcut query with a typed argument
  const q = prequery({ userType: Users.type.arg() }, (args) =>
    db.prepare().$count(Users, eq(Users.type, args.userType)),
  );
  const count = await q.run(db, { userType: "admin" });
  
  // Non-prepare usage — Arg<T> is rejected at compile time
  // @ts-expect-error
  db.$count(Users, eq(Users.type, Users.type.arg()));

Patch Changes

• 915c8bf - Thanks to @almahdi404 !

  fix(insert): use DEFAULT for missing columns and build SQL inline

  Previously, insert rows used a two-phase approach: values were collected into intermediate arrays and joined at the end. Columns missing from the input row were filled with NULL, even when the column had no explicit value — which could silently override a column's database-level DEFAULT.

  The column list is now derived directly from table._.columns, covering all columns consistently. When a column has no value and no insert function, DEFAULT is emitted instead of NULL, correctly delegating to the database default.

  SQL is now written directly to query.sql as each field is processed, eliminating the intermediate rowValues and rowsValue arrays and reducing allocations per insert.

• 337c0e4 - Thanks to @almahdi404 !

  rename(logger): rename createDurcnoLogger to createQueryLogger

  The createDurcnoLogger function has been renamed to createQueryLogger for clarity.

  The old name is kept as a deprecated alias so existing code continues to work without changes, but it will be removed in a future major release.

  // Before
  import { createDurcnoLogger } from "durcno/logger";
  logger: createDurcnoLogger();
  
  // After
  import { createQueryLogger } from "durcno/logger";
  logger: createQueryLogger();

• a88b747 - Thanks to @almahdi404 !

  fix(filters/array): use column toSQL methods with explicit type cast

  Array filters (arrayContains, arrayContainedBy, arrayOverlaps, arrayHas, arrayAll) previously generated SQL using local helper functions (arrayToSql, valueToSql) that produced string literals without proper PostgreSQL type casts. This caused failures with enum array columns, where PostgreSQL requires an explicit cast (e.g., ::status_enum[]) to resolve the type.

  The fix delegates SQL generation to the column's own toSQL / toSQLScalar methods and appends an explicit cast using the column's sqlType:

  // before
  `${col.fullName} @> ARRAY['active']`
  // after
  `${col.fullName} @> ${col.toSQL(["active"])}::status_enum[]`;

  The array integration tests were restructured into isolated per-type describe blocks with returning({ id: true }) for row-level isolation.