Azure SQL Developer: capabilities, limits, and why

Use this skill to answer "can I / why can't I / is X supported / what's different from the cloud" questions accurately, instead of guessing from general SQL Server or Azure SQL Database knowledge. A base model does not know this preview product's specifics, and the honest answers are often nuanced.

The mental model: engine vs. managed service vs. SQL Server

The container is the Azure SQL Database engine, running locally. It is not the managed cloud service, and it is not the SQL Server. Sort almost any "is X supported" question into one of four buckets and the answer follows: