"Advanced" Outliners are better suited because you can tag the blocks (=lines of text) and then query them independently.
Look at https://logseq.com/ or Emacs https://www.orgroam.com/ (or is org-mode enough ?). you will have to familiarize yourself with properties and querying syntax.
Edit : You can think of it like this: by simply jotting down a new line, you add a new entry in a DB. It does not matter that one line is an idea and the next one is a task, because, Later on, when you query your DB, you will get them regrouped as you like. Also, no more rigid forms : you only add the tags and properties that you need "on the fly".
I know logseq also supports plaintext (Markdown/Org-mode) and Recurring tasks