A named temporary result set defined with the WITH clause in MySQL 8.0+. CTEs make complex queries more readable and support recursive queries (WITH RECURSIVE) for hierarchical data traversal.
