search

neo4j-contrib / sql2cypher

Experimental SQL to Cypher Transpiler using jooq and cypher-dsl
Apache License 2.0
26 stars 1 forks source link

Quoting / casing #8

Closed jexp closed 7 months ago

jexp commented 1 year ago

In Cypher you keep the casing that you use in the statement. e.g. unitPrice

In SQL it depends on the dialect, some uppercase everything, some leave it, some require quotes or backticks.

It would be nice if we had a SQL dialect that's less intrusive and doesn't require so many quotes even for non-special character names.

Cypher is case sensitive for labels, rel-types and property-keys, while some SQL dialects are not.

Hmm thinking about it, perhaps it's ok to require the quotes if this transpiler has a machine-to-machine target.

lukaseder commented 1 year ago

In jOOQ, there's Settings.parseNameCase that governs dialect specific behaviour, in case this helps.

michael-simons commented 1 year ago

The latter can be configured, via API and CLI now.

michael-simons commented 7 months ago

This was fixed.