Documentation
Preparing search index...
@rivetkit/db
drizzle/mod
SQLiteSelectConfig
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
>
>
[]
;
}
Index
Properties
distinct?
fields
fields
Flat?
group
By?
having?
joins?
limit?
offset?
order
By?
set
Operators
table
where?
with
List?
Properties
Optional
distinct
distinct
?:
boolean
fields
fields
:
Record
<
string
,
unknown
>
Optional
fields
Flat
fieldsFlat
?:
SelectedFieldsOrdered
Optional
group
By
groupBy
?:
(
|
SQL
<
unknown
>
|
Aliased
<
unknown
>
|
SQLiteColumn
<
ColumnBaseConfig
<
ColumnDataType
,
string
>
,
{}
,
{}
>
)
[]
Optional
having
having
?:
SQL
<
unknown
>
Optional
joins
joins
?:
SQLiteSelectJoinConfig
[]
Optional
limit
limit
?:
number
|
Placeholder
<
string
,
any
>
Optional
offset
offset
?:
number
|
Placeholder
<
string
,
any
>
Optional
order
By
orderBy
?:
(
|
SQL
<
unknown
>
|
Aliased
<
unknown
>
|
SQLiteColumn
<
ColumnBaseConfig
<
ColumnDataType
,
string
>
,
{}
,
{}
>
)
[]
set
Operators
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
table
:
|
SQLiteTable
<
TableConfig
>
|
SQLiteViewBase
<
string
,
boolean
,
ColumnsSelection
>
|
SQL
<
unknown
>
|
Subquery
<
string
,
Record
<
string
,
unknown
>
>
Optional
where
where
?:
SQL
<
unknown
>
Optional
with
List
withList
?:
Subquery
<
string
,
Record
<
string
,
unknown
>
>
[]
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
On This Page
Properties
distinct
fields
fields
Flat
group
By
having
joins
limit
offset
order
By
set
Operators
table
where
with
List
Documentation
Loading...