I know there are some methods to writing sql functions so that the field names are not hardcoded, causing them to break if they were ever to be changed.
This is one such method: http://www.filemakerhacks.com/?p=4924
Any other (Better ?) ideas as to how to do this. Unfortunately, I wrote a good amount of these functions without doing this and I'll have to go back and redo them.