I have a project that I'm working on that is almost complete, but I'm not happy with a choice I felt I had to make that involved a small hack to user.module.

I extended the SQL query to include some custom fields I had added (long story, but profile.module wasn't appropriate).

all of my CRUD actions are located in a custom module, and it's working fine, but I couldn't figure out how to to extend user_search/hook_search so that I could just replace the default SQL with my custom SQL.

Any suggestions?