Always Encrypted vs Always Encrypted with secure enclaves

Hi Francesco_beqom,

No Clustered indexes, no PK or FK or unique key constraints

Enabling the enclave has no impact on your database. However, you will get an error message when you try to encrypt a column that is used in the clustered index or is PK or FK. You should remove this first before encrypting the column. I understand that this is not easy to do.

Only nested loop joins are supported

This limitation doesn't apply to Azure SQL Database or SQL Server 2022.

Escape character in LIKE operator

Escape characters are indeed not supported. Just to be clear, Always Encrypted is not supported for XML or JSON columns.