Really!? We’re still doing GOTOs in 2023? That should just be a for loop over the collection of tests you want to write.

I don’t understand why the most_recent field is needed. Surely the most recent state can be derived from the order field and the unique constraint on it can prevent concurrency issues if the previous sequence is taken before the state change. The benefit would be that the transition history table could then be append only.