Class SchemaQueryBuilder<TLocalSchema, TResult>

Type Parameters

TLocalSchema extends ObjectSchemaBuilder<any, any, any, any, any, any, any>
TResult

Constructors

constructor

new SchemaQueryBuilder<
    TLocalSchema extends
        ObjectSchemaBuilder<any, any, any, any, any, any, any>,
    TResult,
>(
    knex: Knex,
    localSchema: TLocalSchema,
    baseQuery?: QueryBuilder<any, any>,
): SchemaQueryBuilder<TLocalSchema, TResult>
Type Parameters
- TLocalSchema extends ObjectSchemaBuilder<any, any, any, any, any, any, any>
- TResult
Parameters
- knex: Knex
- localSchema: TLocalSchema
- OptionalbaseQuery: QueryBuilder<any, any>
Returns SchemaQueryBuilder<TLocalSchema, TResult>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:148

Methods

andWhere

andWhere(column: ColumnRef<TLocalSchema>, operator: string, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:249
andWhere(column: ColumnRef<TLocalSchema>, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:254
andWhere(record: Record<string, any>): this
Parameters
- record: Record<string, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:255
andWhere(callback: (builder: QueryBuilder) => void): this
Parameters
- callback: (builder: QueryBuilder) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:256
andWhere(raw: Raw): this
Parameters
- raw: Raw
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:257

apply

apply(fn: (builder: QueryBuilder) => void): this
Parameters
- fn: (builder: QueryBuilder) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:674

avg

avg(column: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:210

bulkInsert

bulkInsert(
    rows: InsertType<TLocalSchema>[],
    opts?: {
        chunkSize?: number;
        conflictColumns?: ColumnRef<TLocalSchema>[];
        onConflict?: "merge" | "ignore";
    },
): Promise<TResult[]>
Parameters
- rows: InsertType<TLocalSchema>[]
- Optionalopts: {
      chunkSize?: number;
      conflictColumns?: ColumnRef<TLocalSchema>[];
      onConflict?: "merge" | "ignore";
  }
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:477

bulkUpdate

bulkUpdate(
    updates: readonly {
        set: Partial<InferType<TLocalSchema>>;
        where: Partial<InferType<TLocalSchema>>;
    }[],
): Promise<number>
Parameters
- updates: readonly {
  set: Partial<InferType<TLocalSchema>>;
  where: Partial<InferType<TLocalSchema>>;
  }[]
Returns Promise<number>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:506

bulkUpsert

bulkUpsert(
rows: InsertType<TLocalSchema>[],
opts: { chunkSize?: number; conflictColumns: ColumnRef<TLocalSchema>[] },
): Promise<TResult[]>
Parameters
- rows: InsertType<TLocalSchema>[]
- opts: { chunkSize?: number; conflictColumns: ColumnRef<TLocalSchema>[] }
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:488

count

count(column?: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- Optionalcolumn: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:190

countDistinct

countDistinct(column?: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- Optionalcolumn: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:194

delete

delete(): Promise<number>
Returns Promise<number>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:519

distinct

distinct(...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]): this
Parameters
- ...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:186

execute

execute(): Promise<TResult[]>
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:737

first

first(): Promise<TResult | undefined>
Returns Promise<TResult | undefined>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:741

groupBy

groupBy(...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]): this
Parameters
- ...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:394

groupByRaw

groupByRaw(sql: string, ...bindings: any[]): this
Parameters
- sql: string
- ...bindings: any[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:398

hardDelete

hardDelete(): Promise<number>
Returns Promise<number>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:531

having

having(
    column: Raw<any> | ColumnRef<TLocalSchema>,
    operator: string,
    value: any,
): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:402

havingRaw

havingRaw(sql: string, ...bindings: any[]): this
Parameters
- sql: string
- ...bindings: any[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:410

include

include(
relationName: string,
customize?: (q: SchemaQueryBuilder<any, any>) => void,
): this
Parameters
- relationName: string
- Optionalcustomize: (q: SchemaQueryBuilder<any, any>) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:589

includeVariant

includeVariant(
    variantKey: string,
    relationName: string,
    customize?: (q: SchemaQueryBuilder<any, any>) => void,
): this
Parameters
- variantKey: string
- relationName: string
- Optionalcustomize: (q: SchemaQueryBuilder<any, any>) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:596

insert

insert(data: InsertType<TLocalSchema>): Promise<TResult>
Parameters
- data: InsertType<TLocalSchema>
Returns Promise<TResult>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:450

insertMany

insertMany(data: InsertType<TLocalSchema>[]): Promise<TResult[]>
Parameters
- data: InsertType<TLocalSchema>[]
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:454

joinMany

joinMany<
    TForeignSchema extends
        ObjectSchemaBuilder<any, any, any, any, any, any, any>,
    TFieldName extends string,
>(
    spec: JoinManySpec<TLocalSchema, TForeignSchema, TFieldName>,
): SchemaQueryBuilder<
    TLocalSchema,
    WithJoinedMany<TResult, TFieldName, TForeignSchema>,
>
Type Parameters
- TForeignSchema extends ObjectSchemaBuilder<any, any, any, any, any, any, any>
- TFieldName extends string
Parameters
- spec: JoinManySpec<TLocalSchema, TForeignSchema, TFieldName>
Returns SchemaQueryBuilder<
TLocalSchema,
WithJoinedMany<TResult, TFieldName, TForeignSchema>,
>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:569

joinOne

joinOne<
    TForeignSchema extends
        ObjectSchemaBuilder<any, any, any, any, any, any, any>,
    TFieldName extends string,
    TRequired extends boolean = true,
>(
    spec: JoinOneSpec<TLocalSchema, TForeignSchema, TFieldName, TRequired>,
): SchemaQueryBuilder<
    TLocalSchema,
    WithJoinedOne<TResult, TFieldName, TForeignSchema, TRequired>,
>
Type Parameters
- TForeignSchema extends ObjectSchemaBuilder<any, any, any, any, any, any, any>
- TFieldName extends string
- TRequired extends boolean = true
Parameters
- spec: JoinOneSpec<TLocalSchema, TForeignSchema, TFieldName, TRequired>
Returns SchemaQueryBuilder<
TLocalSchema,
WithJoinedOne<TResult, TFieldName, TForeignSchema, TRequired>,
>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:543

limit

limit(n: number): this
Parameters
- n: number
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:418

max

max(column: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:202

min

min(column: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:198

offset

offset(n: number): this
Parameters
- n: number
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:422

onConflict

onConflict(
...conflictColumns: ColumnRef<TLocalSchema>[],
): OnConflictBuilder<TLocalSchema, TResult>
Parameters
- ...conflictColumns: ColumnRef<TLocalSchema>[]
Returns OnConflictBuilder<TLocalSchema, TResult>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:458

onlyDeleted

onlyDeleted(): this
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:527

orderBy

orderBy(
column: Raw<any> | ColumnRef<TLocalSchema>,
direction?: "asc" | "desc",
): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
- Optionaldirection: "asc" | "desc"
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:379

orderByRaw

orderByRaw(sql: string, ...bindings: any[]): this
Parameters
- sql: string
- ...bindings: any[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:386

orWhere

orWhere(column: ColumnRef<TLocalSchema>, operator: string, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:262
orWhere(column: ColumnRef<TLocalSchema>, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:267
orWhere(record: Record<string, any>): this
Parameters
- record: Record<string, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:268
orWhere(callback: (builder: QueryBuilder) => void): this
Parameters
- callback: (builder: QueryBuilder) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:269
orWhere(raw: Raw): this
Parameters
- raw: Raw
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:270

orWhereIn

orWhereIn(
column: ColumnRef<TLocalSchema>,
values: readonly any[] | QueryBuilder<any, any>,
): this
Parameters
- column: ColumnRef<TLocalSchema>
- values: readonly any[] | QueryBuilder<any, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:302

orWhereNotIn

orWhereNotIn(
column: ColumnRef<TLocalSchema>,
values: readonly any[] | QueryBuilder<any, any>,
): this
Parameters
- column: ColumnRef<TLocalSchema>
- values: readonly any[] | QueryBuilder<any, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:309

orWhereNotNull

orWhereNotNull(column: ColumnRef<TLocalSchema>): this
Parameters
- column: ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:328

orWhereNull

orWhereNull(column: ColumnRef<TLocalSchema>): this
Parameters
- column: ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:324

paginate

paginate(
opts: { page: number; pageSize: number },
): Promise<PaginationResult<TResult>>
Parameters
- opts: { page: number; pageSize: number }
Returns Promise<PaginationResult<TResult>>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:426

paginateAfter

paginateAfter(
    opts: {
        column?: ColumnRef<TLocalSchema>;
        cursor?: any;
        direction?: "asc" | "desc";
        limit: number;
    },
): Promise<CursorPaginationResult<TResult>>
Parameters
- opts: {
      column?: ColumnRef<TLocalSchema>;
      cursor?: any;
      direction?: "asc" | "desc";
      limit: number;
  }
Returns Promise<CursorPaginationResult<TResult>>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:435

pluck

pluck<K extends string>(column: ColumnRef<TLocalSchema>): Promise<TResult[K][]>
Type Parameters
- K extends string
Parameters
- column: ColumnRef<TLocalSchema>
Returns Promise<TResult[K][]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:749

projected

projected<K extends string>(
    name: K,
): SchemaQueryBuilder<
    TLocalSchema,
    Pick<TResult, ProjectionKeysOf<TLocalSchema, K> & keyof TResult>,
>
Type Parameters
- K extends string
Parameters
- name: K
Returns SchemaQueryBuilder<
TLocalSchema,
Pick<TResult, ProjectionKeysOf<TLocalSchema, K> & keyof TResult>,
>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:218

restore

restore(): Promise<TResult[]>
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:535

scoped

scoped<K extends never>(name: K): this
Type Parameters
- K extends never
Parameters
- name: K
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:227

select

select(...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]): this
Parameters
- ...columns: (Raw<any> | ColumnRef<TLocalSchema>)[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:178
select<TSel extends SelectSelector<TLocalSchema>>(
selector: TSel,
): SchemaQueryBuilder<TLocalSchema, SelectProjection<ReturnType<TSel>>>
Type Parameters
- TSel extends SelectSelector<TLocalSchema>
Parameters
- selector: TSel
Returns SchemaQueryBuilder<TLocalSchema, SelectProjection<ReturnType<TSel>>>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:179

selectRaw

selectRaw(sql: string, bindings?: any[]): this
Parameters
- sql: string
- Optionalbindings: any[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:214

selectVariants

selectVariants(keys: string[]): this
Parameters
- keys: string[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:658

sum

sum(column: Raw<any> | ColumnRef<TLocalSchema>): this
Parameters
- column: Raw<any> | ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:206

then

then<TReturn1 = TResult[], TReturn2 = never>(
    onfulfilled?:
        | ((value: TResult[]) => TReturn1 | PromiseLike<TReturn1>)
        | null,
    onrejected?: ((reason: any) => TReturn2 | PromiseLike<TReturn2>) | null,
): Promise<TReturn1 | TReturn2>
Type Parameters
- TReturn1 = TResult[]
- TReturn2 = never
Parameters
- Optionalonfulfilled: ((value: TResult[]) => TReturn1 | PromiseLike<TReturn1>) | null
- Optionalonrejected: ((reason: any) => TReturn2 | PromiseLike<TReturn2>) | null
Returns Promise<TReturn1 | TReturn2>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:761

toKnexQuery

toKnexQuery(): QueryBuilder
Returns QueryBuilder
- Defined in knex-schema/src/SchemaQueryBuilder.ts:729

toQuery

toQuery(): string
Returns string
- Defined in knex-schema/src/SchemaQueryBuilder.ts:725

toString

toString(): string
Returns string
- Defined in knex-schema/src/SchemaQueryBuilder.ts:733

transacting

transacting(trx: Transaction): SchemaQueryBuilder<TLocalSchema, TResult>
Parameters
- trx: Transaction
Returns SchemaQueryBuilder<TLocalSchema, TResult>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:685

unscoped

unscoped(): this
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:231

update

update(data: Partial<InferType<TLocalSchema>>): Promise<TResult[]>
Parameters
- data: Partial<InferType<TLocalSchema>>
Returns Promise<TResult[]>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:502

upsert

upsert(
    data: InsertType<TLocalSchema>,
    opts: {
        conflictColumns: ColumnRef<TLocalSchema>[];
        updateColumns?: ColumnRef<TLocalSchema>[];
    },
): Promise<TResult>
Parameters
- data: InsertType<TLocalSchema>
- opts: {
  conflictColumns: ColumnRef<TLocalSchema>[];
  updateColumns?: ColumnRef<TLocalSchema>[];
  }
Returns Promise<TResult>
- Defined in knex-schema/src/SchemaQueryBuilder.ts:467

where

where(column: ColumnRef<TLocalSchema>, operator: string, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:239
where(column: ColumnRef<TLocalSchema>, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:240
where(raw: Raw, operator: string, value: any): this
Parameters
- raw: Raw
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:241
where(callback: (builder: QueryBuilder) => void): this
Parameters
- callback: (builder: QueryBuilder) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:242
where(record: Record<string, any>): this
Parameters
- record: Record<string, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:243
where(raw: Raw): this
Parameters
- raw: Raw
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:244

whereBetween

whereBetween(column: ColumnRef<TLocalSchema>, range: readonly [any, any]): this
Parameters
- column: ColumnRef<TLocalSchema>
- range: readonly [any, any]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:332

whereExists

whereExists(
callback: QueryBuilder<any, any> | QueryCallback<any, unknown[]>,
): this
Parameters
- callback: QueryBuilder<any, any> | QueryCallback<any, unknown[]>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:358

whereILike

whereILike(column: ColumnRef<TLocalSchema>, value: string): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: string
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:350

whereIn

whereIn(
column: ColumnRef<TLocalSchema>,
values: readonly any[] | QueryBuilder<any, any>,
): this
Parameters
- column: ColumnRef<TLocalSchema>
- values: readonly any[] | QueryBuilder<any, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:288

whereJsonPath

whereJsonPath(
    column: ColumnRef<TLocalSchema>,
    path: string,
    operator?: string,
    value?: any,
): this
Parameters
- column: ColumnRef<TLocalSchema>
- path: string
- Optionaloperator: string
- Optionalvalue: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:366

whereLike

whereLike(column: ColumnRef<TLocalSchema>, value: string): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: string
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:346

whereNot

whereNot(column: ColumnRef<TLocalSchema>, operator: string, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:275
whereNot(column: ColumnRef<TLocalSchema>, value: any): this
Parameters
- column: ColumnRef<TLocalSchema>
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:280
whereNot(record: Record<string, any>): this
Parameters
- record: Record<string, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:281
whereNot(callback: (builder: QueryBuilder) => void): this
Parameters
- callback: (builder: QueryBuilder) => void
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:282
whereNot(raw: Raw): this
Parameters
- raw: Raw
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:283

whereNotBetween

whereNotBetween(
column: ColumnRef<TLocalSchema>,
range: readonly [any, any],
): this
Parameters
- column: ColumnRef<TLocalSchema>
- range: readonly [any, any]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:339

whereNotExists

whereNotExists(
callback: QueryBuilder<any, any> | QueryCallback<any, unknown[]>,
): this
Parameters
- callback: QueryBuilder<any, any> | QueryCallback<any, unknown[]>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:362

whereNotIn

whereNotIn(
column: ColumnRef<TLocalSchema>,
values: readonly any[] | QueryBuilder<any, any>,
): this
Parameters
- column: ColumnRef<TLocalSchema>
- values: readonly any[] | QueryBuilder<any, any>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:295

whereNotNull

whereNotNull(column: ColumnRef<TLocalSchema>): this
Parameters
- column: ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:320

whereNull

whereNull(column: ColumnRef<TLocalSchema>): this
Parameters
- column: ColumnRef<TLocalSchema>
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:316

whereRaw

whereRaw(sql: string, ...bindings: any[]): this
Parameters
- sql: string
- ...bindings: any[]
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:354

whereVariant

whereVariant(key: string, column: string, operator: string, value: any): this
Parameters
- key: string
- column: string
- operator: string
- value: any
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:613

withDeleted

withDeleted(): this
Returns this
- Defined in knex-schema/src/SchemaQueryBuilder.ts:523

Class SchemaQueryBuilder<TLocalSchema, TResult>

Type Parameters

Index

Constructors

Methods

Constructors

constructor

Type Parameters

Parameters

Returns SchemaQueryBuilder<TLocalSchema, TResult>

Methods

andWhere

Parameters

Returns this

Parameters

Returns this

Parameters

Returns this

Parameters

Returns this

Parameters

Returns this

apply

Parameters

Returns this

avg

Parameters

Returns this

bulkInsert

Parameters

Returns Promise<TResult[]>

bulkUpdate

Parameters

Returns Promise<number>

bulkUpsert

Parameters

Returns Promise<TResult[]>

count

Parameters

Returns this

countDistinct

Parameters

Returns this

delete

Returns Promise<number>

distinct

Parameters

Returns this

execute

Returns Promise<TResult[]>

first

Returns Promise<TResult | undefined>

groupBy

Parameters

Returns this

groupByRaw

Parameters

Returns this

hardDelete

Returns Promise<number>

having

Parameters

Returns this

havingRaw

Parameters

Returns this

include

Parameters

Returns this

includeVariant

Parameters

Returns this

insert

Parameters

Returns Promise<TResult>

insertMany

Parameters

Returns Promise<TResult[]>

joinMany

Type Parameters

Returns SchemaQueryBuilder<
TLocalSchema,
WithJoinedMany<TResult, TFieldName, TForeignSchema>,
>

Returns SchemaQueryBuilder<
TLocalSchema,
WithJoinedOne<TResult, TFieldName, TForeignSchema, TRequired>,
>

Returns SchemaQueryBuilder<
TLocalSchema,
Pick<TResult, ProjectionKeysOf<TLocalSchema, K> & keyof TResult>,
>