Preparing search index...
The search index is not available
kysely
kysely
CommonTableExpressionNode
Interface CommonTableExpressionNode
Hierarchy
OperationNode
CommonTableExpressionNode
Index
Properties
expression
kind
materialized?
name
Properties
Readonly
expression
expression
:
OperationNode
Readonly
kind
kind
:
"CommonTableExpressionNode"
Optional
Readonly
materialized
materialized
?:
boolean
Readonly
name
name
:
CommonTableExpressionNameNode
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
expression
kind
materialized
name
kysely
Aggregate
Function
Builder
Aliased
Aggregate
Function
Builder
Aliased
Expression
Wrapper
AliasedJSONPath
Builder
Alter
Column
Builder
Alter
Table
Builder
Alter
Table
Column
Altering
Builder
Altered
Column
Builder
And
Wrapper
Camel
Case
Plugin
Case
Builder
Case
End
Builder
Case
Then
Builder
Case
When
Builder
Column
Definition
Builder
Connection
Builder
Create
Index
Builder
Create
Schema
Builder
Create
Table
Builder
Create
Type
Builder
Create
View
Builder
Deduplicate
Joins
Plugin
Default
Connection
Provider
Default
Query
Compiler
Default
Query
Executor
Delete
Query
Builder
Delete
Result
Dialect
Adapter
Base
Drop
Index
Builder
Drop
Schema
Builder
Drop
Table
Builder
Drop
Type
Builder
Drop
View
Builder
Dummy
Driver
Dynamic
Module
Expression
Wrapper
File
Migration
Provider
Foreign
Key
Constraint
Builder
Insert
Query
Builder
Insert
Result
JSONPath
Builder
Join
Builder
Kysely
Log
Matched
Thenable
Merge
Query
Builder
Merge
Query
Builder
Merge
Result
Migrator
Mssql
Adapter
Mssql
Dialect
Mssql
Driver
Mssql
Introspector
Mssql
Query
Compiler
Mysql
Adapter
Mysql
Dialect
Mysql
Driver
Mysql
Introspector
Mysql
Query
Compiler
No
Result
Error
Noop
Query
Executor
Not
Matched
Thenable
Merge
Query
Builder
On
Conflict
Builder
On
Conflict
Do
Nothing
Builder
On
Conflict
Update
Builder
Operation
Node
Transformer
Operation
Node
Visitor
Or
Wrapper
ParseJSONResults
Plugin
Postgres
Adapter
Postgres
Dialect
Postgres
Driver
Postgres
Introspector
Postgres
Query
Compiler
Query
Creator
Schema
Module
Single
Connection
Provider
Sqlite
Adapter
Sqlite
Dialect
Sqlite
Driver
Sqlite
Introspector
Sqlite
Query
Compiler
Tarn
Pool
Tedious
Request
Transaction
Transaction
Builder
TraversedJSONPath
Builder
Update
Query
Builder
Update
Result
Wheneable
Merge
Query
Builder
With
Schema
Plugin
Add
Column
Node
Add
Constraint
Node
Aggregate
Function
Builder
Props
Aggregate
Function
Node
Alias
Node
Aliasable
Expression
Aliased
Expression
Aliased
Raw
Builder
Aliased
Select
Query
Builder
Alter
Column
Node
Alter
Table
Builder
Props
Alter
Table
Column
Altering
Builder
Props
Alter
Table
Node
And
Node
Binary
Operation
Node
Camel
Case
Plugin
Options
Case
Node
Check
Constraint
Node
Column
Altering
Interface
Column
Definition
Node
Column
Metadata
Column
Node
Column
Update
Node
Common
Table
Expression
Name
Node
Common
Table
Expression
Node
Compilable
Compiled
Query
Connection
Provider
Create
Index
Builder
Props
Create
Index
Node
Create
Schema
Builder
Props
Create
Schema
Node
Create
Table
Builder
Props
Create
Table
Node
Create
Type
Builder
Props
Create
Type
Node
Create
View
Builder
Props
Create
View
Node
Data
Type
Node
Database
Connection
Database
Introspector
Database
Metadata
Database
Metadata
Options
Default
Insert
Value
Node
Default
Value
Node
Delete
Query
Builder
Props
Delete
Query
Node
Dialect
Dialect
Adapter
Driver
Drop
Column
Node
Drop
Constraint
Node
Drop
Index
Builder
Props
Drop
Index
Node
Drop
Schema
Builder
Props
Drop
Schema
Node
Drop
Table
Builder
Props
Drop
Table
Node
Drop
Type
Builder
Props
Drop
Type
Node
Drop
View
Builder
Props
Drop
View
Node
Error
Log
Event
Explain
Node
Explainable
Expression
Expression
Builder
Fetch
Node
File
Migration
ProviderFS
File
Migration
Provider
Path
File
Migration
Provider
Props
Foreign
Key
Constraint
Builder
Interface
Foreign
Key
Constraint
Node
From
Node
Function
Module
Generated
Node
Group
By
Item
Node
Group
By
Node
Having
Interface
Having
Node
Identifier
Node
Insert
Query
Builder
Props
Insert
Query
Node
JSONOperator
Chain
Node
JSONPath
Leg
Node
JSONPath
Node
JSONReference
Node
Join
Builder
Props
Join
Node
Kysely
Config
Kysely
Plugin
Kysely
Props
Limit
Node
List
Node
Matched
Node
Merge
Query
Builder
Props
Merge
Query
Node
Migration
Migration
Info
Migration
Lock
Options
Migration
Provider
Migration
Result
Migration
Result
Set
Migrator
Props
Modify
Column
Node
Mssql
Dialect
Config
Mysql
Dialect
Config
Mysql
Ok
Packet
Mysql
Pool
Mysql
Pool
Connection
Mysql
Stream
Mysql
Stream
Options
No
Migrations
Offset
Node
On
Conflict
Builder
Props
On
Conflict
Node
On
Duplicate
Key
Node
On
Node
Operation
Node
Operation
Node
Source
Operator
Node
Or
Node
Order
By
Item
Node
Order
By
Node
Over
Node
Parens
Node
Partition
By
Item
Node
Partition
By
Node
Plugin
Transform
Query
Args
Plugin
Transform
Result
Args
Postgres
Cursor
Postgres
Dialect
Config
Postgres
Pool
Postgres
Pool
Client
Postgres
Query
Result
Postgres
Stream
Primary
Key
Constraint
Node
Primitive
Value
List
Node
Query
Compiler
Query
Creator
Props
Query
Executor
Query
Log
Event
Query
Result
Raw
Builder
Raw
Builder
Props
Raw
Node
Reference
Node
References
Node
Rename
Column
Node
Returning
Interface
Returning
Node
Schema
Metadata
Select
All
Node
Select
Query
Builder
Select
Query
Builder
Props
Select
Query
Node
Selection
Node
Set
Operation
Node
Sql
Sqlite
Database
Sqlite
Dialect
Config
Sqlite
Statement
Streamable
Table
Metadata
Table
Node
Tarn
Tarn
Pending
Request
Tarn
Pool
Options
Tedious
Tedious
Column
Value
Tedious
Connection
Tedious
Type
Top
Node
Transaction
Settings
Tuple
Node
Unary
Operation
Node
Unique
Constraint
Node
Update
Query
Builder
Props
Update
Query
Node
Using
Node
Value
List
Node
Value
Node
Values
Node
When
Node
Where
Interface
Where
Node
With
Node
Alter
Column
Builder
Callback
Alter
Column
Node
Props
Alter
Table
Column
Alteration
Node
Alter
Table
Node
Table
Props
Any
Aliased
Column
Any
Aliased
Column
With
Table
Any
Column
Any
Column
With
Table
Arithmetic
Operator
Binary
Operator
Callback
Selection
Column
Builder
Callback
Column
Data
Type
Column
Definition
Builder
Callback
Column
Definition
Node
Props
Column
Type
Comparison
Operator
Comparison
Operator
Expression
Constraint
Node
Create
Index
Node
Props
Create
Schema
Node
Params
Create
Table
Node
Params
Create
Type
Node
Params
Create
View
Node
Params
Data
Type
Params
Delete
Query
Builder
With
Full
Join
Delete
Query
Builder
With
Inner
Join
Delete
Query
Builder
With
Left
Join
Delete
Query
Builder
With
Right
Join
Drop
Constraint
Node
Props
Drop
Index
Node
Props
Drop
Schema
Node
Params
Drop
Tablex
Node
Params
Drop
Type
Node
Params
Drop
View
Node
Params
Equals
Exists
Expression
Explain
Format
Expression
Or
Factory
Extract
Type
From
Reference
Expression
Extract
Type
From
String
Reference
Extract
Wheneable
Merge
Query
Builder
Fetch
Modifier
Filter
Object
Foreign
Key
Constraint
Builder
Callback
Foreign
Key
Constraint
Node
Props
Generated
Generated
Always
Generated
Node
Params
Index
Type
Infer
Result
Insert
Object
Insert
Query
Node
Props
Insert
Type
Insertable
Isolation
Level
JSONColumn
Type
JSONOperator
JSONOperator
With$
JSONPath
Leg
Type
Join
Callback
Expression
Join
Reference
Expression
Join
Type
Log
Config
Log
Event
Log
Level
Logger
Mysql
Query
Result
No
Result
Error
Constructor
Non
Nullable
Insert
Keys
Not
Null
Nullable
Nullable
Insert
Keys
On
Commit
Action
On
Conflict
Database
On
Conflict
Node
Props
On
Conflict
Tables
On
Duplicate
Key
Node
Props
On
Modify
Foreign
Action
Operand
Expression
Operand
Value
Expression
Operand
Value
Expression
Or
List
Operation
Node
Kind
Operator
Order
By
Direction
Expression
Order
By
Expression
Over
Builder
Callback
Postgres
Cursor
Constructor
Query
Node
Reference
Expression
Reference
Expression
Or
List
Root
Operation
Node
Select
Arg
Select
Callback
Select
Expression
Select
Query
Builder
With
Full
Join
Select
Query
Builder
With
Inner
Join
Select
Query
Builder
With
Left
Join
Select
Query
Builder
With
Right
Join
Select
Type
Selectable
Selection
Set
Operator
Simple
Reference
Expression
Simple
Table
Reference
Simplify
Sql
Bool
String
Reference
Table
Expression
Table
Expression
Or
List
Tedious
Isolation
Level
Tedious
Types
Top
Modifier
Unary
Filter
Operator
Unary
Operator
Unique
Constraint
Node
Props
Unknown
Row
Update
Keys
Update
Object
Update
Query
Builder
With
Full
Join
Update
Query
Builder
With
Inner
Join
Update
Query
Builder
With
Left
Join
Update
Query
Builder
With
Right
Join
Update
Type
Update
Values
Node
Updateable
Value
Expression
Value
Expression
Or
List
Values
Item
Node
With
Node
Params
ARITHMETIC_
OPERATORS
BINARY_
OPERATORS
COMPARISON_
OPERATORS
Compiled
Query
DEFAULT_
ALLOW_
UNORDERED_
MIGRATIONS
DEFAULT_
MIGRATION_
LOCK_
TABLE
DEFAULT_
MIGRATION_
TABLE
JSON_
OPERATORS
LOG_
LEVELS
MIGRATION_
LOCK_
ID
NOOP_
QUERY_
EXECUTOR
NO_
MIGRATIONS
ON_
COMMIT_
ACTIONS
ON_
MODIFY_
FOREIGN_
ACTIONS
OPERATORS
TRANSACTION_
ISOLATION_
LEVELS
UNARY_
FILTER_
OPERATORS
UNARY_
OPERATORS
create
Function
Module
create
Raw
Builder
create
Select
Query
Builder
expression
Builder
is
Aliased
Expression
is
Arithmetic
Operator
is
Binary
Operator
is
Column
Data
Type
is
Comparison
Operator
is
Compilable
is
Expression
isJSONOperator
is
Kysely
Props
is
No
Result
Error
Constructor
is
Operation
Node
Source
is
Operator
log
Once
sql
Generated using
TypeDoc