Suggestion on Neo4j Implementation.

[dotsinspace]

Hello,

I am working on a project where I need to minimize the size of Cypher queries in the codebase. I don't want to integrate neo4j/graphql directly because each module in my system has its own set of Cypher queries. The last option I have is to build an ORM to resolve this issue.

The existing ORM libraries for Neo4j in Golang have limitations:

neo4j-go-ogm explicitly states that it is not recommended for production.
neogo lacks proper pagination support.

This reminded me of how I implemented prisma-client-go for handling PostgreSQL. Now, I am wondering if I can somehow integrate Cypher query generation into this client, allowing it to dynamically generate Cypher queries during execution.

If this integration is possible, could you guide me on the module flow and where I should implement the Neo4j connector?

[steebchen]

Please see #1542

[dotsinspace]

and i think ANTLR doesnt support neo4j. does it ?

[steebchen]

It all comes from the Prisma rust engine. The schema data comes as JSON from the generator API. Then the client is generated from that, it builds the queries from that code and then it uses the Prisma query engine to query data (which does the prisma ql (~graphql) to SQL translation).

[dotsinspace]

Any suggestion on how should I proceed. End of the day I want to simply cyphers.

One mind is saying to build ast for schema.prisma or basically engine which can convert all that to go struct and impl

One mind is saying to use prisma go because it is the one I want to use as it has simplest and straight forward implementation.

Please help with most optimal solution I can build so that in the end I have prisma engine which handles neo4j as well.

Now prisma also doesn't support the neo4j now with that it's abvious that I have to handle schema objects to cyphers.

[steebchen]

integrating this into the prisma schema compatible with go is not a good solution I think, you'll spend ages on that

honestly I don't know what you mean by Cypher? also I don't have much knowledge about neo4j

[dotsinspace]

Thanks a lot for that much information. ❤️