hey folks

I have an issue with a query of mine returning a org.postgresql.util.PGobject

i have a one to many relation

like this

customer <- order

my honeysql query looks like this

(-> (hh/select-distinct :customer :order)
    (hh/from :customer)
    (hh/left-join [:order] [:= :customer.id :order.customer_id])
    (hh/where [:= :customer.id :?id])
    (sql/format {:params {:id id}}))

the resulting sql query:

"SELECT DISTINCT customer, order FROM customer LEFT JOIN order ON customer.id = order.customer_id WHERE customer.id = ?"

this being the result when evaluated in the REPL

[{:customer #object[org.postgresql.util.PGobject 0x15feceb3 "(1,\"test customer\",\"jerry)"],
  :order #object[org.postgresql.util.PGobject 0x680eec30 "(1,1,\"test order 1\")"]}
 {:customer #object[org.postgresql.util.PGobject 0x701081a7 "(1,\"test customer\",\"jerry)"],
  :order #object[org.postgresql.util.PGobject 0x13f2d1a6 "(2,1,\"test order 2\")"]}
 {:customer #object[org.postgresql.util.PGobject 0x65c70b0b "(1,\"test customer\",\"jerry)"],
  :order #object[org.postgresql.util.PGobject 0x51f2659f "(4,1,\"test order 4\)"]}]

what I obiously want to do is create a map from that like {:id 1 :desc "test customer" :name "jerry :tasks [{....} {....]}

but I have no clue how to do that

anyone able to help?

especially how to deal with the pgobject

Nevermind folks, found the answer with changing my query‘ select section