beanquery
beanquery copied to clipboard
beancount
A customizable light-weight SQL query tool that works on tabular data, including Beancount.
**[Original report](https://bitbucket.org/blais/beancount/issue/308) by Martin Blais (Bitbucket: [blais](https://bitbucket.org/blais), GitHub: [blais](https://github.com/blais)).** ---------------------------------------- This query: SELECT date, description, tags, convert(position, 'USD'), convert(balance, 'USD'), account WHERE account ~ 'Accommodation' ORDER BY joinstr(tags) does not...
This works, and it should not (probably just evaluates to true, but it's misleading): select * from 'Income:US:Hoogle:Vacation';
**[Original report](https://bitbucket.org/blais/beancount/issue/152) by Chad Whitacre (Bitbucket: [chadwhitacre](https://bitbucket.org/chadwhitacre), GitHub: [chadwhitacre](https://github.com/chadwhitacre)).** ---------------------------------------- It's easy but annoying to calculate it manually from the subtotals for income and expense.
When the development focus will switch to performance, we may investigate an alternative way of handling `NULL` values. Instead than bubbling up `NULL`s through the BQL call stack, we can...
**[Original report](https://bitbucket.org/blais/beancount/issue/390) by Martin Michlmayr (Bitbucket: [tbm13](https://bitbucket.org/tbm13), GitHub: [tbm](https://github.com/tbm)).** ---------------------------------------- Martin mentioned on the list recently: > one can just use a SQL command, something like SELECT location WHERE >...
**[Original report](https://bitbucket.org/blais/beancount/issue/236) by Martin Michlmayr (Bitbucket: [tbm13](https://bitbucket.org/tbm13), GitHub: [tbm](https://github.com/tbm)).** ---------------------------------------- I want to use CONVERT() to convert something to its historical cost (i.e. exchange rate on date of transaction, without...
@dnicolodi - I was thinking about setting up the `mypy` type checker in github actions (after fixing existing errors). Is that ok, or would you prefer another type checker (e.g....
There would be value in adding support for rendering values as strings with some control on the formatting, and for concatenating strings. Formatting could be done with a `format()` function...
Given a colum `c` with structured type`T` having fields `a` and `b`, `SELECT c.*` would be equivalent to `SELECT c.a, c.b`.