Skip to content

Add support for quantified comparison predicates #514

@michael-simons

Description

@michael-simons

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:

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions