orgtbl-mode

[Martin Blais]

I'm wondering if anyone ever got this working with beanquery: 

https://www.youtube.com/watch?v=g43XNwKY1YA

[Daniele Nicolodi]

On 07/11/25 04:24, Martin Blais wrote:
> I'm wondering if anyone ever got this working with beanquery:

> https://www.youtube.com/watch?v=g43XNwKY1YA <https://www.youtube.com/
> watch?v=g43XNwKY1YA>

I assume that with "this" you mean Org Babel and not orgtbl-mode.

The former is the org-mode facility for evaluating source code written
as source code blocks in an org-mode document. The latter is a major
mode to use org-mode table editing facilities to edit tables written in
other markup languages.

In this case, I just published ob-beanquery

https://github.com/dnicolodi/ob-beanquery

To use it, just drop something like

(use-package ob-beanquery
:load-path (lambda () (expand-file-name "~/src/ob-beanquery/")))

in your .emacs. Then you can evaluate code blocks like these:

#+begin_src beanquery :db test.beans :numberify yes
SELECT *
#+end_src

#+RESULTS:...

#+begin_src beanquery :db /dev/null :colnames no
SELECT 1+1 FROM #
#+end_src

#+RESULTS:
: 2

It works for me when I need it but it hasn't seen much more testing than
that and Babel has many options and capabilities that I do not use.
Submit issues if it breaks and I'll try to fix it.

Cheers,
Dan