SELECT Clause item Schema

Specify column, apply aggregations, create custom expressions, case clause or a sub query.

items Properties

Property	Type	Required	Nullable
alias	string	Optional	cannot be null
param	string	Optional	cannot be null
agg	string	Optional	cannot be null
expression	object	Optional	cannot be null
sub_query	Not specified	Optional	cannot be null
case	object	Optional	cannot be null

alias

alias

• is optional

• Type: string

• cannot be null

alias Type

string

alias Constraints

pattern: the string must match the following regular expression:

^[a-zA-Z_]+$

try pattern

param

Parameter to select.

param

• is optional

• Type: string

• cannot be null

param Type

string

tip

Use dot syntax to reference a param of another query inside this schema. e.g.: Reference a param from different query with alias as rideDetails as rideDetails.distance

agg

The params/expression/case/sub_query specified will be wrapped inside this aggregation mode. The default timestamp column is used in case of first and last agg modes.

agg

• is optional

• Type: string

• cannot be null

agg Type

string

agg Constraints

enum: the value of this property must be equal to one of the following values:

Value
"count"
"max"
"min"
"last"
"first"
"avg"
"sum"

expression

Specify custom SQL expression

expression

• is optional

• Type: object

• cannot be null

expression Type

object

sub_query

sub_query

• is optional

• Type: unknown

• cannot be null

sub_query Type

unknown

case

Use this to conditionally select parameters.

case

• is optional

• Type: object

• cannot be null

case Type

object