Automatically translate a naive SQL query into a time-series metric

[ryscheng]

What is it?

Let's say a user uses SQL to do a naive thing (e.g. calculate how many users of a certain type a project has).

It would be amazing if we could auto-translate that naive query into one that works with our sqlmesh time series factory to create historical time series data for all time.

The user may need to configure things like: window size, sample rate, etc.