# Interface SQLiteSelectConfig

interface SQLiteSelectConfig {
distinct?: boolean;
fields: Record<string, unknown>;
fieldsFlat?: SelectedFieldsOrdered;
groupBy?: (
| SQL<unknown>
| Aliased<unknown>
| SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
)[];
having?: SQL<unknown>;
joins?: SQLiteSelectJoinConfig[];
limit?: number | Placeholder<string, any>;
offset?: number | Placeholder<string, any>;
orderBy?: (
| SQL<unknown>
| Aliased<unknown>
| SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
)[];
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;
}[];
table: | SQLiteTable<TableConfig>
| SQLiteViewBase<string, boolean, ColumnsSelection>
| SQL<unknown>
| Subquery<string, Record<string, unknown>>;
where?: SQL<unknown>;
withList?: Subquery<string, Record<string, unknown>>[];
}

- 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.types.d.ts:24

##### Index

### Properties

distinct?
fields
fieldsFlat?
groupBy?
having?
joins?
limit?
offset?
orderBy?
setOperators
table
where?
withList?

## Properties

### `Optional` distinct

distinct?: boolean

- 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.types.d.ts:36

### fields

fields: Record<string, unknown>

- 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.types.d.ts:26

### `Optional` fieldsFlat

fieldsFlat?: SelectedFieldsOrdered

- 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.types.d.ts:27

### `Optional` groupBy

groupBy?: (
| SQL<unknown>
| Aliased<unknown>
| 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/query-builders/select.types.d.ts:35

### `Optional` having

having?: SQL<unknown>

- 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.types.d.ts:29

### `Optional` joins

joins?: SQLiteSelectJoinConfig[]

- 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.types.d.ts:33

### `Optional` limit

limit?: number | Placeholder<string, 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/select.types.d.ts:31

### `Optional` offset

offset?: number | Placeholder<string, 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/select.types.d.ts:32

### `Optional` orderBy

orderBy?: (
| SQL<unknown>
| Aliased<unknown>
| 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/query-builders/select.types.d.ts:34

### setOperators

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;
}[]

- 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.types.d.ts:37

### table

table:
| SQLiteTable<TableConfig>
| SQLiteViewBase<string, boolean, ColumnsSelection>
| SQL<unknown>
| Subquery<string, Record<string, unknown>>

- 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.types.d.ts:30

### `Optional` where

where?: SQL<unknown>

- 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.types.d.ts:28

### `Optional` withList

withList?: Subquery<string, Record<string, unknown>>[]

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