[FEA] Enhance unsupported operator analysis with schema type details

[mattahrens]

To allow for more accurate analysis when qualifying workloads, we want to enhance the qualification tool to have more details about unsupported operators by type and also to parse the event log for available schema details to analyze supported operators by type.

CC @kuhushukla

Tasks

Preview Give feedback

1. [BUG] Propagate Reason/Notes for unsupported expressions like to_json from the plugin to Qtools' unsupported CSV #769
   bug core_tools +2
   
2. [BUG] Investigate handling of Subquery in Qualification tool #749
   2 of 2
   bug core_tools +2
   
3. [BUG] Qualification tool marked the Delta table merge's children queries' opreators unsupported #781
   bug core_tools +2
   
4. [BUG] Qualification unsupported_ops report does not match speedup calculations #793
   bug core_tools +2
   
5. [FEA] Ignore all unsupported operators in Delta metadata query #782
   core_tools feature request +2
6. [FEA] Classify Bigquery table reads and writes as unsupported. #696
   core_tools feature request +2
   
7. [FEA] Detect collect_set in windowing #715
   core_tools feature request +2
   
8. mark ephemeralsubstring as supported - Add support for KnownNullable and EphemeralSubstring expressions #894

[viadea]

One request before we have databricks supported opreators.csv, could we mark ephemeralsubstring as supported since this feature is added as per NVIDIA/spark-rapids#7797? thx