How to build a query to be used in Journal approval rule If condition

Summary:

How to build a query to be used in Journal approval rule If condition

Content (required):

Based on the requirement we want to check whether a certain segment value is part of a specific parent or not. Based that specific actions will be taken.

Is possible to use sql query in rule's if condition, similar to what we can use in skip rules (orcl:query-database)? Is there a separate syntax that needs to be used?

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

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