Ecto dynamic queries with jsonb_each_text in PG

Questions & Help Questions
, ,
2

You cannot use functions in from part in Ecto. You need to fall back to JOINs:

from store in "my_store",
  inner_lateral_join: json_data in fragment("jsonb_each_text(?)", store.my_jsonb_column),
  group_by: json_data.key,
  select: %{
    key: json_data.key,
    value: sum(json_data.value)
  }