@vachichng thanks

I am trying to generate sql for an update with a sub query . honesql generates the following -

"UPDATE sample SET available = FALSE FROM (SELECT id from sample where colour = red), AS subquery WHERE sample.id = subquery.id"

(-> (helpers/update :sample)
    (helpers/sset {:available false})
    (helpers/from (find-sample-honesql m) (sql/raw "AS subquery"))
    (helpers/where [:= :sample.id :subquery.id])
    sql/format)

You should be able to just provide an alias directly in from:

(helpers/from [(find-sample-honesql m) :subquery])