code: def test_presto_expand_data_with_complex_array_columns(self):
      cols = [
          {
              "name": "int_column",
              "column_name": "int_column",
              "type": "BIGINT",
              "is_dttm": False,
          },
          {
              "name": "array_column",
              "column_name": "array_column",
              "type": "ARRAY(ROW(NESTED_ARRAY ARRAY(ROW(NESTED_OBJ VARCHAR))))",
              "is_dttm": False,
          },
      ]
      data = [
          {
              "int_column": 1,
              "array_column": [[[["a"], ["b"]]], [[["c"], ["d"]]]],
          },
          {
              "int_column": 2,
              "array_column": [[[["e"], ["f"]]], [[["g"], ["h"]]]],
          },
      ]
      (
          actual_cols,
          actual_data,
          actual_expanded_cols,
      ) = PrestoEngineSpec.expand_data(cols, data)
      expected_cols = [
          {
              "name": "int_column",
              "column_name": "int_column",
              "type": "BIGINT",
              "is_dttm": False,
          },
          {
              "name": "array_column",
              "column_name": "array_column",
              "type": "ARRAY(ROW(NESTED_ARRAY ARRAY(ROW(NESTED_OBJ VARCHAR))))",
              "is_dttm": False,
          },
          {
              "name": "array_column.nested_array",
              "column_name": "array_column.nested_array",
              "type": "ARRAY(ROW(NESTED_OBJ VARCHAR))",
              "is_dttm": False,
          },
          {
              "name": "array_column.nested_array.nested_obj",
              "column_name": "array_column.nested_array.nested_obj",
              "type": "VARCHAR",
              "is_dttm": False,
          },
      ]
      expected_data = [
          {
              "array_column": [[["a"], ["b"]]],
              "array_column.nested_array": ["a"],
              "array_column.nested_array.nested_obj": "a",
              "int_column": 1,
          },
          {
              "array_column": "",
              "array_column.nested_array": ["b"],
              "array_column.nested_array.nested_obj": "b",
              "int_column": "",
          },
          {
              "array_column": [[["c"], ["d"]]],
              "array_column.nested_array": ["c"],
              "array_column.nested_array.nested_obj": "c",
              "int_column": "",
          },
          {
              "array_column": "",
              "array_column.nested_array": ["d"],
              "array_column.nested_array.nested_obj": "d",
              "int_column": "",
          },
          {
              "array_column": [[["e"], ["f"]]],
              "array_column.nested_array": ["e"],
              "array_column.nested_array.nested_obj": "e",
              "int_column": 2,
          },
          {
              "array_column": "",
              "array_column.nested_array": ["f"],
              "array_column.nested_array.nested_obj": "f",
              "int_column": "",
          },
          {
              "array_column": [[["g"], ["h"]]],
              "array_column.nested_array": ["g"],
              "array_column.nested_array.nested_obj": "g",
              "int_column": "",
          },
          {
              "array_column": "",
              "array_column.nested_array": ["h"],
              "array_column.nested_array.nested_obj": "h",
              "int_column": "",
          },
      ]
      expected_expanded_cols = [
          {
              "name": "array_column.nested_array",
              "column_name": "array_column.nested_array",
              "type": "ARRAY(ROW(NESTED_OBJ VARCHAR))",
              "is_dttm": False,
          },
          {
              "name": "array_column.nested_array.nested_obj",
              "column_name": "array_column.nested_array.nested_obj",
              "type": "VARCHAR",
              "is_dttm": False,
          },
      ]
      self.assertEqual(actual_cols, expected_cols)
      self.assertEqual(actual_data, expected_data)
      self.assertEqual(actual_expanded_cols, expected_expanded_cols)
  
imports: from collections import namedtuple
  from textwrap import dedent
  from unittest import mock, skipUnless
  import pandas
  from flask.ctx import AppContext
  from sqlalchemy import types
  from sqlalchemy.sql import select
  from superset.db_engine_specs.presto import PrestoEngineSpec
  from superset.errors import ErrorLevel, SupersetError, SupersetErrorType
  from superset.sql_parse import ParsedQuery
  from superset.utils.database import get_example_database
  from tests.integration_tests.db_engine_specs.base_tests import TestDbEngineSpec
label_desc: Use image node_id 16 for calling the TestPrestoDbEngineSpec obj's underlying member method code with example usage: obj.test_presto_expand_data_with_complex_array_columns() without return types