MATCH_RECOGNIZE

ASOF JOIN

Skyline Query

Dynamic PIVOT

Conditional True Event (conditional_true_event)

Ratio to Report (ratio_to_report)