Spark SQL lets you query and transform data with SQL on the Spark engine. In a Fabric notebook, it runs with the %%sql magic command and reads a lakehouse's tables like relational tables, with a syntax close to standard SQL.
Example
SELECT pays, SUM(montant) FROM ventes GROUP BY pays