Processing occurs one at a time and calls a SQL Server stored procedure. The SPROC is recursive. For each ID that is submitted, it can have any number of child ID's.

AWS recently announced a recursion control feature in AWS Lambda that detects and stops Lambda functions running in a recursive or infinite loop.

The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--' insert into mytestvalues (:1)'--and binds the values on each iteration.