The following query successfully executes in all databases but MySQL:
select * from "AO_69D057_FILTER" where "SHARED" = true AND "CONTAINS_PROJECT" = true AND UPPER("FILTER_NAME") like UPPER('%pr%').
The reason is that MySQL does not support double quotes like " as a default.
The solution is to configure the session with a param:
Using AO does not support to use such properties, I suggest to use this behaviour as a default for AO since quoting for all other db's would be fine.