Since a picture is worth 1k words, I attached two editing
scenarios: regular user and an administrative user.

The section "Queries I created" is the same for both.

For Queries created by others, the admin gets to edit the query
but can not make it private. We also list who owns the query.

For retired queries that are not in user/queries they just disappear.
If a active query you created is in your retired list, you get to
restore it. Then you can remove it from your list and re-retire if you want.

If the retired query is not yours, you can remove it from your active
list and it disappears.

Does that seem like a reasonable workflow?

-- rouilj