Half of this article is the author not knowing SQL. Aggregating by day or week is trivial (and doesn't require subqueries) in any database. It goes on to say "Range queries, a single data point may be aggregated into multiple groups" -- standard SQL window functions meet this criteria too.

I think the only thing somewhat novel here is interpolating for missing values.