Interface: SelectQuery

Interface: SelectQuery

Defined in: core/src/query/ast.ts:120

Properties

kind

readonly kind: "select"

Defined in: core/src/query/ast.ts:121

---

from

readonly from: string

Defined in: core/src/query/ast.ts:124

Name of the primary FROM source. If fromSubquery is set, this is the subquery’s alias; otherwise it’s the user table name.

---

fromSubquery?

readonly optional fromSubquery?: SelectQuery

Defined in: core/src/query/ast.ts:131

When set, the FROM clause is a nested SELECT aliased as from. The inner query is executed first (client) or emitted as (inner) AS alias (server), and downstream WHERE / joins / projection reference the alias as if it were a table.

---

joins

readonly joins: readonly Join[]

Defined in: core/src/query/ast.ts:132

---

projection

readonly projection: Projection

Defined in: core/src/query/ast.ts:133

---

where?

readonly optional where?: Expr

Defined in: core/src/query/ast.ts:134

---

groupBy?

readonly optional groupBy?: readonly ColRef[]

Defined in: core/src/query/ast.ts:135

---

having?

readonly optional having?: Expr

Defined in: core/src/query/ast.ts:136

---

orderBy

readonly orderBy: readonly Ordering[]

Defined in: core/src/query/ast.ts:137

---

limit?

readonly optional limit?: number

Defined in: core/src/query/ast.ts:138

---

offset?

readonly optional offset?: number

Defined in: core/src/query/ast.ts:139