Unpivot (version 1.2) - Aster Analytics

SELECT * FROM unpivot (
  ON  input_timeseries_table 
  [ Unpivot ({ 'unpivot_column' | 'unpivot_range' }[,...])] |
    UnpivotRange ('[start_index:end_index]' [,...]) ]
  [ Accumulate
    ({ 'accumulate_column' | 'accumulate_column_range' }[,...]')]
  [ InputTypes ({'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'})]
  [ AttributeColumn ('attribute_column')]
  [ ValueColumn ('value_column')]
);