I went ahead and just used dynamic sql. I was able to do all the dynamic operations in memory only for our purposes, so performance hit shouldn't be an issue.