Any tips on how to express:

SELECT ARRAY[1,2] && foo;

I guess I can use (h/format (honeysql.types/array [1 2 3]))

and now the [:&& included-uuids :tzdb.tag_uuids] part: can I generate the && as an operator instead of a function?

(sorry, this is probblay in the docs somewhere, but I have trouble finding it 😒 )

Is there some hook to register a thing as an infix thing?

I did this:

(defmethod hf/fn-handler "&&" [op & args]
  (let [args (map hf/to-sql args)]
    (hf/paren-wrap (str/join (str " " op " ") args))))

Sounds like you’ve solved the problem? Which DB is that for? || is a variadic infix operator in V2 for string concatenation so I’m a bit surprised to see && — what does it mean?

@seancorfield this is an array operator in postgresql.

array[1,2,3] && array[1,2,3,4]

perhaps allowing people to say: "this is an infix operator" would be easier

That’s easy in HoneySQL v2 but I think fn-handler is the right approach in v1.

In v2 it’s (sql/register-op! :&& :variadic true) and you’re off to the races. But I’ll go ahead and add && as a built-in for the next v2 version anyway.

Excellent! I'll try to migrate this one namespace to v2 now

We can use them side by side anyway

Yup. develop has that change. It’ll be in RC 3 or “gold”, whichever comes next.

if I have an array like ARRAY["..."] but I want to generate ARRAY["..."]::uuid[], what's the best option?

[:cast included-uuids :uuid[]]

hacky and ugly, but it works:

[:&& [:cast included-uuids [:lift (symbol "uuid[]")]]  :tzdb.tag_uuids]

this seems to work: [:&& [:cast included-uuids [:raw "uuid[]"]] :tzdb.tag_uuids]

The :inline feature is great for debugging

I’d probably go with :cast / :raw for a situation like that. Open to suggestions on making that easier — but we’re sort of at the mercy of Clojure’s reader for that one.

cast / raw works for me, it just wasn't what I usually write with hugsql