# Class SQLiteDialect`Abstract`

#### Hierarchy (View Summary)

- SQLiteDialect
  - SQLiteSyncDialect
  - SQLiteAsyncDialect

- 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/dialect.d.ts:14

##### Index

### Constructors

constructor

### Properties

[entityKind]

### Methods

buildDeleteQuery
buildInsertQuery
buildRelationalQuery
buildSelectQuery
buildSetOperationQuery
buildSetOperations
buildUpdateQuery
buildUpdateSet
escapeName
escapeParam
escapeString
sqlToQuery

## Constructors

### constructor

- new SQLiteDialect(config?: SQLiteDialectConfig): SQLiteDialect

  #### Parameters

  - `Optional` config: SQLiteDialectConfig

  #### Returns 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/dialect.d.ts:16

## Properties

### `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/dialect.d.ts:15

## Methods

### buildDeleteQuery

- buildDeleteQuery(__namedParameters: SQLiteDeleteConfig): SQL

  #### Parameters

  - __namedParameters: SQLiteDeleteConfig

  #### Returns SQL

  - 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/dialect.d.ts:21

### buildInsertQuery

- buildInsertQuery(__namedParameters: SQLiteInsertConfig): SQL

  #### Parameters

  - __namedParameters: SQLiteInsertConfig

  #### Returns SQL

  - 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/dialect.d.ts:46

### buildRelationalQuery

- buildRelationalQuery(
  __namedParameters: {
  fullSchema: Record<string, unknown>;
  joinOn?: SQL<unknown>;
  nestedQueryRelation?: Relation<string>;
  queryConfig: true | DBQueryConfig<"many", true>;
  schema: TablesRelationalConfig;
  table: SQLiteTable;
  tableAlias: string;
  tableConfig: TableRelationalConfig;
  tableNamesMap: Record<string, string>;
  },
  ): BuildRelationalQueryResult<
  SQLiteTable<TableConfig>,
  SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>,
  >

  #### Parameters

  - __namedParameters: {
    fullSchema: Record<string, unknown>;
    joinOn?: SQL<unknown>;
    nestedQueryRelation?: Relation<string>;
    queryConfig: true | DBQueryConfig<"many", true>;
    schema: TablesRelationalConfig;
    table: SQLiteTable;
    tableAlias: string;
    tableConfig: TableRelationalConfig;
    tableNamesMap: Record<string, string>;
    }

  #### Returns BuildRelationalQueryResult<
  SQLiteTable<TableConfig>,
  SQLiteColumn<ColumnBaseConfig<ColumnDataType, 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/dialect.d.ts:48

### buildSelectQuery

- buildSelectQuery(__namedParameters: SQLiteSelectConfig): SQL

  #### Parameters

  - __namedParameters: SQLiteSelectConfig

  #### Returns SQL

  - 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/dialect.d.ts:40

### buildSetOperationQuery

- buildSetOperationQuery(
  __namedParameters: {
  leftSelect: SQL;
  setOperator: {
  isAll: boolean;
  limit?: number | Placeholder<string, any>;
  offset?: number | Placeholder<string, any>;
  orderBy?: (
  | SQL<unknown>
  | Aliased<unknown>
  | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
  )[];
  rightSelect: TypedQueryBuilder<any, any>;
  type: SetOperator;
  };
  },
  ): SQL

  #### Parameters

  - __namedParameters: {
    leftSelect: SQL;
    setOperator: {
    isAll: boolean;
    limit?: number | Placeholder<string, any>;
    offset?: number | Placeholder<string, any>;
    orderBy?: (
    | SQL<unknown>
    | Aliased<unknown>
    | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
    )[];
    rightSelect: TypedQueryBuilder<any, any>;
    type: SetOperator;
    };
    }

  #### Returns SQL

  - 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/dialect.d.ts:42

### buildSetOperations

- buildSetOperations(
  leftSelect: SQL,
  setOperators: {
  isAll: boolean;
  limit?: number | Placeholder<string, any>;
  offset?: number | Placeholder<string, any>;
  orderBy?: (
  | SQL<unknown>
  | Aliased<unknown>
  | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
  )[];
  rightSelect: TypedQueryBuilder<any, any>;
  type: SetOperator;
  }[],
  ): SQL

  #### Parameters

  - leftSelect: SQL
  - setOperators: {
    isAll: boolean;
    limit?: number | Placeholder<string, any>;
    offset?: number | Placeholder<string, any>;
    orderBy?: (
    | SQL<unknown>
    | Aliased<unknown>
    | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
    )[];
    rightSelect: TypedQueryBuilder<any, any>;
    type: SetOperator;
    }[]

  #### Returns SQL

  - 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/dialect.d.ts:41

### buildUpdateQuery

- buildUpdateQuery(__namedParameters: SQLiteUpdateConfig): SQL

  #### Parameters

  - __namedParameters: SQLiteUpdateConfig

  #### Returns SQL

  - 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/dialect.d.ts:23

### buildUpdateSet

- buildUpdateSet(table: SQLiteTable, set: UpdateSet): SQL

  #### Parameters

  - table: SQLiteTable
  - set: UpdateSet

  #### Returns SQL

  - 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/dialect.d.ts:22

### escapeName

- escapeName(name: string): string

  #### Parameters

  - name: string

  #### Returns 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/dialect.d.ts:17

### escapeParam

- escapeParam(_num: number): string

  #### Parameters

  - _num: number

  #### Returns 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/dialect.d.ts:18

### escapeString

- escapeString(str: string): string

  #### Parameters

  - str: string

  #### Returns 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/dialect.d.ts:19

### sqlToQuery

- sqlToQuery(sql: SQL, invokeSource?: "indexes"): QueryWithTypings

  #### Parameters

  - sql: SQL
  - `Optional` invokeSource: "indexes"

  #### Returns QueryWithTypings

  - 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/dialect.d.ts:47