I want to create a backend for searching roam notes in snails (something like helm). And one of the purposes is filter files by tags. My current implementation is using
(let ((query [:select [file tags] :from tags :where (like tags '("%link%")) :and (like tags '("%vehicle%")) ]) ) (org-roam-db-query query) )
I’m not quite familiar with
emacssql, is there a better way to do that?