Re: [PATCH] Add native PIVOT syntax for SQL Server/Oracle compatibility

On Tue, Nov 25, 2025 at 09:21:49PM +0100, Peter Eisentraut wrote:
> Your patch does not contain any documentation, so it's hard to tell what
> this is supposed to do if you don't already know those other products. Can
> you supply at least some informal documentation, and maybe some links to
> relevant documentation from those other products.

(Added Vik Fearing in CC.)

FWIW, I have very mixed feelings about the addition of clauses that
are not part of the SQL specifications AFAIK (just looked at my copy
of 2023), doing an implementation based on the argument of
compatibility that have been taken by other products here, because we
would have to live with this compatibility issues in the long-term.

Peter, Vik, is there an equivalent under discussion on the
specification side? If something gets released, an implementation may
make sense based on it, but at this stage it would hard to decide why
one direction would be more adapted than another.
--
Michael