Interesting, sounds like a light-weight alternative to ORM (JPA uses Hibernate ORM underhood). Btw., rather than defining the configuration through generic properties, you could write configuration parser and provide users with a neat XSD schema.
Btw., I miss the link to source code.
The XSD schema is a neat idea, I hope we'll be able to implement it eventually. I already looked at some config parsers from other "official" cache stores.
I like jOOQ for its lambda support, which allows you to filter / map / reduce SQL records elegantly, with added type safety.
I also wondered whether the CacheStore interface could be extended with methods to support Infinispan Query DSL that runs directly on the underlying store / database.
We actually did something primitive along these lines with the jOOQ based SQL store, so we don't have to rely on Infinispan indexing for certain queries.
The other day we released a new version with a proper config parser and XSD schema. The config is much prettier now!
Properties are still used, but only to set the underlying data source (Hikari CP).
There's also support for metrics (via Dropwizard metrics).