Hi Team , Is there a way for calling a query inside UDF and get result of that query? Any Options with ScalarFunction Of UDF to call the query manually using UDF() function?

The one case where that is supported is IN_SUBQUERY. What’s the use case you are trying to solve

select UDF() , sum(cola) from table where cond This cond varies from UDF() where -> I will give different condition