code: def select(self, query: ast.Select) -> pd.DataFrame:
      qbo = self.handler.connect()
      billpayments_data = qbo.bill_payments.get()
      flattened_billpayments_data = [
          self.flatten_dict(bp) for bp in billpayments_data
      ]
      result = pd.DataFrame(flattened_billpayments_data)
      self.filter_columns(result, query)
      return result
  
imports: import pandas
  from mindsdb.integrations.libs.api_handler import APITable
  from mindsdb_sql.parser import ast
  from mindsdb.integrations.utilities.sql_utils import extract_comparison_conditions
label_desc: Use image node_id 2 for calling the BillPaymentsTable obj's underlying member method code with example usage: obj.select(query) and returns: result