A sequel to SQL? An intro to Malloy
This is the example at <a href="https:&#x2F;&#x2F;github.com&#x2F;looker-open-source&#x2F;malloy" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;looker-open-source&#x2F;malloy</a><p><pre><code>  query: table(&#x27;malloy-data.faa.flights&#x27;) -&gt; {
    where: origin ? &#x27;SFO&#x27;
    group_by: carrier
    aggregate:
      flight_count is count()
      average_flight_time is flight_time.avg()
  }


  SELECT
     carrier,
     COUNT(*) as flight_count,
     AVG(flight_time) as average_flight_time
  FROM `malloy-data.faa.flights`
  WHERE origin = &#x27;SFO&#x27;
  GROUP BY carrier
  ORDER BY flight_count desc         -- malloy automatically orders by the first aggregate
</code></pre>
I don&#x27;t see much value in this.  This is not aesthetically better than SQL.  It&#x27;s also semantically better.  This is just a different syntax that would parse to the same AST.  And what&#x27;s with the `?` for equality?!