Efficient Integrity Checks for DAG Operations in SurrealDB

[Muttermal]

I have a directed acyclic graph (DAG), and each time I insert or delete a relationship, I need to perform the following checks:

1. When inserting a relationship, I need to check whether it will introduce a cycle into the graph.
2. When deleting a relationship, I need to check whether the graph will become disconnected or if any isolated nodes will appear.

Currently, I load all the nodes and relationships and use networkx to perform these checks, but this approach is inefficient.
Is there a better way to handle this directly in SurrealDB?