Using dynamic component to create table component with multiple markdown fields

[lozdown]

I have a postgresql table with definition

CREATE TABLE events
(
eventdate date NOT NULL
)

I have a static table component definition which must be redefined every time I add a new event to the table of events because the markdown fields are the event dates from the rows of the events

Example:

select
'table' as 'component', true as 'small',true as striped_rows,true as striped_columns,true as search,
'2024-01-17' as markdown,
'2024-02-14' as markdown,
'2024-03-20' as markdown,
'2024-04-17' as markdown,
'2024-05-15' as markdown,
'2024-06-19' as markdown,
'2024-09-18' as markdown,
'2024-10-16' as markdown,
'2024-11-20' as markdown,
'2024-07-29' as markdown
;

I tried this dynamic component to create the definition above

SELECT 'dynamic' AS component,
jsonb_build_object(
'component', 'table',
'small', 'true',
'striped_rows', 'true',
'striped_columns', 'true',
'search', 'true') ||
jsonb_object_agg(
'markdown',
eventdate
) AS properties from events;

However this query yields json with a single markdown field instead of multiple fields.

"dynamic" "{"small": "true", "search": "true", "markdown": "2025-11-19", "component": "table", "striped_rows": "true", "striped_columns": "true"}"

I suppose key names must be unique so is it possible to use the dynamic component for this purpose or is there another approach?

[lovasoa]

Repeated column names are interpreted by SQLPage as arrays. So you can directly use postgres json aggregation functions to build an array instead of repeating the column names.

select
  'table' as 'component',
  json_agg(event_date) as markdown
from events;

No need for the dynamic component here. Just good old sql.

[lozdown]

As always - SQLPage has the answer! Thank you