`spacetime sql` says credentials are incorrect when `-a` is passed

[bfops]

We tried to run a spacetime sql query as a non-admin user and attempted to use the -a flag (which allows for passing an anonymous identity to SpacetimeDB). When we did this, we got a 401: Unauthorized even when using spacetime sql on a public table. This should not be the case and you should be able to use spacetime sql on public tables and you should also be able to use spacetime call on reducers even with an anonymous identity.

Definition of Done

• [ ] Passing -a correct results in creating a new identity for the user on-the-fly
  • So -a functions the same as manually creating a new (non-privileged) identity and then using that identity to do the thing
• [ ] An integration test is added so that this can't be regressed

[cloutiertyler]

Context: https://discord.com/channels/931210784011321394/1270434226814324862/1271084529854976071

[bfops]

I was unable to repro:

my_new_project $ spacetime sql -a -s local test-module 'select * from PrivateTable;'
Error: HTTP status Client error (401 Unauthorized): UnauthorizedError: "Table `PrivateTable` is private"

my_new_project $ spacetime sql -a -s local test-module 'select * from PublicTable;'
 name 
------

[bfops]

I was able to repro this successfully, but only on 0.10.1. I think it must have been fixed somehow since then.