SQL Standards do not define the UUID as a valid SQL Type and the JDBC Specification does not consider the UUID as valid datatype. So, when used in prepared statement, that is, when created as a bind variable it needs to be modeled using the setobject method as UUID. This is a known limitation in the PostGres JDBC Driver and datatypes.
To work around this limitation, you can make use of the parameter "Allow Literal as Parameters" on the datasource and ensure the query is sent as String Literal rather than a preparedstatement. You can,
* Edit the PostGres Datasource
* Navigate to the Source Configuration tab.
* Locate the parameter "Allow Literals as parameter" and change it to No.
* Save the datasource and try the query again.
Hope this helps