-
Notifications
You must be signed in to change notification settings - Fork 59
Open
Description
From sql2cypher created by lukaseder: neo4j-contrib/sql2cypher#35
I'm currently refactoring jOOQ's internals in order to support quantified comparison predicates: jOOQ/jOOQ#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:
<,<=,>, and>=LIKE,SIMILAR TOand other operators (in PostgreSQL), quite useful: https://blog.jooq.org/quantified-like-any-predicates-in-jooq-3-12/- Row value expression predicates: Add support for row value expression predicands neo4j-contrib/sql2cypher#31
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: neo4j-contrib/sql2cypher#14
Metadata
Metadata
Assignees
Labels
No labels