Clojurians Log v2

Is there a way to express array_agg(distinct table.field) in honeysql, specifically the distinct there, or do I have to fall back to raw in that case?

@thisfred If you’re using 2.0.0 RC 3, you can do it like this:

dev=> (sql/format-expr [:array_agg [:distinct :table/field]])
["ARRAY_AGG(DISTINCT table.field)"]

Thank you so much!

Or like this in a select:

dev=> (sql/format {:select [ [ [:array_agg [:distinct :table/field]] :agg ] ] :from :table})
["SELECT ARRAY_AGG(DISTINCT table.field) AS agg FROM table"]

I don’t think we’re on that yet, but I’ll make a note to replace the raw with that as soon as we upgrade