Fork me on GitHub
#sql
<
2020-11-07
>
dharrigan21:11:35

@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).

seancorfield21:11:21

@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.

dharrigan21:11:40

ah right right, I recall now you mentioned that - was that a v2 thingie?

seancorfield21:11:51

But it would be just a single line addition to the code base to add that in as core to v2. Yes, v2 only.

dharrigan21:11:02

looking forward to that! 🙂

seancorfield21:11:11

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).

dharrigan21:11:48

Good things comes to they who wait 🙂 I can wait 🙂