I have the table with json data type in Postgresql and i must choice the eligible mapping of this field in Scala code for case class field (i don't use slick where i can directly set something like sql.json). I consider the next variants:
java.lang.Object with following validation.play.libs.Json or io.circe.JsonBut i can't choice one of them and I don't other possible candidate for this place.
UPD For interacting with DB i use quill
As Sarvesh mentioned it, it highly depends on the library you are going to use. There is a nice pg-slick extension (https://github.com/tminglei/slick-pg) that supports most of the json libraries.
As for the other libraries, I did not find any relevant resource. It is however possible to insert json with plain SQL. Find resource here