Feature Request: Support fulltext() function in Cypher

[chentaosgithub]

It would be helpful to add a native fulltext() function for Cypher, so we can run full‑text search directly inside Cypher queries against existing ArcadeDB full‑text indexes.

Many developers come from Neo4j and expect to use full‑text search together with graph pattern matching in one Cypher statement. Currently we need to use SQL‑based full‑text APIs as a workaround, which breaks query continuity and increases code complexity.

Native Cypher fulltext support will improve migration experience, keep text search and graph traversal in the same query, and make application code cleaner.

Looking forward to your thoughts.

[lvca]

This is a great idea.

SEARCH_INDEX is already reachable from Cypher today via CypherFunctionFactory's SQL-function fallback (SQLFunctionBridge) — no new bridging code needed. It's blocked purely at parse time: FunctionValidator (query/opencypher/parser/FunctionValidator.java) doesn't have search_index/fulltext.searchIndex registered for arity checking, so the Cypher parser rejects the call before it ever reaches the executor. Registering it there (and optionally aliasing in CypherSemanticValidator) would unlock WHERE search_index('Article[content]', 'java AND database')-style scalar/predicate use in Cypher almost for free.

[lvca]

Created a new issue for that: #6729

[lvca]

Feature implemented ;-)