Org Roam

org-roam is a powerful extension of org-mode that essentially turns it into a wiki-like system.

Queries in org-roam

Org roam uses Emacsql as the frontend to its Sqlite database. The schema is stored in org-roam-db–table-schemata:

org-roam-db--table-schemata

Note that you can also use sqlite-mode-open-file to browse the database yourself.

(sqlite-mode-open-file org-roam-db-location)