I can't use a custom assignment block as the level of approval will be decided based on who is requesting the access.
If the resource owner requests, the request should be auto-approved, and if others request it should go to Manager and Resource Owner for approval.
I had a similar use-case where if a 'requestee and entitlement that he is requesting' is part of a specific usergroup, then it should be auto-approved, if not it should go thru Mgr->Ent Owner approval. I'm using the same Custom Assignment-> Custom Query option as suggested in this forum for my query. But the issue is not completely solved yet due to some Saviynt issue for which I've raised a ticket with Saviynt.
Pl refer to the below ticket that I originally raised in this forum. The query here might give you some clue. If your query is simple, may be it will work. Mine is still pending Saviynt resolution.
SOD with requestee, requestor, and approver is not a problem here. In fact, that's the expected behavior.
The problem here is how do we check if the requestor is the resource owner in the if-else condition.