Add support for expressions - Githubissues

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 expressions #10

Closed lukaseder closed 7 months ago

lukaseder commented 1 year ago

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:

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

jexp commented 1 year ago

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

michael-simons commented 7 months ago

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