Add Profile Events for Queries with Subqueries

Why it matters

These new profile events enable users to gain insights into how often queries with subqueries are executed. This helps in performance analysis and optimization by identifying the usage patterns of subqueries within SELECT and INSERT operations.

How to use it

Users can enable profiling to collect these events and monitor query execution statistics. The events QueriesWithSubqueries, SelectQueriesWithSubqueries, and InsertQueriesWithSubqueries will then be available in query profiling outputs and system monitoring tools.