Insert into Select from Unnest

[LostKobrakai]

Take a look at:

Unnest for runtime sorted results

Though I also found jsonb_to_recordset quite useful:

Postgres VALUES in query

Ecto doesn’t support such queries atm, at least not with runtime values. Though I’m wondering if you could join a jsonb_to_recordset, which would allow you to pass the list of values as a single parameterized list of values: @doc """ Use runtime data as an adhoc db table to join to data. `types` need to be a compile time string literal. `values` can be runtime supplied. ## Example data = [%{id: 1, text: "hey"}, %{id: 2, text: "ho"}] from a in Table, join: b in…