As a generic question. If I had to use RowMapper to map a value stored as one type in the database to another type in the data class. One way would to be create in interim structure to read from the db and then cast it to the required structure I am looking to avoid doing that

I wrote a custom mapper to achieve this. But would still appreciate if there was a solution that would work without writing the whole mapper for one column.