In this SQL Snacks™ we will examine the datatable operator which allows us to construct a tabular source separate from the permanent tables in our database. Additionally, we will take a look at prev, next, row_cumsum, and matrialize.

The datatable operator becomes very useful in our next session where we start looking at time series data.