Want to store data, query it in arbitrary and hard to foresee ways and also want to easily tune performance for these queries? Relational datastore it is.
Want to have ACID? Well, relational datastore it is.
Kafka is not the right solution for these problems.