alaska.saedelere,
I do not have any specific advice on your SQL abstraction problem, but here is what I have told others about refactoring - Re: Refactoring a large script.