What is the correct syntax to perform a raw query with WHERE IN ($1)
condition?
I thought this would work, but I get an error
Ecto.Adapters.SQL.query!(App.Repo, "SELECT category_id from category_statistics where id in ($1)", [[1,2,3]])
** (DBConnection.EncodeError) Postgrex expected an integer in -9223372036854775808..9223372036854775807, got [1, 2, 3]. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly.