SQL Macros - Pipelined Function killers?

Introduced in Oracle 21c and back-ported to Oracle 19c, SQL Macros have been an excellent addition to the developer's toolset. These "parameterized views" come in two different flavours, Table Expressions and Scalar Expressions, with the latter only ...