Tables relationship Merged

What is the problem or goal the end user is trying to solve or accomplish?

User is looking for ability to define relationship between tables

How are they solving it currently?

Manual table joining using SQL Query

What is the recommended solution by the Customer?

Something similar to PowerBI Table Relationship:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships