CLI: Add `spacetime subscribe "SELECT...`

[Centril]

1. Create a proposal to add spacetime subscribe command to the CLI.
   https://github.com/clockworklabs/SpacetimeDBPrivate/pull/806
2. Implement said proposal with details.
3. Use the command in the smoketests where necessary.

cc @coolreader18