Clojurians Log v2
Clojure programming
Channels
Apps
honeysql
Jakub Holý (HolyJak) 2024-12-05T15:50:14.418849Z
Hello! How do I translate the following SQL to honey? I have not managed to find any solution in the docs.
FROM table, lateral jsonb_to_recordset(columns) as col(key text, "dataType" text, label text):raw :
(hh/from :table [(hh/lateral [:jsonb_to_recordset :columns]) [[:'col [:raw "key text"] [:raw "\"dataType\" text"] [:raw "label text"]]]])Jakub Holý (HolyJak) 2024-12-06T10:59:06.448269Z
Ok, thx! -> https://github.com/seancorfield/honeysql/issues/557
seancorfield 2024-12-12T23:06:33.275799Z
user=> (sql/format {:select :* :from [[[:json_to_recordset :my-json-column] [:b {:with-columns [[:c :int] [:d :text]]}]]]})
["SELECT * FROM JSON_TO_RECORDSET(my_json_column) AS b (c INT, d TEXT)"]🙌 2
seancorfield 2024-12-05T17:31:20.324949Z
I don't think there's a way to specify column types in a composite like that. Feel free to create a GH issue with links to the relevant parts of the PostgreSQL docs so I can see the full extent of the syntax I need to support.