LogicHub DSL

[ 1 Usage details ] [ 2 Example ]

The LogicHub domain-specific language (DSL) operator allows you to include multiple operators within a single LQL expression.

The operators must be separated by the pipe | symbol.
Each of the operators must be named so it can be used in the subsequent operators in the same LQL expression.
You can refer to tables by their names within the same LQL expression.

Usage details

Including multiple operators in the same LQL expression can reduce the complexity of a playbook and make it more concise.

LQL Command

[ Operator or LQL Expression ] as TableName | [ Operator or LQL Expression ] as TableName

Example

The following example shows three LQL expressions separated by the pipe | symbol.
Each LQL expression is renamed with a table reference that is used in the subsequent LQL expressions.

LQL Command

[select *, user as user_root from root] as t1
| [select *, user as user_t1 from t1] as t2
| [select *, user as user_t2 from t2] as t3