>>106235483
>so I can make some small dynamic reports.
Have you used ob-sqlite before?
https://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sqlite.html
- This is distinct from (but similar to) ob-sql.
- It's also a new since Emacs 29.
- It lets you put SQL queries in org-mode src blocks and execute them against SQLite and get their results in the same org document.
Those resultsets can then be turned into plots.
https://orgmode.org/worg/org-tutorials/org-plot.html