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
PostgresSelect class
- Create CTE generation in
PostgresExpressionGenerator class
- Modify the
generateSelect() method in PostgresExpressionGenerator class