Your suggestions for Year, ZoneId and ZoneOffset are sensible to me. For YearMonth I'm not sure, I don't really like it being a text. Probably easiest to skip that one. For Durations I'm personally mapping to PGInterval, but this is non existent in other DBMSes/JDBC drivers. Here, due to the lack of dedicated SQL types, and the possibility for db specific SQL types that suit the type much better than a plain string, I'd skip this one. |