Full support for scylladb as persistence layer

Is your feature request related to a problem? Please describe.
Temporal community is time to time struggling when using scylladb as persistence layer, scylladb is not officially integrated
as one of available persistence layers.

Describe the solution you'd like
I would like to provide support for temporal community and help to accept scylladb as persistence layer, I would like to ask
for guidance how to approach this integration, is there is a list of features that persistence layer must support ? How I make sure
that scylladb integration meet all of the requirements ?

Describe alternatives you've considered
I know that some community members already use scylladb, I could define the scope of work and ask if any of the community members would like to help on making scylladb officially supported.

Additional context
Nothing to add for now, I general I need guidance and advise how to approach the integration, how to test so it is accepted by temporal.

The issue names no files, tests, or entry points. Start by reviewing how existing persistence layers are integrated and identifying the required ScyllaDB capabilities and acceptance tests; done means the requirements and scope for official support are defined and the integration passes them.