Transaction vs Session Scope for Global Temp Tables Statements

Using ON COMMIT DELETE ROWS would not work for most of our applications, because they require the data to survive over multiple transactions (but still in the same session).

In an earlier discussion we were already contemplating whether we should use temp tables at all, given the fact that Oracle doesn’t really support them, and the SqlRender vignette already urges users not to use temp tables.

Can someone tell me what part of the WebApi is making so much use of temp tables, and why?