?[1] IN(SELECT(UNNEST(?::varchar[]))) OR ?[2] IN(SELECT(UNNEST(?::varchar[])))
Hello everyone, anyone can say how to express this in where statement in honeysql?I have no idea what that syntax even means 👀
@seancorfield already figured it out, syntax is from postgres i had farly large queries in elixir batching in 500 to get matches from pairs, i cant control the tables (though). In elixir all in all it tooka round 2 seconds with encoding and mapping data from db, and in clojure it takes around 500ms, kinda surprised that elixir is that slow(queries are the same)