我可以在Postgres中为WHERE条件创建别名吗？

I'd like to find all the companies that have employees matching certain criteria, and return information about those employees, and also about the owners of those companies. My SQL is a bit repetitive, though, and I'm wondering if there's a way to use an alias for some of my WHERE conditions.I'd like to find all the companies that have em