Will Firebird 4.0 support stored procedures returning multiple resultsets to the application layer? All other DBMS support such a feature.

The whole point of stored procedures are to encapsulate SQL logic and sometimes it is required to send multiple record sets to the application layer. Currently, we have to have a separate stored procedure for each recordset and then have to combine them at the application layer which creates more work and breaks encapsulation.

Here is an pseudo example in postgresql:
CREATE FUNCTION get_topics
(
    OUT p_topics REFCURSOR,
    OUT p_users REFCURSOR
)
AS
BEGIN
     OPEN p_topics FOR SELECT * FROM topics;
     OPEN p_users FOR SELECT * FROM users;
END

Here is a pseudo example in TSQL (Mssql):
CREATE PROCEDURE get_topics()
AS
BEGIN
      SELECT * FROM topics;
      SELECT * FROM users;
END