If I change the SQL Schema to 'dbo' and replicate the tutorial/RelationalDatabasesQuickStart, the command (Circuit is the SQL table and Id and CircuitName are the fields):
EntityValue["Circuit", {"Id", "CircuitName"}, "Dataset"]
results with the 1st column (key?) as
{Key[Entity["Circuit", 1]]}
is there a way to get ("Id" is the SQL Primary Key)
{Key[1]}
in the first column instead?
Put a different way, what is the reason for the Entity in the key? The Dataset Planets example does not have the Entity.