docstr: test sql in general
          
docstr_tok: ["test","sql","in","general"]
code: def test_sql_general_syntax(self):
      """test sql in general"""
      select_const_int = [
          "select 1",
          "select 1;",
          "SELECT 1",
          "Select 1",
          "   select   1   ",
          """   select
                    1;
              """,
      ]
      select_const_int_alias = [
          "select 1 as `2`",
          # "select 1 as '2'",     https://github.com/mindsdb/mindsdb_sql/issues/198
          'select 1 as "2"',
          "select 1 `2`",
          # "select 1 '2'",     https://github.com/mindsdb/mindsdb_sql/issues/198
          'select 1 "2"',
      ]
      select_const_str = ['select "a"', "select 'a'"]
      select_const_str_alias = [
          'select "a" as b',
          "select 'a' as b",
          'select "a" b',
          # 'select "a" "b"',   # => ab
          'select "a" `b`',
          # "select 'a' 'b'"    # => ab
      ]
      bunch = [
          {"queries": select_const_int, "result": 1, "alias": "1"},
          {
              "queries": select_const_int_alias,
              "result": 1,
              "alias": "2",
          },
          {"queries": select_const_str, "result": "a", "alias": "a"},
          {
              "queries": select_const_str_alias,
              "result": "a",
              "alias": "b",
          },
      ]
      for group in bunch:
          queries = group["queries"]
          expected_result = group["result"]
          expected_alias = group["alias"]
          for query in queries:
              print(query)
              resp = self.sql_via_http(query, RESPONSE_TYPE.TABLE)
              try:
                  assert len(resp["column_names"]) == 1
                  assert resp["column_names"][0] == expected_alias
                  assert len(resp["data"]) == 1
                  assert len(resp["data"][0]) == 1
                  assert resp["data"][0][0] == expected_result
              except Exception:
                  print(f"Error in query: {query}")
                  raise
  
imports: from pathlib import Path
  import json
  import requests
  import pandas
  import pytest
  from mindsdb.api.executor.data_types.response_type import RESPONSE_TYPE
  from .conftest import make_test_csv
  from .http_test_helpers import HTTPHelperMixin
label_desc: Use image node_id 8 for calling the TestHTTP obj's underlying member method code with example usage: obj.test_sql_general_syntax() without return types