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.