back to raw sql for case event table update