Thanks for the pointer - these ideas are 100% compatible with the Activity Schema way of storing data (and Motif's internal schema is a generalization of this). We hadn't seen the Temporal Joins Narrator provides until today, but they fall out as a special case of what SOL can specify.

We wrote our own query engine in order to address limitations in what can be expressed in SQL, so SOL is generally more powerful than approaches that rely on hacking the relational model to match patterns.