Last night I posted this on stackoverflow. I probably should have asked it here. I have yet to get a response. I just want to know if there is a "best practice" for this. Does anyone have any thoughts or alternative suggestions? Thanks for any input.
The second option (using a join) is the best approach all the others are workarounds/hacks imho. PersonRowMapper (or whatever you use) doesn't matter where it comes from, I tend to make RowMappers top level classes in general.
Sounds good. We will do it that way. Thanks Marten!