My second option seems to me to just write all sql I would need and store them in functions This is what DBIx::AnyDBD does.

Carter's compass: I know I'm on the right track when by deleting something, I'm adding functionality