Hacker News Reader

I'm looking at a retail store app. Redis comes with RedisJSON, Search and other modules to model it. So why not use it?

Sure you can use it. It's just convenient to have tooling and libraries that speak SQL.

The impedance mismatch between application and data layer goes away.

If the primary benefit is in memory access you get that too.