Comment by matanrubin

Obsidian, with a few community plugins, is amazing and is exactly what you're looking for. It's true that there's a learning curve, but spending a few hours to learn a tool that you will use for years is a pretty sweet deal.

Take a look at obsidian-tasks, templater, and the dataview plugins to understand how powerful (yet simple) this is.