[BE] [QP] [Bug] Incorrect metadata for a native model column overriden to a FK

[ranquild]

should allow drills on FK columns from dashboards E2E test fails because there is a mismatch between metadata in /api/table/card__:id/query_metadata and /api/card/:id. Run link

Actual:

• semantic_type of the overriden field in query_metadata is null but type/FK in /api/card/:id

Expected:

• semantic_type is the same in both endpoints - type/FK in this case

The issue is present in master, but since we moved some stuff to MBQL lib it started to cause issues because of https://github.com/metabase/metabase/blob/0633cd87702d085791aa73efd4a12b3a96127673/src/metabase/lib/card.cljc#L107