# Class SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

#### Type Parameters

- TSelection extends SelectedFields | undefined
- TResultType extends "sync" | "async"
- TRunResult
- TBuilderMode extends "db" | "qb" = "db"

- 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/select.d.ts:18

##### Index

### Constructors

constructor

### Properties

[entityKind]

### Methods

from

## Constructors

### constructor

- new SQLiteSelectBuilder<
  TSelection extends SelectedFields
  | undefined,
  TResultType extends "sync" | "async",
  TRunResult,
  TBuilderMode extends "db" | "qb" = "db",
  >(
  config: {
  dialect: SQLiteDialect;
  distinct?: boolean;
  fields: TSelection;
  session: SQLiteSession<any, any, any, any> | undefined;
  withList?: Subquery<string, Record<string, unknown>>[];
  },
  ): SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

  #### Type Parameters

  - TSelection extends SelectedFields | undefined
  - TResultType extends "sync" | "async"
  - TRunResult
  - TBuilderMode extends "db" | "qb" = "db"

  #### Parameters

  - config: {
    dialect: SQLiteDialect;
    distinct?: boolean;
    fields: TSelection;
    session: SQLiteSession<any, any, any, any> | undefined;
    withList?: Subquery<string, Record<string, unknown>>[];
    }

  #### Returns SQLiteSelectBuilder<TSelection, TResultType, TRunResult, TBuilderMode>

  - 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/select.d.ts:25

## 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/query-builders/select.d.ts:19

## Methods

### from

- from<
  TFrom extends
  | SQLiteTable<TableConfig>
  | SQLiteViewBase<string, boolean, ColumnsSelection>
  | SQL<unknown>
  | Subquery<string, Record<string, unknown>>,
  >(
  source: TFrom,
  ): CreateSQLiteSelectFromBuilderMode<
  TBuilderMode,
  GetSelectTableName<TFrom>,
  TResultType,
  TRunResult,
  TSelection extends undefined ? GetSelectTableSelection<TFrom> : TSelection,
  TSelection extends undefined ? "single" : "partial",
  >

  #### Type Parameters

  - TFrom extends
    | SQLiteTable<TableConfig>
    | SQLiteViewBase<string, boolean, ColumnsSelection>
    | SQL<unknown>
    | Subquery<string, Record<string, unknown>>

  #### Parameters

  - source: TFrom

  #### Returns CreateSQLiteSelectFromBuilderMode<
  TBuilderMode,
  GetSelectTableName<TFrom>,
  TResultType,
  TRunResult,
  TSelection extends undefined ? GetSelectTableSelection<TFrom> : TSelection,
  TSelection extends undefined ? "single" : "partial",
  >

  - 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/select.d.ts:32