'Does openGauss support any complicated subquery pull-up?

Besides simple subquery pull-up in PG, does openGauss support any complicated subquery pull-up?

sql database subquery

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source