sql

All things SQL and JDBC...
dharrigan 2020-11-07T21:26:35.274400Z

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

seancorfield 2020-11-07T21:31:21.276700Z

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

dharrigan 2020-11-07T21:31:40.277400Z

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

seancorfield 2020-11-07T21:31:51.277700Z

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

dharrigan 2020-11-07T21:31:56.277900Z

kewl

dharrigan 2020-11-07T21:32:02.278100Z

looking forward to that! 🙂

seancorfield 2020-11-07T21:36:11.279100Z

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

dharrigan 2020-11-07T21:36:48.279400Z

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