Inspectopedia
 
2024.3

Unused subquery item

Warning
New
Last modified: 03 December 2024

Reports columns, aliases, and other subquery items that are not referenced in the outer query expression.

Example (PostgreSQL):

We reference a and q aliases from a subquery. But the b alias and the id column are not referenced in the outer SELECT statement. Therefore, b and id are grayed out.