This command opens an additional application tab, where the SQL query results are displayed as a BI assets tree:

It applies not to the selection but to all your results.

Show as Tree is available only if your SQL script contains the CMSID column. Otherwise, the Show as Tree button opens an error message.

Table with the results of your SQL Script must have at least one column with its title ending with OBJECTID.

There are 3 options: CMS Explorer-like, Users tab-like, and mixed.