how to use jsonb_each in from clause

[arashi-dev]

SELECT
  jsonb_data.key AS field_name,
  jsonb_data.value->>'type' AS type_value
FROM
  my_table,
  jsonb_each(my_table.my_field) AS jsonb_data;

how can I write this query in drizzle?

[Angelelz]

Drizzle currently doesn't support comma separated fields in the from clause. The workaround is to write the query to use a join with a subquery or a CTE.

[arashi-dev]

I succeed using innerJoin. thanks for your help :)