/*[sqlquery[*/ SELECT entity1_id, entity1_type, entity1_key, CAST(entity1_value as VARCHAR) as entity1_value, relationship, entity2_id, entity2_type, entity2_key, CAST(entity2_value as VARCHAR) as entity2_value FROM neo4j_bridge(query)(entity1_id INTEGER, entity1_type VARCHAR, entity1_key VARCHAR, entity1_value ANY, relationship VARCHAR, entity2_id INTEGER, entity2_type VARCHAR, entity2_key VARCHAR, entity2_value ANY) x TABLE OPTION(LOOP) WHERE query = 'MATCH (a)-[r]->(b) WITH a, b, r, properties(a) AS entity1_props, properties(b) AS entity2_props, labels(a) AS entity1_labels, labels(b) AS entity2_labels UNWIND entity1_labels AS entity1_label UNWIND entity2_labels AS entity2_label UNWIND keys(entity1_props) AS key1 UNWIND keys(entity2_props) AS key2 WITH id(a) AS entity1_id, entity1_label, apoc.text.camelCase(key1) AS entity1_key, entity1_props[key1] AS entity1_value, type(r) AS relationship_raw, id(b) AS entity2_id, entity2_label, apoc.text.camelCase(key2) AS entity2_key, entity2_props[key2] AS entity2_value RETURN entity1_id, entity1_label AS entity1_type, entity1_key, entity1_value, apoc.text.camelCase(relationship_raw) AS relationship, entity2_id, entity2_label AS entity2_type, entity2_key, entity2_value' OPTION(order)
/*]sqlquery]*/