Malloy – A Better SQL, from Looker
Example looks like this:    query: sessionize is {
      group_by: flight_date is dep_time.day
      group_by: carrier
      aggregate: daily_flight_count is flight_count
      nest: per_plane_data is {
        top: 20
        group_by: tail_num
        aggregate: plane_flight_count is flight_count
        nest: flight_legs is {
          order_by: 2
          group_by: [
            tail_num
            dep_minute is dep_time.minute
            origin_code
            dest_code is destination_code
            dep_delay
            arr_delay
          ]
        }
      }
    }

https://looker-open-source.github.io/malloy/documentation/ex...