Idea for writing a SQL query in yaml

query.yml

from:
  base: orders
  joins:
    - name: items
      type: inner
      on: items.order_id = orders.id
    - name: products
      type: inner
      on: products.id = items.product_id
    - name: shipments
      type: left
      on: shipments.order_id = orders.id
where:
  - orders.placed >= '2019-09-01'
select:
  dimensions:
    product_name: products.name
  measures:
    total_orders:
      type: count_distinct
      sql: orders.id
    average_price:
      type: average
      sql: items.amount
    not_yet_shipped:
      type: count
      sql: case when shipments.id is true then 1 else 0 end
order_by:
  - name: total_orders
    type: desc
limit: 50