Fork me on GitHub
#sql
<
2017-06-24
>
richiardiandrea15:06:59

In my experience fetch functionality works but if you need to use custom queries, like existential or inclusion operators, then you need to build them using strings and raw sql

richiardiandrea15:06:23

Probably there is some dsl around that out there now that I think of it

bja18:06:28

honeysql is easy to extend for various json/jsonb operators

bja18:06:57

just has a multimethod you can use to define new ops

bja18:06:00

although I'd probably convert the json via clojure.java.jdbc protocols at the edges, and just wrap inserted full json blobs using honeysql.format/value when I wanted to opt out of honeysql messing with my maps