honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
2020-09-20T18:50:26.000500Z

?[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?

seancorfield 2020-09-20T18:51:30.000900Z

I have no idea what that syntax even means 👀

2020-09-20T18:59:54.004100Z

@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)