[Feature Request]: Support entity collection for derived tables and query columns

[JackWang032]

Topic

Support new features on parser

Description

Derived Table Collection

For the following SQL, we can only retrieve two table entities: t1 and users. However, the derived table (subquery) t2 should also be collectible:

SELECT id FROM t1, (select name from users) as t2

Query Field Collection

It should be possible to collect the queried fields id, name, and total from the source table u so that they can be referenced in the outer query:

SELECT xxx FROM (SELECT id, name, (select count(*) as total) FROM users) u