neo4j-contrib / sql2cypher

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

Add support for quantified comparison predicates #35

Closed lukaseder closed 7 months ago

lukaseder commented 1 year ago

I'm currently refactoring jOOQ's internals in order to support quantified comparison predicates: https://github.com/jOOQ/jOOQ/issues/14560

The simplest forms include:

a = ANY (SELECT b FROM t)  -- equivalent to A IN (SELECT b FROM t)
a != ALL (SELECT b FROM t) -- equivalent to A NOT IN (SELECT b FROM t)

Less trivial forms involve:

Most of these can be emulated using EXISTS. jOOQ is already doing that for numerous SQL dialects that don't have full support, so this could be done in this translator as well, once we have EXISTS support in: https://github.com/neo4j-contrib/sql2cypher/issues/14

michael-simons commented 7 months ago

Kamino closed and cloned this issue to neo4j/neo4j-jdbc