Admittedly, not every SQL statement generated from your application will be executed statically in the way described above.

You can use the generated SOQL statement as is, or manually modify it.

Alter the generated SQL statement to include a PASSING clause in the XQuery function.