beanquery
beanquery copied to clipboard
A customizable light-weight SQL query tool that works on tabular data, including Beancount.
WIP: the code is a mess and needs substantial refactoring, but it works!
Currently, `[...] GROUP BY links` throws the following exception: beanquery.compiler.CompilationError: GROUP-BY a non-hashable type is not supported: "Column(name='links')" because `set` is not hashable. `frozenset` is hashable, and can be used...
The beancount data source compuites data for all tables when the source is loaded. Some of the data may never be used in actual queries and may be expensive to...
Tracking issue for deprecations to be introduced in version 0.3.0. Approximately in order of importance, or in order of how annoying the features are to maintain: - expressions in the...
It seems that beancount v2 used `~/.bean-shell-history` as the history while beanquery uses `~/.config/beanquery/history`. Maybe this could documented somewhere, so people can move the old history to the new location...
This most likely requires moving away from a simple `cmd.Cmd` interpreter loop and it requires the parser to be able to detect incomplete commads. It may be very difficult to...
It is recommended to implement complex size filtering and restriction statements for position or other similar values, which will greatly increase the query capability of BQL. Although we can accurately...
There were two matching operators: * subject ~ pattern (case-insensitive) * pattern ?~ subject (case-sensitive) This is somewhat confusing for newcomers. The reason maybe is that it allows for this:...
As someone new to beancount, I found the function documentation really hard to navigate. The old `help functions` dumped everything on screen at once, which was overwhelming. While developing a...
Hi! Is there a way to display column totals at the end of the report? I.e., if I run ```sql balances where account ~ 'leave' and date