PostgreSQL Version 14 Upgrade - Supporting Common Table Expression
Problem
Currently, Common Table Expression (CTE) is introduced after version 12 and not yet supported in our Postgres system: https://www.postgresql.org/docs/13/queries-with.html
We need to implement the CTE as well as modify the select statement on selecting the CTE
Implementation Plan
- Create new CTE class in the AST directory
- Add CTE support in
PostgresSelectclass - Create CTE generation in
PostgresExpressionGeneratorclass - Modify the
generateSelect()method inPostgresExpressionGeneratorclass