As the administrator of a Fabric workspace containing a specific lakehouse named Lakehouse1, you should know the structure and types of tables within it. Lakehouse1 consists of the following tables:

1. Table1: A Delta table created through a shortcut.
2. Table2: An external table created using Spark.
3. Table3: A managed table.

Your goal is to connect to Lakehouse1 using its SQL endpoint. After establishing this connection, what capabilities will you have in terms of interactions with the data in Lakehouse1?