Add support for expressions - Githubissues

neo4j / neo4j-jdbc

Official Neo4j JDBC Driver

http://neo4j.github.io/neo4j-jdbc/

Apache License 2.0

135 stars 53 forks source link

Add support for expressions #519

Open michael-simons opened 10 months ago

michael-simons commented 10 months ago

From sql2cypher created by lukaseder: neo4j-contrib/sql2cypher#10

I'll implement more of the expressions() method, to support:

Functions

[x] Arithmetic expressions
[x] https://neo4j.com/docs/cypher-manual/current/functions/mathematical-numeric/
[x] https://neo4j.com/docs/cypher-manual/current/functions/mathematical-logarithmic/
[x] https://neo4j.com/docs/cypher-manual/current/functions/mathematical-trigonometric/
[x] https://neo4j.com/docs/cypher-manual/current/functions/string/
- Note, there's still quite a few missing features in Cypher-DSL here
[ ] https://neo4j.com/docs/cypher-manual/current/functions/temporal/
[ ] https://neo4j.com/docs/cypher-manual/current/functions/temporal/duration/
[ ] https://neo4j.com/docs/cypher-manual/current/functions/spatial/ ~(won't be available with the jOOQ Open Source edition)~
- While the parser and QOM API don't have a representation for these things in the jOOQ Open Source Edition, we can specify Settings.parseUnknownFunctions and try to translate things from there.
[x] https://neo4j.com/docs/cypher-manual/current/functions/scalar/

Query syntax

[x] CASE https://neo4j.com/docs/cypher-manual/current/syntax/expressions/#query-syntax-case
- [x] CASE abbreviations
- [x] CASE simple
- [x] CASE searched
[ ] EXISTS (currently not supported in Cypher-DSL, with subqueries?)
[ ] COUNT (doesn't have the exact SQL equivalent)

Not yet possible:

[x] https://neo4j.com/docs/cypher-manual/current/functions/aggregating/ (still missing jOOQ QOM support, will implement next week)

michael-simons commented 10 months ago

Really great work on the expressions so far and the TCK works really well.