- [Simple]
- [Lateral join]
- [CTE (nested)]
- [Crosstab]
- [Values select]
- [Values join]
- [CTE]
- [Complex]
- [Complicated]
- [Aggregation]
- [Join]
- [Generate Series]
- Docs
- Why?.
YAML
main:
from: salary_increase
alias: ix
select:
- e.emp_id
- e.inc_date
- t.TotalInc
- t.MaxIncAmount
join:
- from: emp_table
alias: e
on:
- operator: =
left: i.emp_id
right: e.emp_id