Fetching data from DB during hasura action response transformation

[zeeshanalamkhan]

I am using Hasura action for a rest api that sends id in the response, during resposne transformation I want to fetch childId based on the recieved id. Is it possible with Hasura action resposne transformation using Kriti template?
Is it possible to write SQL query in the resposne tranfrom?
"childId": {{ query "SELECT childId FROM child_ids WHERE id = {{$body?.id}}" }} }}