write a custom PyQGIS script to read gpkg_data_columns and apply those values to the QGIS layer’s field aliases and comments at load time because QGIS does not read gpkg_data_columns metadata (aliases, comments) from GeoPackage

[NewGraphEnvironment]

We created and populated the gpkg_data_columns table exactly as specified in the GeoPackage standard:
https://www.geopackage.org/spec121/#_data_columns

Commit reference:

QGIS successfully loads the GeoPackage layers, but ignores the name (alias) and description (comment) fields from gpkg_data_columns. The metadata is present and valid, but does not appear in the QGIS Fields panel.

To make this usable, we would need to write a custom PyQGIS script to read gpkg_data_columns and apply those values to the QGIS layer’s field aliases and comments at load time.