What is the bug or the crash? When you open the "Execute SQL" dialog from a layer, the dialog opens as "Layer name - Execute SQL". Start typing anything and the layer name vanishes from the dialog ...

ContainerLifetime.Persistent seemed to be a good solution because the containers appeared to be persistent on restart, but they are in fact unavailable when the Aspire project is stopped.