Added and updated test cases for alias support in CTE subquery (backport #7522) [release/4.11.x]

Added and updated test cases for alias support in CTE subquery (backport #7522) [release/4.11.x] #53