Indeed this page is not up to date (we'll update it) and as you correctly found out SQLKeyValueStore can be used for the key/value store. And actually it is automatically used if you don't specify nuxeo.keyvalue.provider=mongodb (done by default by the mongodb template) or nuxeo.keyvalue.provider=redis (done by default by the redis template).
Note that in a cluster setting you also need a pub/sub provider, which can be either Redis or Stream. If you use the redis template then the default is nuxeo.pubsub.provider=redis, otherwise if you specify nuxeo.pubsub.provider=stream a Stream-based implementation will be used; specify kafka.enabled=true for the Kafka implementation otherwise the default will be Chronicle Queue which is not cluster-aware (streams aren't shared between nodes). If you don't specify any nuxeo.pubsub.provider then you'll get a memory-based one which isn't cluster-aware either, nor is it resilient to server restarts.
