Can't you just set EDITOR=vim in your shell?

By the way, DBI comes with a perl SQL shell called dbish. That's a good place to start when doing this kind of thing.