docstr: triggered at the SELECT query
  
  Args:
      query (ast.Select): user's entered query
  
  Returns:
      pd.DataFrame: the queried information
docstr_tok: ["triggered","at","the","SELECT","query","Args",":","query","(","ast.Select",")",":","user","'s","entered","query","Returns",":","pd.DataFrame",":","the","queried","information"]
code: def select(self, query: ast.Select) -> pd.DataFrame:
      """triggered at the SELECT query
  
      Args:
          query (ast.Select): user's entered query
  
      Returns:
          pd.DataFrame: the queried information
      """
      params = conditions_to_filter(query.where)
  
      package_name = params["package"]
      period = params.get("period", None)
      all_cols = {
          "day": "last_day",
          "week": "last_week",
          "month": "last_month",
      }
  
      to_be_excluded = []
  
      if period:
          if period in all_cols.keys():
              del all_cols[period]
              to_be_excluded = list(all_cols.values())
          else:
              raise ValueError(
                  "Make sure that one of `day`, `week` or `month` values is assigned to `period`."
              )
  
      select_statement_parser = SELECTQueryParser(
          query, PyPIRecentTable.name, self.get_columns(to_be_excluded)
      )
      (
          selected_columns,
          _,
          order_by_conditions,
          _,
      ) = select_statement_parser.parse_query()
  
      raw_df = self.handler.connection(name=package_name).recent(period)
  
      select_statement_executor = SELECTQueryExecutor(
          raw_df, selected_columns, [], order_by_conditions
      )
  
      result_df = select_statement_executor.execute_query()
  
      return result_df
  
imports: from typing import List
  import pandas
  from mindsdb_sql.parser import ast
  from mindsdb.integrations.handlers.utilities.query_utilities import SELECTQueryExecutor, SELECTQueryParser
  from mindsdb.integrations.libs.api_handler import APIHandler, APITable
  from mindsdb.integrations.utilities.sql_utils import conditions_to_filter
label_desc: Use image node_id 1 for calling the PyPIRecentTable obj's underlying member method code with example usage: obj.select(query) and returns: result_df