JOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL

If you prefer to write db queries directly, you can implement this functionality in Postgres using ARRAY_AGG/JSON_OBJECT functions. They really simplify database code in some cases.