Correct, you cannot use that in a filter. You can do a lot using expressions, so consider if that is possible. Keep in mind that you can use fragment
to embed raw sql into an expression, i.e expr(fragment("SOME ? SQL ? WITH ? SAFE ? INTERPOLATION", field1, field2))
1 Like