Yes, CTEs are fine. The author could have used one to generate a view containing formatted names instead of baking this information into the table.