Internal
Create through query(knex, alias(schema, name)).
Readonly Internal[Type-only fluent return constructor.
Readonly Internal[Type-only ordered argument contract.
Exact structural schema, stable across operations that do not change selection.
Internal
Cached SELECT execution and independent materialization.
ProtectedaddExplicit AND spelling of where(), including groups and typed parameters.
Explicit AND spelling of where(), including groups and typed parameters.
Explicit AND spelling of where(), including groups and typed parameters.
Explicit AND spelling of where(), including groups and typed parameters.
Configure raw SQL once and declare its complete output contract.
Internal
Compile selected fields, casting exact numeric values before driver parsing.
Optionalmode: typeof COMPILE_PARAMETERSExecute one statement and validate/decode its detached results.
Fetch the first selected row, or undefined.
Filter grouped rows using native SQL aggregate values.
Add an immutable inner join with typed alias predicates.
Add an immutable left join; projected right-side fields are nullable.
Add an OR comparison or parenthesized group.
Add an OR comparison or parenthesized group.
Add an OR comparison or parenthesized group.
Add an OR comparison or parenthesized group.
ProtectedreadQuote a mapped column for trusted raw SQL or correlated subqueries.
Select exact columns and aggregates; opaque raw expressions are deliberately unsupported.
Replace the projection with trusted SQL and an explicit output contract.
Return an independent mutable Knex snapshot.
Render SQL for debugging without executing it.
Add a synchronous group, retaining the group's inferred named parameters.
Match a record of concrete equality values. Use selectors for parameters.
Match a column and infer a named parameter's storage type.
Add a bound comparison using a supported SQL operator.
Match a fixed value tuple or captured SELECT subquery.
JSON-path strings do not provide a schema-derived parameter type.
Optionaloperator: stringOptionalvalue: A & WithoutParameters<NoInfer<A>>Negate equality while preserving ordinary SQL null semantics.
Match SQL null without changing the declared result type.
Trusted SQL with concrete bindings; use a typed predicate for placeholders.
Trusted SQL with concrete bindings; use a typed predicate for placeholders.
Immutable flat joined read. Supply select() before accessing rowSchema or executing.