-
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 TO
and 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