neo4j-contrib / sql2cypher

Experimental SQL to Cypher Transpiler using jooq and cypher-dsl
Apache License 2.0
26 stars 1 forks source link

First attempt at JOIN to Rel-Type #25

Closed jexp closed 1 year ago

jexp commented 1 year ago

18

Would love some conceptual feedback, see the TCK file for the current handling

The next one with the JOIN table would need to consider two connected JOINs not 100% sure how to get that other/next join from the current Table<?> or if we would have to do that a level up.

lukaseder commented 1 year ago

Would love some conceptual feedback, see the TCK file for the current handling

Sure, I provided some review, but specific questions are good as well. I'm not sure yet where all your doubts lie, (not knowing too much about Cypher, and especially, common patterns and idioms when writing Cypher)

jexp commented 1 year ago

I'll add a few comments in the code.

jexp commented 1 year ago

@lukaseder unrelated FYI: not sure if the build failure trying to compile jOOQ, was only a temporary glitch in the snapshot? https://github.com/neo4j-contrib/sql2cypher/actions/runs/3991841532/jobs/6847082074

lukaseder commented 1 year ago

@lukaseder unrelated FYI: not sure if the build failure trying to compile jOOQ, was only a temporary glitch in the snapshot? https://github.com/neo4j-contrib/sql2cypher/actions/runs/3991841532/jobs/6847082074

https://github.com/neo4j-contrib/sql2cypher/issues/27

jexp commented 1 year ago

@lukaseder can you have a look at my code-inline questions? I'd be happy to merge this as a WIP state, but want to make sure that I'm not doing stupid things.

lukaseder commented 1 year ago

@lukaseder can you have a look at my code-inline questions?

I already replied to everything, I think? What's missing?

jexp commented 1 year ago

@lukaseder I meant on these:

Bildschirmfoto 2023-01-25 um 18 34 10 Bildschirmfoto 2023-01-25 um 18 34 03
lukaseder commented 1 year ago

I don't know why my comments are "pending", but I already replied:

image
jexp commented 1 year ago

@lukaseder GitHub is odd at that, it only sends them immediately if you use "Add single comment" and otherwise it adds/collects them to your "Review" and only publishes them when you finish your "Review" in the top-right box.

jexp commented 1 year ago

Thanks for the answers, I'll go through them.

lukaseder commented 1 year ago

Ugh, I didn't realise I had started a formal "review", sorry

jexp commented 1 year ago

It auto starts a review if you don’t use the single comment button.

jexp commented 1 year ago

Merging this now to make progress, next up is a multi-way join.