Clojurians Log v2

The only relevant way to get [...] in the HoneySQL code is via :inline. However, it doesn't work by itself because [...] passed to :inline gets treated as wrapping in (...). But using [:inline [:lift [...]]] works.

(sql/format {:select [[[:inline :data
                        [:lift ["attrs"]]
                        [:lift ["users"]]
                        [:lift [0]]
                        [:lift ["email"]]]]]})
=> ["SELECT data ['attrs'] ['users'] [0] ['email']"]

Interesting... thanks!

I'd be willing to add support for this if you can think of a reasonable (special) syntax that won't conflict with anything else...

Also, does it specifically need to be inlined or can those indices be expressions/external values (i.e., data[?][?][?][?] and params for the constants)?

I've checked if indices can be parameters, and yes they can:

prepare test as select ('{"foo": {"bar": 42}}'::jsonb) [$1];
PREPARE

test=# execute test('foo');
    jsonb
-------------
 {"bar": 42}
(1 row)

["select data[?][?][?]" "foo" "bar" "baz"]