An SDK solution was mentioned earlier … automated, yet supported (since it doesn’t manipulate the repository directly). Not sure if it will work for you, but these items in the BOB’s Downloads area may give you some ideas of what’s possible:
Add joins to universe / joins to contexts using Designer SDK
Mass update to object names / descriptions
The second one can be tweaked to update Select statements.
Dwayne Hoffpauir (BOB member since 2002-09-19)