I'm planning to connect SQL Server Management Studio (SSMS) with Databricks using Lakehouse Federation. I understand that there are some differences in the SQL dialects between SSMS and Databricks SQL. For instance, in SSMS, we use TOP 10 to limit the number of rows, whereas in Databricks SQL, we use LIMIT 10.

Could someone clarify which query language will be used when querying Databricks from SSMS in this setup? Will SSMS automatically translate the queries, or do I need to adapt them for Databricks SQL manually?