Redwood - Can we create a rule with a SQL query? We need to sum multiple Requisition amount

Summary: Can we create a rule with a SQL query? We need to sum multiple Requisition amount.

We have a situation where we want to create a rule where system can sum mulitple requisition for one supplier per year, and if that amount is greater that 35,000.00 this should be auto reject.

Requisition are not associated with BPA or CPA.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):