org-roam has a daily journal feature, which i use extensively: https://www.orgroam.com/manual.html#org_002droam_002ddailies

for querying: https://github.com/alphapapa/org-ql

for templates, see org-roam-capture and its templating system (https://www.orgroam.com/manual.html#The-Templating-System), which extends the capture templating system of vanilla org. for nicer capture templates, see https://github.com/progfolio/doct