[FIX] Column lineage query with null namespace and name

[sophiely]

Problem

Closes: #2875

In some case the input dataset used seems not to be in dataset_views table so when joining the two tables it results in null for namespace and name and make the list dataset endpoint fail. dataset_views only contains the latest dataset version so if the column lineage is created with an old version, this old version will ne be in the dataset_view and then results in an empty namespace and name.

Solution

We can get the namespace and name in the dataset_versions table to make sure to have all the version of a dataset.

Checklist

• [x] You've signed-off your work
• [ ] Your changes are accompanied by tests (if relevant)
• [x] Your change contains a small diff and is self-contained
• [ ] You've updated any relevant documentation (if relevant)
• [ ] You've included a one-line summary of your change for the CHANGELOG.md (Depending on the change, this may not be necessary).
• [ ] You've versioned your .sql database schema migration according to Flyway's naming convention (if relevant)
• [ ] You've included a header in any source code files (if relevant)

[netlify[bot]]

✅ Deploy Preview for peppy-sprite-186812 canceled.

Name	Link
🔨 Latest commit	9f60d046a74073c958db105201dd0327692acdca
🔍 Latest deploy log	https://app.netlify.com/sites/peppy-sprite-186812/deploys/66ccab7d1e01560008d2a5f0

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 83.28%. Comparing base (915aff3) to head (9f60d04). Report is 1 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #2881 +/- ## ========================================= Coverage 83.28% 83.28% Complexity 1477 1477 ========================================= Files 259 259 Lines 6785 6785 Branches 313 313 ========================================= Hits 5651 5651 Misses 977 977 Partials 157 157 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.