title: PGobject type conversion in Clojure
body: <p>I'm having trouble with a type conversion problem in Clojure, using Hugsql. I'm new to Clojure and newer to SQL, and I'd appreciate any help I can get.</p>
  
  <p>We recently migrated our PostgreSQL db so one column is a json array instead of a string -- the migration looks like: </p>
  
  <p><code>ALTER TABLE customers ALTER id TYPE JSON USING json_build_array(id);</code></p>
  
  <p>But now when I make query for that data, the type is a PGobject and not a collection like I was hoping. While I'm looking for: </p>
  
  <ul>
  <li><code>["id-123"]</code></li>
  </ul>
  
  <p>the actual returned value is </p>
  
  <ul>
  <li><code>#object[org.postgresql.util.PGobject 0x7ff0434e "[\"id-123\"]"]</code></li>
  </ul>
  
  <p>I spent some time looking up how to do the type conversion, but had no luck. How can I convert the type of this response to a collection or sequence in Clojure? 
  Thanks for your help!</p>