Vigia

将 objection 从 3.x 升级到 4.x

根据 TypeScript 类型自动比较 objection 3.9.1 与 4.0.0 的公开 API。签名变化表示可能存在不兼容变更，并非确定结论。

概要

已删除的导入路径0
已删除的导出24
已修改的签名28
已删除的类或接口成员7
已修改的类或接口成员256
新增弃用0
要求变化（engines、peer 依赖）3
新增导出23

已删除的导出

importexportkind之前
objectionXtypePromise<T>
objectionTrimtypeS 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
objectionItemTypetypeT extends unknown[] ? T[number] : T
objectionCountChartypeS extends `${string}${C}${infer R}` ? CountChar<R, C, [...N, 0]> : N["length"]
objectionSplitListtypeS extends `${infer Head},${infer Rest}` ? IsBalanced<`${Acc}${Head}`> extends true ? SplitList<Rest, "", [...Out, `${Acc}${Head}`]> : SplitList<Rest, `${Acc}${Head},`, Out> : [...Out, `${Acc}${S}`]
objectionWithGraphtype[keyof T] extends [never] ? M : WithGraphRelations<M, T, FetchedRelations<M, T>>
objectionIsBalancedtypeCountChar<S, "[", []> extends CountChar<S, "]", []> ? CountChar<S, "(", []> extends CountChar<S, ")", []> ? true : false : false
objectionWhitespacetype" " | "\n" | "\r" | "\t"
objectionRelationNametypeTrim<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
objectionRelationNodetype[Name] extends [never] ? {} : { [K in Name]: Children; }
objectionReturningMethodinterfaceinterface
objectionParseRelationListtypeL extends [infer H extends string, ...infer T extends string[]] ? ParseRelationList<T, Acc & ParseRelationString<H>> : Acc
objectionPartialModelPropstype{ [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (Exclude<T[K], undefined> extends Model | Model[] ? never : any) | undefined; }
objectionWithGraphPropertytype[keyof T] extends [never] ? P : P extends (infer I)[] ? WithGraph<I, T>[] : P extends Model ? WithGraph<P, T> : P
objectionParseRelationObjecttypestring 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]> : {}; }
objectionParseRelationStringtypeTrim<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>, {}>
objectionInsertableGraphFieldtypeNonNullable<F> extends (infer I extends Model)[] ? (InsertableGraphReference | InsertableGraph<I>)[] : NonNullable<F> extends infer I extends Model ? InsertableGraphReference | InsertableGraph<I> | Extract<F, null> : never
objectionRelationPropertyNamestype{ [K in keyof M]-?: NonNullable<M[K]> extends Model | Model[] ? K : never; }[keyof M]
objectionInsertablePropertyNamestypeExclude<NonFunctionPropertyNames<M>, "QueryBuilderType"> extends RelationPropertyNames<M> ? never : Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">
objectionTypedRelationMappingFortypeNonNullable<T> extends (infer I extends Model)[] ? TypedRelationMapping<I, HasManyRelationType | ManyToManyRelationType> : NonNullable<T> extends infer I extends Model ? TypedRelationMapping<I, BelongsToOneRelationType | HasOneRelationType | HasOneThroughRelationType> : never
objectionInsertableGraphReferencetype{ '#dbRef': any; } | { '#ref': string; }
objectionTypedModelClassSpecifiertypestring | ModelConstructor<M> | (() => ModelConstructor<M>)
objectionWithGraphModelQueryBuildertypeM extends unknown ? WithGraph<M, ParseRelationExpression<E>>["QueryBuilderType"] : never
objectionOptionalInsertPropertyNamestype{ [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]

已修改的签名

export之前之后
objection · DBErroranyclass
objection · DataErroranyclass
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 · AnyQueryBuilderQueryBuilder<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 · PageQueryBuilderT["PageQueryBuilderType"]QB["~page"]
objection · ArrayQueryBuilderT["ArrayQueryBuilderType"]QB["~array"]
objection · DataPropertyNamesNonFunctionPropertyNames<T> extends "QueryBuilderType" ? never : NonFunctionPropertyNames<T>NonFunctionPropertyNames<T> extends ModelTypeMembers | `$${string}` ? never : NonFunctionPropertyNames<T>
objection · PartialModelGraphT extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : neverT extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : never
objection · NumberQueryBuilderT["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 · SingleQueryBuilderT["SingleQueryBuilderType"]QB["~single"]
objection · CheckViolationErroranyclass
objection · RelatedQueryBuilderT extends Model ? SingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : neverT extends Model ? MaybeSingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : never
objection · UniqueViolationErroranyclass
objection · NotNullViolationErroranyclass
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 · MaybeSingleQueryBuilderQB["MaybeSingleQueryBuilderType"]QB["~maybeSingle"]
objection · ParseRelationExpressionstring extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E>[E] extends [never] ? {} : string extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E>
objection · ConstraintViolationErroranyclass
objection · ForeignKeyViolationErroranyclass
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

已删除的类或接口成员

memberimport之前
QueryBuilder.skipUndefinedobjection(): QueryBuilder<M, R>
QueryBuilder.PageQueryBuilderTypeobjectionQueryBuilder<M, Page<M>>
QueryBuilder.ArrayQueryBuilderTypeobjectionQueryBuilder<M, M[]>
QueryBuilder.NumberQueryBuilderTypeobjectionQueryBuilder<M, number>
QueryBuilder.SingleQueryBuilderTypeobjectionQueryBuilder<M, M>
QueryBuilder.MaybeSingleQueryBuilderTypeobjectionQueryBuilder<M, M | undefined>
InsertGraphOptions.allowMarkersobjectionboolean | undefined

已修改的类或接口成员

member之前之后
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.QueryBuilderTypeQueryBuilder<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 jsonSchemaJSONSchema{ 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 virtualAttributesstring[]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.jsonSchemaJSONSchema{ 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.virtualAttributesstring[]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.resultR | undefinedR

新增弃用

未发现。

要求变化（engines、peer 依赖）

之前之后
engines.node>=14.0.0^20.19.0 || >=22.12.0
peerDependencies.knex>=2.3.0 <4^3.3.0
peerDependencies.typescript—>=5.8
新增导出 (23)
importexportkind
objectionasArrayvariable
objectionExtraTypetype
objectionFromModeltype
objectionModelJsontype
objectionwrapErrorfunction
objectionColumnNametype
objectionQueryExtrainterface
objectionTypeConfiginterface
objectionJoinAliasesinterface
objectionSelectedBrandtype
objectionExtractedBrandtype
objectionFromJSONSchematype
objectionAsArrayFunctioninterface
objectionPartialModelRowtype
objectionReturningWritesinterface
objectionWhereLikeMethodinterface
objectionJsonColumnFormattype
objectionModifyJoinMethodinterface
objectionClearSelectMethodinterface
objectionPartialModelPatchtype
objectionReadonlyJSONSchematype
objectionDatabaseJsonOptionsinterface
objectionBelongsToManyRelationTypeinterface

把这些数据交给你的 AI 智能体

Vigia 是免费的 MCP 服务器：你的编程智能体在写代码之前就能检查版本、不兼容变更和安全漏洞。无需注册，无需 API 密钥。

claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp

添加到 Cursor添加到 VS Code★ 在 GitHub 上加星

任何其他 MCP 客户端
{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }

智能体技能（SKILL.md）：告诉智能体何时使用 Vigia · 用于拉取请求的 GitHub Action

常见问题

将 objection 从 3 升级到 4 有哪些不兼容变更？

在 objection 3.9.1 与 4.0.0 之间，Vigia 发现 24 个已删除的导出、28 个已修改的签名，以及 263 个已删除或修改的类或接口成员。

objection 4 中弃用了哪些内容？

objection 4.0.0 中有 0 个导出或成员新被标记为弃用。

供智能体使用

GET https://vigia.coredls.cloud/v1/packages/npm/objection/upgrade?from=3.9.1&to=4.0.0