supported sub-query as a target for queries in new sql parser