# Class: InsertQuery

Defined in: packages/core/src/models/InsertQuery.ts:7

Extends

• SqlComponent

Constructors

Constructor

new InsertQuery(params): InsertQuery

Defined in: packages/core/src/models/InsertQuery.ts:20

Parameters

params

withClause?

null | WithClause

Optional WITH clause scoped to the INSERT statement

insertClause

InsertClause

InsertClause instance (target table and columns)

selectQuery?

null | SelectQuery

SELECT/VALUES query (required)

returning?

null | ReturningClause

Optional RETURNING clause

Returns

InsertQuery

Overrides

SqlComponent.constructor

Properties

kind

static kind: symbol

Defined in: packages/core/src/models/InsertQuery.ts:8

Overrides

SqlComponent.kind

---

withClause

withClause: null | WithClause

Defined in: packages/core/src/models/InsertQuery.ts:9

---

insertClause

insertClause: InsertClause

Defined in: packages/core/src/models/InsertQuery.ts:10

---

selectQuery

selectQuery: null | SelectQuery

Defined in: packages/core/src/models/InsertQuery.ts:11

---

returningClause

returningClause: null | ReturningClause

Defined in: packages/core/src/models/InsertQuery.ts:12

---

comments

comments: null | string[] = null

Defined in: packages/core/src/models/SqlComponent.ts:29

Inherited from

SqlComponent.comments

---

positionedComments

positionedComments: null | PositionedComment[] = null

Defined in: packages/core/src/models/SqlComponent.ts:32

Inherited from

SqlComponent.positionedComments

Methods

getKind()

getKind(): symbol

Defined in: packages/core/src/models/SqlComponent.ts:15

Returns

symbol

Inherited from

SqlComponent.getKind

---

accept()

accept<T&gt;(visitor): T

Defined in: packages/core/src/models/SqlComponent.ts:19

Type Parameters

T

T

Parameters

visitor

SqlComponentVisitor<T&gt;

Returns

T

Inherited from

SqlComponent.accept

---

toSqlString()

toSqlString(formatter): string

Defined in: packages/core/src/models/SqlComponent.ts:23

Parameters

formatter

SqlComponentVisitor<string&gt;

Returns

string

Inherited from

SqlComponent.toSqlString

---

addPositionedComments()

addPositionedComments(position, comments): void

Defined in: packages/core/src/models/SqlComponent.ts:37

Add comments at a specific position

Parameters

position

"before" | "after"

comments

string[]

Returns

void

Inherited from

SqlComponent.addPositionedComments

---

getPositionedComments()

getPositionedComments(position): string[]

Defined in: packages/core/src/models/SqlComponent.ts:56

Get comments for a specific position

Parameters

position

"before" | "after"

Returns

string[]

Inherited from

SqlComponent.getPositionedComments

---

getAllPositionedComments()

getAllPositionedComments(): string[]

Defined in: packages/core/src/models/SqlComponent.ts:66

Get all positioned comments as a flat array in order (before, after)

Returns

string[]

Inherited from

SqlComponent.getAllPositionedComments