Yes, Kong plans to add support for PostgreSQL (https://github.com/Mashape/kong/issues/331). In the meanwhile you can outsource Cassandra to cloud providers like https://www.instaclustr.com

For testing check out http://kongdb.org/, but don't use it in production.