text: Title: Running query in superset sqllab with shillelagh driver returns Unsupported table error
  Body: **Describe the bug**
  Using shillelagh with superset. Running query on internal hosted json api url returns error.
  `shillelagh error: Unsupported table: https://server.com/app/api/v1.0/storage/list`
  
  Running the query on public API works. For example: "https://date.nager.at/api/v3/publicholidays/2023/US". So that gives me the confident that shillelagh is configured correctly on superset. 
  
  Both internal and public api shows header content-type: application/json; charset=utf-8
  
  **To Reproduce**
  Steps to reproduce the behavior:
  1. from superset sqllab, run:
      `SELECT * FROM "https://server.com/app/api/v1.0/storage/list"; ` <-- does not work
  2. from superset sqllab, run:
      `SELECT * FROM "https://date.nager.at/api/v3/publicholidays/2023/US"; ` <-- works
  
  **Expected behavior**
  Expect query from internal API url works by showing the table
  
  **Screenshots**
  If applicable, add screenshots to help explain your problem.
  
  **Desktop (please complete the following information):**
   - OS: Server OS is CentOS, client is Windows OS with Chrome browser
   - Browser [e.g. chrome, safari]: Google Chrome
   - Version [e.g. 22]: 
  
  **Additional context**
  The internal API return content like below:
  ```
  [
      {
          "id": "656d951ca902d21d40bdf0f8",
          "path": "\\\\10.11.10.101\\datavol\\raw_file\\OX02C10\\P8P456\\OX02C10ABA_SS_60C_EM0508_JTT\\10A4\\CP0",
          "remarks": "For _NC algorithm updates",
          "creationDate": "2023-12-04T09:00:12.473Z",
          "obsoleteDate": "0001-01-01T00:00:00Z",
          "creator": "a.gong",
          "creatorId": null
      },
      {
          "id": "656e97c58c3d9373cb8eb15c",
          "path": "\\\\10.11.10.101\\datavol\\raw_file\\OV50K40\\P8P672\\OV50K40AAA_FS_60C_EM0101\\03G6\\CP0",
          "remarks": "migrated retention",
          "creationDate": "2023-12-05T03:23:49.26Z",
          "obsoleteDate": "0001-01-01T00:00:00Z",
          "creator": "m.zou",
          "creatorId": null
      },
      {
          "id": "656eb0eaa902d21d40bdf0f9",
          "path": "\\\\172.33.10.210\\oscStorage\\datavolOsc\\raw_file_eng\\OV50H40\\PL9155\\OV50H40ABA_FS_60C_EM1306\\04C6\\CP0",
          "remarks": "pattern detection analysis",
          "creationDate": "2023-12-05T05:11:06.979Z",
          "obsoleteDate": "0001-01-01T00:00:00Z",
          "creator": "k.mao",
          "creatorId": null
      }
  ]
  ```
  