Translating SQL query with row constructors (?) into Ecto

[khustochka]

Thanks for the links to the past threads!

I think the solution described in one of the answers works for me and generates exactly the query that I want.

Ecto IN clauses with tuples

Late to the party, but I found a hack that builds and expands code at runtime and uses proper parameters instead of interpolation: def tuple_in(fields, values) do fields = Enum.map(fields, &quote(do: field(x, unquote(&1)))) values = for v <- values, do: quote(do: fragment("(?)", splice(^unquote(Tuple.to_list(v))))) field_params = Enum.map_join(fields, ",", fn _ -> "?" end) value_params = Enum.map_join(values, ",", fn _ -> "?" end) pattern = "(#{field_params}) in (#{value_params})" …