I'm exploring writing a point and click adventure, and I've found out that they're basically just hierarchical state machines with a pretty UI. This is useful because it simplifies a lot of things.

The downside is that now I'm wondering if I could write one in SQL.