# Class SQLiteInsertBuilder<TTable, TResultType, TRunResult>

#### Type Parameters

- TTable extends SQLiteTable
- TResultType extends "sync" | "async"
- TRunResult

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:32

##### Index

### Constructors

constructor

### Properties

dialect
session
table
[entityKind]

### Methods

select
values

## Constructors

### constructor

- new SQLiteInsertBuilder<
  TTable extends SQLiteTable<TableConfig>,
  TResultType extends "sync" | "async",
  TRunResult,
  >(
  table: TTable,
  session: SQLiteSession<any, any, any, any>,
  dialect: SQLiteDialect,
  withList?: Subquery<string, Record<string, unknown>>[],
  ): SQLiteInsertBuilder<TTable, TResultType, TRunResult>

  #### Type Parameters

  - TTable extends SQLiteTable<TableConfig>
  - TResultType extends "sync" | "async"
  - TRunResult

  #### Parameters

  - table: TTable
  - session: SQLiteSession<any, any, any, any>
  - dialect: SQLiteDialect
  - `Optional` withList: Subquery<string, Record<string, unknown>>[]

  #### Returns SQLiteInsertBuilder<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:38

## Properties

### `Protected` dialect

dialect: SQLiteDialect

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:35

### `Protected` session

session: SQLiteSession<any, any, any, any>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:34

### `Protected` table

table: TTable

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:33

### `Static` `Readonly`[entityKind]

"[entityKind]": string

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:37

## Methods

### select

- select(
  selectQuery: (
  qb: QueryBuilder,
  ) => SQLiteInsertSelectQueryBuilder<TTable>,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - selectQuery: (qb: QueryBuilder) => SQLiteInsertSelectQueryBuilder<TTable>

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:41
- select(
  selectQuery: (qb: QueryBuilder) => SQL,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - selectQuery: (qb: QueryBuilder) => SQL

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:42
- select(selectQuery: SQL): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - selectQuery: SQL

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:43
- select(
  selectQuery: SQLiteInsertSelectQueryBuilder<TTable>,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - selectQuery: SQLiteInsertSelectQueryBuilder<TTable>

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:44

### values

- values(
  value: {
  [K in string | number | symbol]: {
  [Key in string | number | symbol]:
  | SQL<unknown>
  | Placeholder<string, any>
  | TTable["$inferInsert"][Key]
  }[K]
  },
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - value: {
    [K in string | number | symbol]: {
    [Key in string | number | symbol]:
    | SQL<unknown>
    | Placeholder<string, any>
    | TTable["$inferInsert"][Key]
    }[K]
    }

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:39
- values(
  values: {
  [K in string | number | symbol]: {
  [Key in string | number | symbol]:
  | SQL<unknown>
  | Placeholder<string, any>
  | TTable["$inferInsert"][Key]
  }[K]
  }[],
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  #### Parameters

  - values: {
    [K in string | number | symbol]: {
    [Key in string | number | symbol]:
    | SQL<unknown>
    | Placeholder<string, any>
    | TTable["$inferInsert"][Key]
    }[K]
    }[]

  #### Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/insert.d.ts:40