JSON_OBJECTAGG

SELECT json_objectagg(
  CAST(author.id AS varchar(100)),
  first_name
)
FROM author
 

create.select(jsonObjectAgg(
         cast(AUTHOR.ID, VARCHAR(100)),
         AUTHOR.FIRST_NAME
      ))
      .from(AUTHOR)
      .fetch();

+----------------------------+
| json_objectagg             |
+----------------------------+
| {"1":"George","2":"Paulo"} |
+----------------------------+

jsonObjectAgg(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)

json_object_agg(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)

json_object(
  array_agg(AUTHOR.FIRST_NAME),
  array_agg(AUTHOR.LAST_NAME)
)

(('{' || string_agg(regexp_replace(cast(
  json_build_object(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
  AS string
), '^\{(.*)\}$', '\1', 'g'), ',') || '}'))

(('{' || listagg(
  regexp_replace(cast(
    json_object(KEY AUTHOR.FIRST_NAME VALUE AUTHOR.LAST_NAME)
    AS varchar(32672)
  ), '^\{(.*)\}$', '\1'),
  ','
) || '}'))

to_json(map_from_entries(array_agg(ROW(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME))))

json_objectagg(KEY AUTHOR.FIRST_NAME VALUE AUTHOR.LAST_NAME)

json_objectagg(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)

object_agg(coalesce(
  to_variant(AUTHOR.FIRST_NAME),
  parse_json('null')
), coalesce(
  to_variant(AUTHOR.LAST_NAME),
  parse_json('null')
))

json_group_object(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)

cast(map(array_agg(AUTHOR.FIRST_NAME), array_agg(AUTHOR.LAST_NAME)) AS json)

/* UNSUPPORTED */

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website