task: Update CYPHER queries to support new subquery format

[dgarros]

Component

API Server / GraphQL

Task Description

Since 5.23, Neo4j introduced a new format to pass some variables to a Subquery (CALL), we need to update all our queries the use the new format when we are using Neo4j
As far as I can tell, Memgraph still doesn't support the new format so we need support both for the time being.

It looks like this new format is closer to what GQL support so overall this is a good change for us as it's getting us closer to generate valid GQL queries
Neo4j doc on this feature : https://neo4j.com/docs/cypher-manual/current/subqueries/call-subquery/#variable-scope-clause

before with the WITH p statement inside CALL

MATCH (p:Player)
CALL {
  WITH p
  SET p.rating = random
  RETURN p.name
}

After with the variable passed next to CALL

MATCH (p:Player), (t:Team)
CALL (p) {
  WITH rand() AS random
  SET p.rating = random
  RETURN p.name AS playerName, p.rating AS rating
}

Related to #5241