code: def test_select_from(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": ["id1", "id2"],
              "content": ["this is a test", "this is a test"],
              "metadata": [{"test": "test"}, {"test": "test"}],
              "embeddings": [
                  [1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0],
                  [1.0, 2.0, 3.0, 5.0, 6.0, 8.0, 9.0, 3.0],
              ],
          }
      )
  
      self.set_handler(
          postgres_handler_mock, "pg", tables={"testtable": df}
      )
      sql = """
          CREATE TABLE pinecone_test.testtable (
              SELECT * FROM pg.df
          )
          """
      self.run_sql(sql)
  
      # query a table with id
      sql = """
              SELECT * FROM pinecone_test.testtable
              WHERE id = 'id1'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # query a table with a search vector, with out limit
      sql = """
              SELECT * FROM pinecone_test.testtable
              WHERE search_vector = '[1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0]'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # query a table with a search vector, with limit
      sql = """
              SELECT * FROM pinecone_test.testtable
              WHERE search_vector = '[1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0]'
              LIMIT 1
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 1
  
      # query a table with a metadata filter and a search vector
      sql = """
              SELECT * FROM pinecone_test.testtable
              WHERE testable.metadata.test = 'test'
              AND search_vector = '[1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0]'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
file_path: mindsdb/tests/handler_tests/test_pinecone_handler.py
imports: import importlib
  from unittest.mock import patch
  import os
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from tests.unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 4 for calling the TestPineconeHandler obj's underlying member method code with example usage: obj.test_select_from(postgres_handler_mock) without return types