在Postgresql的where子句中使用Alias列

SELECT column1 AS alias_column
FROM table_name
WHERE alias_column = 'some_value';

SELECT *
FROM (
    SELECT column1 AS alias_column
    FROM table_name
) AS subquery_alias
WHERE subquery_alias.alias_column = 'some_value';

WITH cte_alias AS (
    SELECT column1 AS alias_column
    FROM table_name
)
SELECT *
FROM cte_alias
WHERE cte_alias.alias_column = 'some_value';