List details of all referenced tables in WorkspaceInfo API scan result

[kushal_i]

Currently, only the details of tables loaded to the report show up in the WorkspaceInfo API scan result. Now, if table X references another table Y in its source query expression, and only table X is loaded into the report, we don't get the details of the referenced table Y in the scan result. Ideally, the API should return the metadata of the tables used in a report, even if it's not loaded to the report.

[ddugas1]

This will ultimately allow the platform to address more complex lineage scenarios.