@seancorfield what is your current thoughts around honeysql v2 and specific db operations (for example, I used left join lateral
today in a query which I hand crafted - which is a postgresql feature, although oracle has lateral and cross apply and mysql also has lateral).
@dharrigan It is very easy to register new clauses that behave like existing ones: (h2/register-clause! :left-join-lateral :join :right-join)
-- adds :left-join-lateral
to mean LEFT JOIN LATERAL
that is formatted exactly like the existing :join
clause and is inserted into the generation order just before :right-join
.
ah right right, I recall now you mentioned that - was that a v2 thingie?
But it would be just a single line addition to the code base to add that in as core to v2. Yes, v2 only.
kewl
looking forward to that! 🙂
I hit a roadblock with v2 that I've been in my hammock thinking about since. I think I have a way forward now, but it's a substantial rewrite of the engine (no change to the API, I think).
Good things comes to they who wait 🙂 I can wait 🙂