Did you require the honey.sql.pg-ops namespace?

seanc@Sean-win-11-laptop:~/oss/honeysql$ clj
Clojure 1.9.0
user=> (require '[honey.sql :as sql] '[honey.sql.helpers :refer :all] '[honey.sql.pg-ops :as pg] :reload)
...
nil
user=> (-> (select :*) (from :table) (where [:= :a [:->> :report_summary :clicks]]) (sql/format))
["SELECT * FROM table WHERE a = (report_summary ->> clicks)"]
user=>

Yes. I'm getting "illegal syntax in select expression " Which goes away when I remove the line

Show more of your code, please. As you can see above, it works.

Running gives me the same error for the select expression.

(require '[honey.sql :as sql] '[honey.sql.helpers :refer :all] '[honey.sql.pg-ops :as pg] :reload)

(-> {}
    (select
     [:->> :report_summary :clicks])
    (from :campaigns)
    (sql/format))

If I run it like you, in the where clause, it works

Seems like the issue is having it in select.

temporary work around is to just use raw

Your syntax is wrong. Read the docs around SELECT and expressions to get the nesting correct.

Sorry for shortness. Very busy right now.

user=> (-> (select :col1 [:col2 :alias] [[:->> :report_summary :clicks]]) (from :table) (sql/format))
["SELECT col1, col2 AS alias, report_summary ->> clicks FROM table"]
user=>

Ah tits, thanks for catching that. Sorry for the false alarm

Small correction if anyone sees this in the future:

[[:->> :report_summary :clicks]]

[[:->> :report_summary "clicks"]]