Yes, would be interesting to hear why the statement can't be changed.
If that's a third party app, I wouldn't hesitate to contact the vendor.
Just a thought!
Would there be any gain when this front-end would fire the query against an ADP project with linked SQL Server tables? I don't know what ADP exactly does, but the statement wouldn't need to be changed.