Is there a way, in honeysql, to represent this?

...LEFT JOIN foo ON = AND bar.name = 'wibble'

I tried a few things, like nesting vectors in the honeysql (left-join clause, but it no work, cap'tain!

(left-join :foo [:and [:= : :] [:= :bar.name "wibble"]]) should work I think?

I think I tried that, but reattempting

user=> (-> (select :* :bar) (left-join :foo [:and [:= : :] [:= :bar.name "wibble"]]) (h/format))
["SELECT *, bar LEFT JOIN foo ON ( =  AND bar.name = ?)" "wibble"]

no joy

ah, try if you have multiple left-joins

(left-join :foo [:and [:= : :] [:= :bar.name "wibble"]]
                :a [:=  :])

If you have multiple joins, you have to use the merge- helpers

ah I see

user=> (-> (select :* :bar) (merge-left-join :foo [:and [:= : :] [:= :bar.name "wibble"]]) (merge-left-join :quux [:and [:= : :] [:= :foo.thing "wut"]])  (h/format))
["SELECT *, bar LEFT JOIN foo ON ( =  AND bar.name = ?) LEFT JOIN quux ON ( =  AND foo.thing = ?)" "wibble" "wut"]

Each left-join / merge-left-join phrase only joins one table.

That's Sean! Using a series of (merge-left-join...) solved it