code: def test_select_from(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": [
                  "7fef88f7-411d-5669-b42d-bf5fc7f9b58b",
                  "52524d6e-10dc-5261-aa36-8b2efcbaa5f0",
              ],
              "content": ["this is a test", "this is a test"],
              "metadata": [{"test": "test"}, {"test": "test"}],
              "embeddings": [[1.0, 2.0, 3.0], [1.0, 2.0, 3.0]],
          }
      )
      self.set_handler(
          postgres_handler_mock, "weaviate", tables={"test_table6": df}
      )
      # create a table
      sql = """
              CREATE TABLE weaviate_test.test_table6 (
                  SELECT * FROM weaviate.df
              )
          """
      self.run_sql(sql)
  
      # query a table without any filters
      sql = """
              SELECT * FROM weaviate_test.test_table6
          """
      self.run_sql(sql)
  
      # query a table with id
      sql = """
              SELECT * FROM weaviate_test.test_table6
              WHERE id = '7fef88f7-411d-5669-b42d-bf5fc7f9b58b'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 1
  
      # query a table with a search vector, without limit
      sql = """
              SELECT * FROM weaviate_test.test_table6
              WHERE search_vector = '[1.0, 2.0, 3.0]'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # query a table with a search vector, with limit
      sql = """
              SELECT * FROM weaviate_test.test_table6
              WHERE search_vector = '[1.0, 2.0, 3.0]'
              LIMIT 1
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 1
  
      # query a table with a metadata filter
      sql = """
              SELECT * FROM weaviate_test.test_table6
              WHERE `metadata.test` = 'test'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # query a table with a metadata filter and a search vector
      sql = """
              SELECT * FROM weaviate_test.test_table6
              WHERE `metadata.test` = 'test'
              AND search_vector = '[1.0, 2.0, 3.0]'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
imports: import re
  import importlib
  from unittest.mock import patch
  import tempfile
  import psutil
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from ..unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 8 for calling the TestWeaviateHandler obj's underlying member method code with example usage: obj.test_select_from(postgres_handler_mock) without return types