HHH-8237 Taking @ColumnResult#type() into account for native scalar and constructor mappings

@sebersole Could you take a look at this one? Thanks!