influxql is limited, yes, but much less verbose for time-based aggregation than the equivalent sql queries, which is why I like using it for adhoc visualization and inspectibility. (I don't like flux). to me it's great for a limited purpose. writing the equivalent sql queries would drive me up the wall.