HOw to overcome the limitation of the FROM field when creating a value set?

Summary:

Content (please ensure you mask any confidential information):

We need to fit a complex query in a value set, the where clause contains multiple tables that exceed the limitation of the FROM field.

Is there a way to workaround that?

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

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