Check out MATCH_RECOGNIZE. It is a new SQL feature that does just what the post describes.