Clojurians Log v2
Clojure programming
Channels
Apps
sql 2023-03-29
lepistane 2023-03-29T12:38:52.125029Z
How does one convert this query to hugSQL?
(SELECT '2023-01-02' + INTERVAL 1 DAY)(next.jdbc/execute! (honey.sql/format {:select ["2023-01-02"]
:from [:+ :interval :1 :day]}))class clojure.lang.PersistentVector cannot be cast to class clojure.lang.IPersistentMap
Felipe 2023-03-29T12:56:19.540119Z
maybe
(honey.sql/format {:select [[[:+ "2023-01-02" [:interval 1 :day]]]]}
{:inline true})
;; => ["SELECT '2023-01-02' + INTERVAL 1 DAY"]lepistane 2023-03-29T13:13:17.886219Z
that's interesting... Thanks a lot
seancorfield 2023-03-29T15:10:02.955049Z
The docs talk about :select needing extra nesting for expressions because it's:
:select [:col [:col :alias] [[:expr] :alias] [[:expr]]]
;=> SELECT col, col AS alias, EXPR() AS alias, EXPR():select [[[:expr]]]