Hi all, I have completed the implementation of PIVOT and UNPIVOT support for the table model and opened a pull request for review:
https://github.com/apache/iotdb/pull/19152 The implementation supports static and dynamic PIVOT, both SQL-style and simplified syntax, and single-VALUE and multi-VALUE UNPIVOT. It integrates with the existing analysis, planning, and query execution pipeline. Please take a look and share any feedback. Thank you. Best regards, Xinqi Zhao
