YAML -> SQL

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

    

SQL

    
SELECT e.emp_id, e.inc_date, t.TotalInc, t.MaxIncAmount FROM "salary_increase" "ix" JOIN "emp_table" "e" ON i.emp_id = e.emp_id