JoinCondition

Single binary condition in a Join.on list. AND'd within a Join.

left objectrequired

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

anyOf

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

anyOf

• string
• null

string

right objectrequired

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

anyOf

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

anyOf

• string
• null

string

operatorJoinOperator (string)

Allowed Join Operator values. Values: eq, ne, gt, gte, lt, lte.

Possible values: [eq, ne, gt, gte, lt, lte]

Default value: eq

JoinCondition

{
  "left": {
    "column": "string",
    "expression": "string"
  },
  "right": {
    "column": "string",
    "expression": "string"
  },
  "operator": "eq"
}