Unable to open DwcA with "measurementorfacts.txt" layer

[sentry-io]

Sentry Issue: CATALOGUE-18

SystemExit: 1
(32 additional frame(s) were not displayed)
...
  File "metadata_catalogue/datasets/geoapi/views.py", line 220, in collection_item
    response_ = _feed_response(request, "get_collection_item", collection_id, item_id)
  File "metadata_catalogue/datasets/geoapi/views.py", line 491, in _feed_response
    geoapi_conf, openapi_def = config.get_config(req_to_base(request))
  File "metadata_catalogue/datasets/geoapi/models.py", line 94, in get_config
    openapi = get_oas(conf)

[frafra]

The SQL query needs must refer to the layers using their filename, not their assigned name (for some unknown reason).

[frafra]

It seems that GDAL is not coherent when dealing with layer names: OSGeo/gdal#10511.

[frafra]

<SrcLayer> needs to be specified.