SQL Formatters can be chained together, one after another. For example, to convert a timestamp to Pacific Time and then aggregate by date, query:
select [created_at:pst:date] from users.
Combining this with automatic joins allows for quick, powerful queries such as:
select [users.created_at:pst:date], users.platform, sum(price) from [purchases+users] group by 1, 2
In Periscope, this displays revenue by user platform: