Arguments in subqueries gets translated twice.
use case: https://gist.github.com/4348734
I think it this case you must use %SQL instead of %sql.
Agree with DG. One confusion thing is that translate() converts " to '. A litte bit annoing with PostgreSQL. But when you keep one simple rule: Everything from translate() or DibiFluent pass as %SQL, because it is already escaped.
Oh, I wasn't aware of this option. I use quick-start as a quick reference and this option is missing there. Thanks for pointing this out!