flink sql支持Common Table Expression (CTE)吗？

[casel.chen]

flink sql支持Common Table Expression (CTE)吗？是不是可以通过 create temporary view xxx 
来实现？CTE和temporary view的区别是什么？
例如


with toronto_ppl as (
    SELECT DISTINCT name
    FROM population
    WHERE country = "Canada"
      AND city = "Toronto"
)
   , avg_female_salary as (
        SELECT AVG(salary) as avgSalary
        FROM salaries
        WHERE gender = "Female"
    )
SELECT name
     , salary
FROM People
WHERE name in (SELECT DISTINCT FROM toronto_ppl)
  AND salary >= (SELECT avgSalary FROM avg_female_salary)