This looks really neat, thanks for publishing!
Sincerely, Timothy Jesionowski On Mon, Sep 15, 2025, 2:14 PM Oscar & Ale <[email protected]> wrote: > Hello everyone, in case someone else may find this useful, I created a > small cli tool called `bean-inquiry` to help run queries with parameters, > based on the discussion here: > https://groups.google.com/g/beancount/c/td18CgN1y-0/m/zK2oeiz-BgAJ. > > You can write your query directive like so in your ledger: > > ``` > 2025-01-01 query "balance" "SELECT date, narration, account, position > WHERE account ~ '{}' AND year >= {}" > ``` > > And then run `bean-inquiry` like so: > > ``` > bean-inquiry ledger.beancount balance Assets 2025 > ``` > > Indexed placeholders `{0}, {1}` and named placeholders `{account}, {year}` > work as well. Just specify the key of the placeholder like so: > > ``` > 2025-01-01 query "balance" "SELECT date, narration, account, position > WHERE account ~ '{account}' AND year >= {year}" > ... > bean-inquiry ledger.beancount balance account:Assets year:2025 > ``` > > I believe this is something that is in the works for `beanquery` based on > the discussion here: https://github.com/beancount/beanquery/issues/249 > but in the meantime, I have found this pretty helpful and wanted to share > it. It is available on PyPi here: https://pypi.org/project/bean-inquiry/. > To install it I recommend using pipx `pipx install bean-inquiry` > > > Thanks! > > Oscar & Ale > [email protected] > > -- > You received this message because you are subscribed to the Google Groups > "Beancount" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/beancount/48cdbe610d64e5a947489f98c113aa44e0bb46d1%40aleyoscar.com > . > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/beancount/CAOVsoWSb1sj-P68s8djQSOKH57SgwEPnkKiONnjrMnFN5UQd1Q%40mail.gmail.com.
