Macro,

> I find a situation that Firebird's generated code don't run because the CROSS
> APPLY is used. The issue is generated because I need to create a query inside
> the where clause. I'll show the code that runs and part of the code that
> brings the issue,

Firebird doesn't have any function which would generate SQL. You are seeing a problem with a SQL generator which is incorporates into a third-party application or component.

Accordingly, this problem should be reported elsewhere.


Sean