Ability to write sql in VBS condition

It would be good if we have the ability to write sql queries with the bind variables present in the page and write condition based on that.

there are scenarios where the information we need is not available on the page and that restricts on the validation/default rule.

eg. we have a requirement of restricting the managers to transfer(action date) their reportees from certain pay period date to certain date. but the pay period information is not available on the validation page.ability to write a SQL would solve the issue.

another example, there are scenarios where we need to default a data to a field which is a concatenated information of two fields, but we are not able to get the ID value of the concatenated information. ability to write a SQL would solve the issue.