I had an interesting problem recently in which I needed to take a set of columns defined in a particular manner and turn them into values for a table. I also needed to create cleaned-up names for these columns, dropping off a suffix and splitting the camel case into separate words. Doing this is actually pretty…