Is it advisable to use dynamic SQL queries within BPM tasks?

Many customers are requesting custom approval flows based on specific business rules. However, some of the required fields are not directly available in the BPM task payload.

Although there is an option to use dynamic SQL to derive the approver, we would like to know whether it is advisable to use dynamic SQL within BPM tasks.

When we raised an SR, the support team strongly recommended using only the existing standard fields. They advised don't using dynamic SQL, stating that any issues arising from it will not be supported. We also observed that that dynamic SQL behavior is not consistent.