Correlated subqueries are now supported by default

Why it matters

This feature enables users to write more complex and expressive queries that involve subqueries referencing columns from outer queries. By making correlated subqueries stable and enabled by default, it improves query flexibility and usability without requiring additional settings.

How to use it

Users can write correlated subqueries in their SQL queries without enabling any special settings or experimental flags. Simply use subqueries that reference outer query columns as needed in SELECT statements.