Upgrading objection from 3.x to 4.x
Comparison of the public API of objection 3.9.1 and 4.0.0, computed automatically from their TypeScript types. A changed signature is a candidate for a breaking change, not a certainty.
Summary
| Removed import paths | 0 |
|---|---|
| Removed exports | 24 |
| Changed signatures | 28 |
| Removed class or interface members | 7 |
| Changed class or interface members | 256 |
| Newly deprecated | 0 |
| Requirement changes (engines, peer dependencies) | 3 |
| New exports | 23 |
Removed exports
| import | export | kind | Before |
|---|---|---|---|
objection | X | type | Promise<T> |
objection | Trim | type | S extends ` ${infer R}` | `
${infer R}` | `\r${infer R}` | `\t${infer R}` ? Trim<R> : S extends `${infer L} ` | `${infer L}
` | `${infer L}\r` | `${infer L}\t` ? Trim<L> : S |
objection | ItemType | type | T extends unknown[] ? T[number] : T |
objection | CountChar | type | S extends `${string}${C}${infer R}` ? CountChar<R, C, [...N, 0]> : N["length"] |
objection | SplitList | type | S extends `${infer Head},${infer Rest}` ? IsBalanced<`${Acc}${Head}`> extends true ? SplitList<Rest, "", [...Out, `${Acc}${Head}`]> : SplitList<Rest, `${Acc}${Head},`, Out> : [...Out, `${Acc}${S}`] |
objection | WithGraph | type | [keyof T] extends [never] ? M : WithGraphRelations<M, T, FetchedRelations<M, T>> |
objection | IsBalanced | type | CountChar<S, "[", []> extends CountChar<S, "]", []> ? CountChar<S, "(", []> extends CountChar<S, ")", []> ? true : false : false |
objection | Whitespace | type | " " | "\n" | "\r" | "\t" |
objection | RelationName | type | Trim<S> extends `${infer Name}(${string})` ? RelationName<Name> : Trim<S> extends infer Name extends string ? Name extends "" | "*" | `^${string}` | `${string} ${string}` | `${string}
${string}` | `${string}\r${string}` | `${string}\t${string}` ? never : string extends Name ? never : Name : never |
objection | RelationNode | type | [Name] extends [never] ? {} : { [K in Name]: Children; } |
objection | ReturningMethod | interface | interface |
objection | ParseRelationList | type | L extends [infer H extends string, ...infer T extends string[]] ? ParseRelationList<T, Acc & ParseRelationString<H>> : Acc |
objection | PartialModelProps | type | { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (Exclude<T[K], undefined> extends Model | Model[] ? never : any) | undefined; } |
objection | WithGraphProperty | type | [keyof T] extends [never] ? P : P extends (infer I)[] ? WithGraph<I, T>[] : P extends Model ? WithGraph<P, T> : P |
objection | ParseRelationObject | type | string extends keyof E ? {} : { [K in keyof E as K extends `$${string}` ? never : false extends E[K] ? never : E[K] extends { $relation: any; } ? never : K]: E[K] extends object ? ParseRelationObject<E[K]> : {}; } |
objection | ParseRelationString | type | Trim<S> extends `[${infer Inner}]` ? ParseRelationList<SplitList<Inner, "", []>, {}> : Trim<S> extends `${infer Head}.${infer Rest}` ? IsBalanced<Head> extends true ? RelationNode<RelationName<Head>, ParseRelationString<Rest>> : {} : RelationNode<RelationName<S>, {}> |
objection | InsertableGraphField | type | NonNullable<F> extends (infer I extends Model)[] ? (InsertableGraphReference | InsertableGraph<I>)[] : NonNullable<F> extends infer I extends Model ? InsertableGraphReference | InsertableGraph<I> | Extract<F, null> : never |
objection | RelationPropertyNames | type | { [K in keyof M]-?: NonNullable<M[K]> extends Model | Model[] ? K : never; }[keyof M] |
objection | InsertablePropertyNames | type | Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType"> extends RelationPropertyNames<M> ? never : Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType"> |
objection | TypedRelationMappingFor | type | NonNullable<T> extends (infer I extends Model)[] ? TypedRelationMapping<I, HasManyRelationType | ManyToManyRelationType> : NonNullable<T> extends infer I extends Model ? TypedRelationMapping<I, BelongsToOneRelationType | HasOneRelationType | HasOneThroughRelationType> : never |
objection | InsertableGraphReference | type | { '#dbRef': any; } | { '#ref': string; } |
objection | TypedModelClassSpecifier | type | string | ModelConstructor<M> | (() => ModelConstructor<M>) |
objection | WithGraphModelQueryBuilder | type | M extends unknown ? WithGraph<M, ParseRelationExpression<E>>["QueryBuilderType"] : never |
objection | OptionalInsertPropertyNames | type | { [K in keyof M]-?: {} extends Pick<M, K> ? K : null extends M[K] ? K : typeof generated extends keyof NonNullable<M[K]> ? K : never; }[keyof M] |
Changed signatures
| export | Before | After |
|---|---|---|
objection · DBError | any | class |
objection · DataError | any | class |
objection · Insertable | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } |
objection · ModelProps | { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? never : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? never : K : T[K] extends Function ? never : K) | undefined; }[keyof T] extends "QueryBuilderType" | undefined ? never : { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? never : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? never : K : T[K] extends Function ? never : K) | undefined; }[keyof T] | Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`> extends RelationPropertyNames<T> ? never : Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`> |
objection · ModelObject | { [P in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]: T[P]; } | { [P in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]: T[P]; } |
objection · ModelRelations | { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? K : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? K : never : never) | undefined; }[keyof T] extends undefined ? never : { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? K : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? K : never : never) | undefined; }[keyof T] | { [K in keyof T]-?: HasModels<NonNullable<T[K]>> extends true ? K : never; }[keyof T] |
objection · WithResultKind | [R] extends [M[]] ? ArrayQueryBuilder<NQB> : [R] extends [Page<M>] ? PageQueryBuilder<NQB> : [R] extends [object | undefined] ? [R] extends [M] ? SingleQueryBuilder<NQB> : [R] extends [M | undefined] ? MaybeSingleQueryBuilder<NQB> : QB : QB | [R] extends [ExtractedRows] ? Rebind<QB, M, WithGraphResult<R, T>, unknown> : [R] extends [M[]] ? ArrayQueryBuilder<NQB> : [R] extends [Page<M>] ? PageQueryBuilder<NQB> : [R] extends [object | undefined] ? [R] extends [M] ? SingleQueryBuilder<NQB> : [R] extends [M | undefined] ? MaybeSingleQueryBuilder<NQB> : Rebind<QB, M, WithGraphResult<R, T>, unknown> : QB |
objection · AnyQueryBuilder | QueryBuilder<any, any> | QueryBuilder<any, any, any> |
objection · InsertableGraph | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } & Omit<GraphParameters, "#dbRef" | "#ref"> & { [K in RelationPropertyNames<M>]?: InsertableGraphField<M[K]> | undefined; } | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } & Omit<GraphParameters, "#dbRef" | "#ref"> & { [K in RelationPropertyNames<M>]?: InsertableGraphField<M[K]> | undefined; } |
objection · PageQueryBuilder | T["PageQueryBuilderType"] | QB["~page"] |
objection · ArrayQueryBuilder | T["ArrayQueryBuilderType"] | QB["~array"] |
objection · DataPropertyNames | NonFunctionPropertyNames<T> extends "QueryBuilderType" ? never : NonFunctionPropertyNames<T> | NonFunctionPropertyNames<T> extends ModelTypeMembers | `$${string}` ? never : NonFunctionPropertyNames<T> |
objection · PartialModelGraph | T extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : never | T extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : never |
objection · NumberQueryBuilder | T["NumberQueryBuilderType"] | QB["~number"] |
objection · PartialModelObject | { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (Exclude<T[K], undefined> extends Model ? T[K] | PartialModelObject<Exclude<T[K], undefined>> : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? I[] | PartialModelObject<I>[] : any : NonNullable<T[K]> extends Model ? any : any) | undefined; } | { [K in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]?: (Exclude<T[K], undefined> extends Model ? T[K] | PartialModelObject<Exclude<T[K], undefined>> : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? I[] | PartialModelObject<I>[] : any : NonNullable<T[K]> extends Model ? any : any) | undefined; } |
objection · RelateQueryBuilder | { returning: RelateReturningMethod<ModelType<QB>>; } & NumberQueryBuilder<QB> | { returning: RelateReturningMethod<ModelType<NQB>>; } & NQB |
objection · SingleQueryBuilder | T["SingleQueryBuilderType"] | QB["~single"] |
objection · CheckViolationError | any | class |
objection · RelatedQueryBuilder | T extends Model ? SingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : never | T extends Model ? MaybeSingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : never |
objection · UniqueViolationError | any | class |
objection · NotNullViolationError | any | class |
objection · WithGraphQueryBuilder | [keyof ParseRelationExpression<E>] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, ParseRelationExpression<E>>] extends [never] ? QB : WithResultKind<QB, WithGraph<ModelType<QB>, ParseRelationExpression<E>>["QueryBuilderType"], ModelType<QB>, ResultType<QB>> : never | [keyof ParseRelationExpression<E>] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, ParseRelationExpression<E>>] extends [never] ? QB : WithResultKind<QB, KeepExtra<WithGraph<ModelType<QB>, ParseRelationExpression<E>>["QueryBuilderType"], ExtraType<QB>>, ModelType<QB>, ResultType<QB>, ParseRelationExpression<E>> : never |
objection · MaybeSingleQueryBuilder | QB["MaybeSingleQueryBuilderType"] | QB["~maybeSingle"] |
objection · ParseRelationExpression | string extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E> | [E] extends [never] ? {} : string extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E> |
objection · ConstraintViolationError | any | class |
objection · ForeignKeyViolationError | any | class |
objection · NonFunctionPropertyNames | { [K in keyof T]: T[K] extends Function ? never : K; }[keyof T] | { [K in keyof T]-?: T[K] extends Function ? never : K; }[keyof T] |
objection · WithGraphTreeQueryBuilder | [keyof T] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, T>] extends [never] ? QB : WithResultKind<QB, WithGraph<ModelType<QB>, T>["QueryBuilderType"], ModelType<QB>, ResultType<QB>> : never | [keyof T] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, T>] extends [never] ? QB : WithResultKind<QB, KeepExtra<WithGraph<ModelType<QB>, T>["QueryBuilderType"], ExtraType<QB>>, ModelType<QB>, ResultType<QB>, T> : never |
Removed class or interface members
| member | import | Before |
|---|---|---|
QueryBuilder.skipUndefined | objection | (): QueryBuilder<M, R> |
QueryBuilder.PageQueryBuilderType | objection | QueryBuilder<M, Page<M>> |
QueryBuilder.ArrayQueryBuilderType | objection | QueryBuilder<M, M[]> |
QueryBuilder.NumberQueryBuilderType | objection | QueryBuilder<M, number> |
QueryBuilder.SingleQueryBuilderType | objection | QueryBuilder<M, M> |
QueryBuilder.MaybeSingleQueryBuilderType | objection | QueryBuilder<M, M | undefined> |
InsertGraphOptions.allowMarkers | objection | boolean | undefined |
Changed class or interface members
| member | Before | After |
|---|---|---|
Model.$query | (trxOrKnex?: any): QueryBuilder<Model, Model> | (trxOrKnex?: any): QueryBuilder<Model, Model, unknown> |
Model.toJSON | (opt?: ToJsonOptions | undefined): ModelObject<Model> | (opt?: ToJsonOptions | undefined): ModelJson<Model> |
Model.$toJson | (opt?: ToJsonOptions | undefined): ModelObject<Model> | (opt?: ToJsonOptions | undefined): ModelJson<Model> |
Model.$fetchGraph | <const E extends RelationExpression<Model>>(expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraph<Model, ParseRelationExpression<E>>["QueryBuilderType"]> | <const E extends RelationExpression<Model>>(expression: E, options?: FetchGraphOptions | undefined): QueryBuilder<WithGraph<Model, ParseRelationExpression<E>>, WithGraph<Model, ParseRelationExpression<E>>, unknown> |
Model.static query | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, trxOrKnex?: any): QueryBuilderType<M> | <M extends Model, C = unknown, K = unknown>(this: ConstructorType<M, PrototypeType<M>>, trxOrKnex?: any): QueryBuilderType<M> |
Model.$setDatabaseJson | (json: object): Model | (json: object, options?: DatabaseJsonOptions | undefined): Model |
Model.QueryBuilderType | QueryBuilder<Model, Model[]> | QueryBuilder<Model, Model[], unknown> |
Model.static afterFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[] | undefined>): any |
Model.static beforeFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static fetchGraph | <M extends Model, const E extends RelationExpression<M> = string>(this: ConstructorType<M, PrototypeType<M>>, modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraphModelQueryBuilder<M, E>> | <M extends Model, const E extends Relati… | <M extends Model, const E extends RelationExpression<M> = string>(this: ConstructorType<M, PrototypeType<M>>, modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): Rebind<QueryBuilderType<M>, WithGraph<M, ParseRelationExpression<E>>, WithGraph<M, ParseRelatio… |
Model.static jsonSchema | JSONSchema | { readonly $id?: string | undefined; readonly $ref?: string | undefined; readonly $schema?: string | undefined; readonly $comment?: string | undefined; readonly $defs?: { readonly [x: string]: boolean | any; } | undefined; readonly type?: string | readonly string[] | undefined; readonly enum?: reado… |
Model.$parseDatabaseJson | (json: Pojo): Pojo | (json: Pojo, options?: DatabaseJsonOptions | undefined): Pojo |
Model.static afterDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
Model.static afterInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[]>): any |
Model.static afterUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
Model.static beforeDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static beforeInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static beforeUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static relatedQuery | <M extends Model, K extends keyof M>(this: ConstructorType<M, PrototypeType<M>>, relationName: K, trxOrKnex?: any): ArrayRelatedQueryBuilder<M[K]> | <RM extends Model>(relationName: string, trxOrKnex?: any): QueryBuilderType<RM> | <M extends Model, K extends keyof M, C = unknown>(this: ConstructorType<M, PrototypeType<M>>, relationName: K, trxOrKnex?: any): ArrayRelatedQueryBuilder<M[K]> | <RM extends Model>(relationName: string, trxOrKnex?: any): QueryBuilderType<RM> |
Model.static fromDatabaseJson | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, json: object): M | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, json: object, options?: DatabaseJsonOptions | undefined): M |
Model.static virtualAttributes | string[] | readonly string[] |
ModelClass.afterFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[] | undefined>): any |
ModelClass.beforeFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.fetchGraph | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraphModelQueryBuilder<M, E>> | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>[], expression: E, options?: Fetch… | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): Rebind<QueryBuilderType<M>, WithGraph<M, ParseRelationExpression<E>>, WithGraph<M, ParseRelationExpression<E>>, unknown> | <const E extends RelationExpression<M>>(mo… |
ModelClass.jsonSchema | JSONSchema | { readonly $id?: string | undefined; readonly $ref?: string | undefined; readonly $schema?: string | undefined; readonly $comment?: string | undefined; readonly $defs?: { readonly [x: string]: boolean | any; } | undefined; readonly type?: string | readonly string[] | undefined; readonly enum?: reado… |
ModelClass.afterDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
ModelClass.afterInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[]>): any |
ModelClass.afterUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
ModelClass.beforeDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.beforeInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.beforeUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.fromDatabaseJson | (json: object): M | (json: object, options?: DatabaseJsonOptions | undefined): M |
ModelClass.virtualAttributes | string[] | readonly string[] |
QueryBuilder.as | (alias: string): QueryBuilder<M, R> | (alias: string): QueryBuilder<M, R, X> |
QueryBuilder.avg | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.del | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.for | (ids: any): QueryBuilder<M, R> | (ids: any): QueryBuilder<M, R, X> |
QueryBuilder.max | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.min | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.sum | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.from | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.into | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.join | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.none | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.page | (page: number, pageSize: number): QueryBuilder<M, Page<M>> | (page: number, pageSize: number): QueryBuilder<M, Page<M>, unknown> |
QueryBuilder.with | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.alias | (arg: string): QueryBuilder<M, R> | (arg: string): QueryBuilder<M, R, X> |
QueryBuilder.clear | (selector: string | RegExp): QueryBuilder<M, R> | (selector: string | RegExp): QueryBuilder<M, R, X> |
QueryBuilder.clone | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.count | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R> | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R, X> | (...columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string… |
QueryBuilder.debug | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.limit | (limit: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (limit: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.merge | (merge?: string[] | PartialModelObject<M> | undefined): QueryBuilder<M, R> | (merge?: string[] | PartialModelPatch<M> | undefined): QueryBuilder<M, R, X> |
QueryBuilder.patch | (update: PartialModelObject<M>): QueryBuilder<M, number> | (): QueryBuilder<M, number> | (update: PartialModelPatch<M>): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.range | (): QueryBuilder<M, Page<M>> | (start: number, end: number): QueryBuilder<M, Page<M>> | (): QueryBuilder<M, Page<M>, unknown> | (start: number, end: number): QueryBuilder<M, Page<M>, unknown> |
QueryBuilder.table | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.union | (arg1: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>… | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<… |
QueryBuilder.where | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.castTo | <MC extends Model>(modelClass: ModelConstructor<MC>): QueryBuilderType<MC> | <R>(): QueryBuilder<M, R> | <MC extends Model>(modelClass: ModelConstructor<MC>): QueryBuilderType<MC> | <R>(): QueryBuilder<M, R, X> |
QueryBuilder.column | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.delete | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.except | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[]): QueryBuilder<M, R> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[], wrap?: boolean | undefined): QueryBuilder<M, R> | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[]): QueryBuilder<M, R, X> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[], wrap?: boolean | undefined): QueryBuilde… |
QueryBuilder.having | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.ignore | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.insert | (insert: PartialModelObject<M>): QueryBuilder<M, M> | (insert: PartialModelObject<M>[]): QueryBuilder<M, M[]> | (): QueryBuilder<M, M> | (insert: PartialModelRow<M>): QueryBuilder<M, M, unknown> | (insert: PartialModelRow<M>[]): QueryBuilder<M, M[], unknown> | (): QueryBuilder<M, M, unknown> |
QueryBuilder.modify | (modifier: Modifier<QueryBuilder<M, R>> | Modifier<QueryBuilder<M, R>>[], ...args: any[]): QueryBuilder<M, R> | (modifier: ModifyArg<QueryBuilder<M, R, X>> | ModifyArg<QueryBuilder<M, R, X>>[], ...args: any[]): QueryBuilder<M, R, X> |
QueryBuilder.noWait | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.offset | (offset: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (offset: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.reject | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.relate | (ids: any): RelateQueryBuilder<QueryBuilder<M, R>> | (ids: any): RelateQueryBuilder<WriteQueryBuilder<QueryBuilder<M, R, X>, M, R>> |
QueryBuilder.select | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.update | (update: PartialModelObject<M>): QueryBuilder<M, number> | (): QueryBuilder<M, number> | (update: PartialModelRow<M>): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.columns | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.context | (context: object): QueryBuilder<M, R> | (): QueryContext | (context: object): QueryBuilder<M, R, X> | (): QueryContext |
QueryBuilder.findOne | <QBP extends QueryBuilder<M, M | undefined>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefin… | <QBP extends QueryBuilder<M, M | undefined, unknown>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, M | und… |
QueryBuilder.fromRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.groupBy | (...columns: any[]): QueryBuilder<M, R> | (columns: any[]): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(...columns: never): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(columns: never)… |
QueryBuilder.joinRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.jsonSet | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, value: any, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any,… |
QueryBuilder.onBuild | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.onError | (cb: OnErrorCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: OnErrorCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.orWhere | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orderBy | (column: any, order?: OrderByDirection | undefined, nulls?: OrderByNulls | undefined): QueryBuilder<M, R> | (columns: any[]): QueryBuilder<M, R> | (column: any, order?: OrderByDirection | undefined, nulls?: OrderByNulls | undefined): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, order?: OrderByDirection | undefined, nulls?: OrderByNulls | und… |
QueryBuilder.resolve | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.timeout | (ms: number, options?: TimeoutOptions | undefined): QueryBuilder<M, R> | (ms: number, options?: TimeoutOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.whereIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.aliasFor | (modelClassOrTableName: string | AnyModelConstructor): string | null | (modelClassOrTableName: string | AnyModelConstructor, alias: string): QueryBuilder<M, R> | (modelClassOrTableName: string | AnyModelConstructor): string | null | (modelClassOrTableName: string | AnyModelConstructor, alias: string): QueryBuilder<M, R, X> |
QueryBuilder.andWhere | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.distinct | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.findById | (id: any): QueryBuilder<M, M | undefined> | (id: any): QueryBuilder<M, M | undefined, unknown> |
QueryBuilder.forShare | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.leftJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.orHaving | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.runAfter | (cb: RunAfterCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: RunAfterCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.unionAll | (arg1: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>… | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<… |
QueryBuilder.unrelate | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.whereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.andHaving | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.crossJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.decrement | (column: string, amount?: number | undefined): QueryBuilder<M, R> | (column: string, amount?: number | undefined): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, amount?: number | undefined): QueryBuilder<M, R, X> |
QueryBuilder.findByIds | (ids: any[]): QueryBuilder<M, R> | (ids: any[]): QueryBuilder<M, R, X> |
QueryBuilder.forUpdate | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.increment | (column: string, amount?: number | undefined): QueryBuilder<M, R> | (column: string, amount?: number | undefined): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, amount?: number | undefined): QueryBuilder<M, R, X> |
QueryBuilder.innerJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.intersect | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[]): QueryBuilder<M, R> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[], wrap?: boolean | undefined): QueryBuilder<M, R> | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[]): QueryBuilder<M, R, X> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[], wrap?: boolean | undefined): QueryBuilde… |
QueryBuilder.modifiers | (modifiers: Modifiers<AnyQueryBuilder>): QueryBuilder<M, R> | (): QueryBuilder<M, R> | <const O extends Modifiers>(modifiers: O): QueryBuilder<M, R, X> | (): QueryBuilder<M, R, X> |
QueryBuilder.orWhereIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.outerJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.patchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, number> | (id: any, update: PartialModelPatch<M>): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.returning | <QB extends AnyQueryBuilder>(this: QB, ...args: ReturningArgs): QB extends NumberQueryBuilder<QB> ? ArrayQueryBuilder<QB> : QB | (...args: ReturningArgs): 0 extends 1 & R ? any : [R] extends [number] ? QueryBuilder<M, M[], unknown> : [R] extends [readonly unknown[] | Page<unknown>] ? QueryBuilder<M, R, X> : ReturningWrites<QueryBuilder<M, R, X>, M, WrittenRows<M, R>> & QueryBuilder<M, R, X> |
QueryBuilder.rightJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.runBefore | (cb: RunBeforeCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: RunBeforeCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.whereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.withGraph | <const E extends RelationExpression<M>>(expr: E, options?: WithGraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: WithGraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.allowGraph | (expr: RelationExpression<M>): QueryBuilder<M, R> | (expr: RelationExpression<M>): QueryBuilder<M, R, X> |
QueryBuilder.clearOrder | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.clearWhere | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.connection | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.deleteById | (id: any): QueryBuilder<M, number> | (id: any): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.distinctOn | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | (...columns: any[]): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(...columns: never): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(columns: never)… |
QueryBuilder.groupByRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.havingNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.jsonInsert | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, value: any, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any,… |
QueryBuilder.jsonRemove | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any, path: strin… |
QueryBuilder.onConflict | (column?: any): QueryBuilder<M, R> | (column?: any): QueryBuilder<M, R, X> |
QueryBuilder.orHavingIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.orWhereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.orderByRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.skipLocked | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.updateById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, number> | (id: any, update: PartialModelRow<M>): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.whereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.withSchema | (arg: string): QueryBuilder<M, R> | (arg: string): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.andWhereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.avgDistinct | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.clearSelect | (): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>>(): ClearSelectQueryBuilder<QBP> |
QueryBuilder.constructor | <M extends Model, R = M[]>(modelClass: ModelConstructor<M>): QueryBuilder<M, R> | <M extends Model, R = M[], X = unknown>(modelClass: ModelConstructor<M>): QueryBuilder<M, R, X> |
QueryBuilder.forKeyShare | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.joinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.jsonExtract | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string = string>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, alias?: A | undefined, singleValue?: boolean … |
QueryBuilder.modifyGraph | <M extends Model>(expr: RelationExpression<M>, modifier: Modifier<QueryBuilderType<M>>): QueryBuilder<M, R> | <M extends Model>(expr: RelationExpression<M>, modifier: Modifier<QueryBuilderType<M>>): QueryBuilder<M, R, X> |
QueryBuilder.onBuildKnex | (cb: OnBuildKnexCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: OnBuildKnexCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.orHavingRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.sumDistinct | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.transacting | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.whereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.whereExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.withWrapped | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.clearContext | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.orWhereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.whereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.whereNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.whereWrapped | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.andWhereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.countDistinct | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R> | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R, X> | (...columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string… |
QueryBuilder.emptyInstance | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.fullOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.havingBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.havingNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.havingWrapped | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.leftOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.orHavingNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.orWhereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orWhereExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.patchAndFetch | (update: PartialModelObject<M>): QueryBuilder<M, M> | (update: PartialModelPatch<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.withRecursive | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.clearWithGraph | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.forNoKeyUpdate | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.insertAndFetch | (insert: PartialModelObject<M>): QueryBuilder<M, M> | (insert: PartialModelObject<M>[]): QueryBuilder<M, M[]> | (): QueryBuilder<M, M> | (insert: PartialModelRow<M>): QueryBuilder<M, M, unknown> | (insert: PartialModelRow<M>[]): QueryBuilder<M, M[], unknown> | (): QueryBuilder<M, M, unknown> |
QueryBuilder.orHavingExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orWhereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.rightOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.updateAndFetch | (update: PartialModelObject<M>): QueryBuilder<M, M> | (update: PartialModelRow<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereComposite | (column: any[], op: string, expr: readonly any[]): QueryBuilder<M, R> | (column: any, expr: any): QueryBuilder<M, R> | (column: any, op: string, expr: any): QueryBuilder<M, R> | (column: any[], expr: readonly any[]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], op: string, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, expr: any): QueryBuilder<M, R, X> | (column: any, op: string, expr: any): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder… |
QueryBuilder.whereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.whereNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.andWhereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.clearAllowGraph | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.leftJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orHavingBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.throwIfNotFound | (arg?: any): R extends Model | undefined ? QueryBuilder<M, M> : QueryBuilder<M, R> | (arg?: any): R extends Model | undefined ? QueryBuilder<M, M, unknown> : QueryBuilder<M, R, X> |
QueryBuilder.whereJsonHasAll | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonHasAny | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.whereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.withGraphJoined | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.andWhereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.havingNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.innerJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orWhereNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.outerJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.rightJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.whereInComposite | (column: any, expr: readonly any[]): QueryBuilder<M, R> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends … |
QueryBuilder.whereJsonIsArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.withGraphFetched | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.withMaterialized | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orHavingNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonHasAll | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonHasAny | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.patchAndFetchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, M> | (id: any, update: PartialModelPatch<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonIsObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonIsArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.updateAndFetchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, M> | (id: any, update: PartialModelRow<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonNotObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonIsObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereNotInComposite | (column: any, expr: readonly any[]): QueryBuilder<M, R> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends … |
QueryBuilder.withNotMaterialized | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.fullOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.leftOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.rightOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
ColumnNameMappers.format | (json: Pojo): Pojo | (json: Pojo, isFieldExpression?: ((key: string) => boolean) | undefined): Pojo |
StaticHookArguments.result | R | undefined | R |
Newly deprecated
None detected.
Requirement changes (engines, peer dependencies)
| Before | After | |
|---|---|---|
engines.node | >=14.0.0 | ^20.19.0 || >=22.12.0 |
peerDependencies.knex | >=2.3.0 <4 | ^3.3.0 |
peerDependencies.typescript | — | >=5.8 |
New exports (23)
| import | export | kind |
|---|---|---|
objection | asArray | variable |
objection | ExtraType | type |
objection | FromModel | type |
objection | ModelJson | type |
objection | wrapError | function |
objection | ColumnName | type |
objection | QueryExtra | interface |
objection | TypeConfig | interface |
objection | JoinAliases | interface |
objection | SelectedBrand | type |
objection | ExtractedBrand | type |
objection | FromJSONSchema | type |
objection | AsArrayFunction | interface |
objection | PartialModelRow | type |
objection | ReturningWrites | interface |
objection | WhereLikeMethod | interface |
objection | JsonColumnFormat | type |
objection | ModifyJoinMethod | interface |
objection | ClearSelectMethod | interface |
objection | PartialModelPatch | type |
objection | ReadonlyJSONSchema | type |
objection | DatabaseJsonOptions | interface |
objection | BelongsToManyRelationType | interface |
Give your AI agent these facts
Vigia is a free MCP server: your coding agent checks versions, breaking changes and vulnerabilities before it writes code. No signup, no API key.
claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp
Add to CursorAdd to VS Code★ Star on GitHub
Any other MCP client
{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }Agent skill (SKILL.md): tells the agent when to use Vigia · GitHub Action for pull requests
Frequently asked questions
What are the breaking changes when upgrading objection from 3 to 4?
Between objection 3.9.1 and 4.0.0, Vigia found 24 removed exports, 28 changed signatures and 263 removed or changed class or interface members.
What became deprecated in objection 4?
0 exports or members are newly marked as deprecated in objection 4.0.0.
For agents
GET https://vigia.coredls.cloud/v1/packages/npm/objection/upgrade?from=3.9.1&to=4.0.0