DTO projections are the most efficient ones for read operations. Let me show you how to use them in JPQL, Criteria and native queries. You can even use them without a DTO class| Thorben Janssen
9.15. JSON Functions and Operators| PostgreSQL Documentation