YAML -> SQL

YAML

    

main:
  with:
  - alias: cte_film
    from: film
    select: ["film_id", "title"]
  - from:
      values:
      - key: 1
        value: 4
      - key: 2
        value: 5
      - key: 3
        value: 6
    alias: cte1
    fields: ["temp_var1", "temp_var2"]
      
  select:
  - field: cte1.temp_var1
  - field: cte1.temp_var2
  - field: cte1.temp_var1 + cte1.temp_var2
    as: temp_var3
  - film_id
  - title
  - length
  from: cte_film
  where:
  - operator: =
    left: length      
    right: { value: 'Long' }