[MLv2] [BE] Lib.dependentMetadata does not return source cards

[kamilmielnik]

To reproduce

Unit test

import { createSampleDatabase } from 'metabase-types/api/mocks/presets';
import * as Lib from 'metabase-lib';
import { createMockMetadata } from '__support__/metadata';

const SAMPLE_DATABASE = createSampleDatabase();

const SAMPLE_METADATA = createMockMetadata({
  databases: [SAMPLE_DATABASE],
});

const query = Lib.fromLegacyQuery(1, SAMPLE_METADATA, {
  type: 'query',
  query: {
    'source-table': 'card__5',
  },
  database: 1,
});

expect(Lib.dependentMetadata(query)).toEqual([
  { type: 'database', id: 1 },
  { type: 'schema', id: 1 },
  { type: 'table', id: 'card__5' },
]);

e2e test

1. git checkout 37390-dependent-metadata
2. Run e2e test title-drill.cy.spec.js -> should lead you to a table question with filtered ID (metabase#17213)

The dataset query is:

{
    "type": "query",
    "query": {
        "source-table": "card__5"
    },
    "database": 1
}

Outcome

Lib.dependentMetadata will return:

[
  { type: 'database', id: 1 },
  { type: 'schema', id: 1 },
]

While it should return:

[
  { type: 'database', id: 1 },
  { type: 'schema', id: 1 },
  { type: 'table', id: 'card__5' },
]