code: @Override
      public void extractEphemeralTableQueries(List<StmtEphemeralTableScan> scans) {
          if (m_leftNode != null) {
              m_leftNode.extractEphemeralTableQueries(scans);
          }
          if (m_rightNode != null) {
              m_rightNode.extractEphemeralTableQueries(scans);
          }
      }
docs: Returns a list of immediate sub-queries which are part of this query.
  @return List<AbstractParsedStmt> - list of sub-queries from this query