Exposes the WHERE method and remaining options
Extends
Methods
# build() → {Q}
Method to build and validate the prepared statement before the execution;
.Method to build and validate the prepared statement before the execution;
- Inherited From:
for invalid statements
QueryError
Q
# groupBy(selector) → {Executor}
Groups records by an attribute
Parameters:
| Name | Type | Description |
|---|---|---|
selector |
GroupBySelector
|
- Inherited From:
# limit(selector) → {OffsetOption}
Limits the results to the provided number
Parameters:
| Name | Type | Description |
|---|---|---|
selector |
LimitSelector
|
- Inherited From:
# offset(selector) → {Executor}
Offsets the results by the provided selector
Parameters:
| Name | Type | Description |
|---|---|---|
selector |
OffsetSelector
|
- Inherited From:
# orderBy(selector) → {LimitOption|OffsetOption}
Orders the results by the provided attribute and according to the provided direction
Parameters:
| Name | Type | Description |
|---|---|---|
selector |
OrderBySelector
|
- Inherited From:
# where(condition) → {OrderAndGroupOption}
filter the records by a condition
Parameters:
| Name | Type | Description |
|---|---|---|
condition |
Condition
|