Clojurians Log v2

I’m struggling to work out how to write a lateral join in hsql. How would I write something like this:

left join lateral (
    select json_agg(r.*) as ir
    from revisions r
    where r.item_id = i.id
) ir on truee

I managed to do it with honey/raw and [:= 1 1]. I also thought that maybe this is not standard SQL? I’m just really learning SQL via Postgres at the moment.

Yes, I believe it doesn't currently support lateral

https://github.com/seancorfield/honeysql/blob/1e45fdff282436cce1e1c0aefdd8d912c1f58af0/src/honeysql/core.cljc#L31

It is rather PostgreSQL specific, so unlikely to be supported in HoneySQL any time.

@donavan You could request it be added to this https://github.com/nilenso/honeysql-postgres which is PostgreSQL-specific extensions to HoneySQL.

Thanks both 🙂 . I’ll try create a PR for https://github.com/nilenso/honeysql-postgres otherwise just request it