Methods
(static) EXCEPT(str) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- String
(static) FROM(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) FULL_JOIN(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) GROUP_BY(str) → {Array.<Object>}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Array.<Object>
(static) HAVING(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) INNER_JOIN(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) INTERSECT(str) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- String
(static) LEFT_JOIN(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) LIMIT(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) ORDER_BY(str) → {Array.<Object>}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Array.<Object>
(static) PIVOT(str) → {Array.<Object>}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Array.<Object>
(static) RIGHT_JOIN(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) SELECT(str, isOrderBy) → {Array.<Object>}
- Source:
Parameters:
| Name | Type | Default | Description |
|---|---|---|---|
str |
String | ||
isOrderBy |
Boolean |
false
|
Returns:
- Type
- Array.<Object>
(static) UNION(str) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- String
(static) UNION_ALL(str) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- String
(static) WHERE(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) allJoins(str) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
String |
Returns:
- Type
- Object
(static) analyze(itemName, part) → {any}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
itemName |
String | |
part |
Object |
Returns:
- Type
- any
(static) extractSelectField(item, isOrderBy) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
item |
String | |
isOrderBy |
Boolean |
Returns:
- Type
- Object
(static) getNameAndAlias(item) → {Array.<String>}
- Description:
If an ALIAS is specified after 'AS', return the field/table name and the alias.
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
item |
String |
Returns:
- Type
- Array.<String>
(static) lastIndexOfOutsideLiteral(srcString, searchString) → {Number}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
srcString |
String | |
searchString |
String |
Returns:
- Type
- Number
(static) parseForCorrelatedSubQuery(selectField) → {Object}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
selectField |
String |
Returns:
- Type
- Object
(static) protect_split(separator, str) → {Array.<String>}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
separator |
String | |
str |
String |
Returns:
- Type
- Array.<String>
(static) trim(str) → {any}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
str |
any |
Returns:
- Type
- any