SQL Queries don't respect ignore_malformed setting

Plugins SQL
1

Hello, I’m having troubles with SQL Queries, when doing a select all,
SELECT * FROM test-index-00
the query fails with

{
  "error": {
    "type": "IllegalStateException",
    "reason": "There was internal problem at backend",
    "details": "No type found for field: nested.nested.text."
  },
  "status": 503
}

Is there some setting here that I’m missing? My assumption would be that with the index setting to set malformed to true and dynamic to true, these issues wouldn’t be an issue,

"settings": {
            ......
            "index.mapping.ignore_malformed": true
        },
        "mappings": {
          "dynamic":"true",
            "dynamic_templates": [{
                "array_to_nested": {
                    "match_mapping_type": "object",
                    "mapping": {
                        "type": "nested"
                    }
                }
            }],

and that these fields would be ignored, but that doesn’t seem to be the case.

Queries with more defined Selects don’t see this issue, as they avoid the malformed/not mapped field.

We are trying to avoid adding a bunch of static mappings since our JSON entries can be very fluid, for example

job.settings.inputs.selectors.selection : int
can also be
job.settings.inputs.selectors.Selector 1.selection : ?
where the second option with Selector 1 isn’t mapped dynamically

Any solution here on my end?