code: def test_get_column_name_adhoc():
      column = deepcopy(SQL_ADHOC_COLUMN)
      assert get_column_name(column) == "My Adhoc Column"
      assert (
          get_column_name(
              column, {"My Adhoc Column": "My Irrelevant Mapping"}
          )
          == "My Adhoc Column"
      )
      del column["label"]
      assert (
          get_column_name(column)
          == "case when foo = 1 then 'foo' else 'bar' end"
      )
      column["label"] = ""
      assert (
          get_column_name(column)
          == "case when foo = 1 then 'foo' else 'bar' end"
      )
  
file_path: superset/tests/unit_tests/core_tests.py
imports: from copy import deepcopy
  import pytest
  from superset.utils.core import AdhocColumn, AdhocMetric, ExtraFiltersReasonType, ExtraFiltersTimeColumnType, GenericDataType, get_column_name, get_column_names, get_metric_name, get_metric_names, get_time_filter_status, is_adhoc_metric
  from tests.unit_tests.fixtures.datasets import get_dataset_mock
label_desc: Use image node_id 6 for calling a global function with example usage: test_get_column_name_adhoc() without return types