What is the best way to extract a Postgres hstore column in sigma?

What is the best way to extract a Postgres hstore column in sigma?

Hstore is a postgres data type that contains multiple key-value pairs. https://www.postgresql.org/docs/9.3/hstore.html

I would first try the Sigma JSON() function in the worksheet, because that’s the easiest solution, if it works.

If not, then you will need to use the SQL Runner, you should be able to do: hstore_to_json(hstore)