We now have the option to pass T‑SQL queries for Lakehouse (LH) tables in both Lookup and Copy activities within data pipelines. This enables more flexibility in filtering and transforming data during pipeline execution, and additionally, each Lakehouse table now gets a unique URL to preview data, making it easier to share and validate datasets across teams.