Read Data from Lakehouse inside a Fabric SQL Database (using T-SQL)

We are working on a migration project to Fabric and need to combine data from inside a SQL Database with data in a Lakehouse then write it to another table in the database. Due to T-SQL compatibilit...