Hey Avinash,
In this post I've talked about passing values.
However my strong recommendation is to use Retool Workflows as it has in-built support for functions, handling errors, branching, loops and the execution can be longer than 120s as is the case with queries.
If you are looking to do this within an app I'd suggest building a workflow which is triggered via endpoint.
Hope this gives you some direction.