Selectable stored procedures
Status: Alpha
Brought to you by:
gkello
The parser doesn't support IB/Fb's selectable stored
procedures, which may be regarded as parameterized tables.
Examples of typical constructions that use SSPs:
select ...
from ATABLE A
join ASTOREDPROC('PARAM1', 42) B on 1=1
select A.COLUMN1,
select ARESULT from ASTOREDPROC(A.COLUMN2)
from ATABLE A
where ...
select ...
from ATABLE A
join ASTOREDPROC('PARAM1', 42) B on A.COLUMN1=B.ARESULT
Would that be a complex task to add support for these?