class_docstr: The ZipCodeBase Codes within a State Table implementation
docstr: Pulls data from the https://app.zipcodebase.com/documentation#state API
  
  Parameters
  ----------
  query : ast.Select
     Given SQL SELECT query
  
  Returns
  -------
  pd.DataFrame
      codes within the state
  
  Raises
  ------
  ValueError
      If the query contains an unsupported condition
docstr_tok: ["Pulls","data","from","the","https",":","\/\/app.zipcodebase.com\/documentation","#","state","API","Parameters","--","--","--","--","--","query",":","ast.Select","Given","SQL","SELECT","query","Returns","--","--","--","-","pd.DataFrame","codes","within","the","state","Raises","--","--","--","ValueError","If","the","query","contains","an","unsupported","condition"]
code: def select(self, query: ast.Select) -> pd.DataFrame:
      """Pulls data from the https://app.zipcodebase.com/documentation#state API
  
      Parameters
      ----------
      query : ast.Select
         Given SQL SELECT query
  
      Returns
      -------
      pd.DataFrame
          codes within the state
  
      Raises
      ------
      ValueError
          If the query contains an unsupported condition
      """
  
      select_statement_parser = SELECTQueryParser(
          query, "codes_by_state", self.get_columns()
      )
  
      (
          selected_columns,
          where_conditions,
          order_by_conditions,
          result_limit,
      ) = select_statement_parser.parse_query()
  
      search_params = {}
      subset_where_conditions = []
  
      for op, arg1, arg2 in where_conditions:
          if arg1 == "state":
              if op == "=":
                  search_params["state"] = arg2
              else:
                  raise NotImplementedError(
                      "Only '=' operator is supported for state column."
                  )
  
          if arg1 == "country":
              if op == "=":
                  search_params["country"] = arg2
              else:
                  raise NotImplementedError(
                      "Only '=' operator is supported for country column."
                  )
  
          elif arg1 in self.get_columns():
              subset_where_conditions.append([op, arg1, arg2])
  
      filter_flag = ("state" in search_params) and (
          "country" in search_params
      )
  
      if not filter_flag:
          raise NotImplementedError(
              "`state` and `country` columns have to be present in where clause."
          )
  
      codes_by_state_df = pd.DataFrame(columns=self.get_columns())
  
      response = self.handler.client.codes_by_state(
          search_params.get("state"), search_params.get("country")
      )
  
      self.check_res(res=response)
  
      content = response["content"]
  
      logger.info(f"response size - {len(content['results'])}")
      codes_by_state_df = pd.json_normalize(
          {"codes": content["results"]}
      )
  
      select_statement_executor = SELECTQueryExecutor(
          codes_by_state_df,
          selected_columns,
          subset_where_conditions,
          order_by_conditions,
          result_limit,
      )
  
      codes_by_state_df = select_statement_executor.execute_query()
  
      return codes_by_state_df
  
imports: import pandas
  from typing import List
  from mindsdb.integrations.libs.api_handler import APITable
  from mindsdb.integrations.handlers.utilities.query_utilities import SELECTQueryParser, SELECTQueryExecutor
  from mindsdb.utilities import log
  from mindsdb_sql.parser import ast
label_desc: Use image node_id 1 for calling the ZipCodeBaseCodeByStateTable obj's underlying member method code with example usage: obj.select(query) and returns: codes_by_state_df