[SPARK-3688][SQL]LogicalPlan can't resolve column correctlly

we should add some judgements base on the datatype to handle some particular sql described in https://issues.apache.org/jira/browse/SPARK-3688
Maybe this?

```scala
(option.dataType, remainingParts) match {
  // No nesting
  case (_, _ :: Nil) => (option, Nil) :: Nil
  // Points to nested field(s) of a structure
  case (_: StructType, _ :: tail) => (option, tail) :: Nil
  // Invalid
  case _ => Nil
}
```