beanquery

beanquery copied to clipboard

Allow a balance column by referencing another column, sum up position converted at original rate

2

**[Original report](https://bitbucket.org/blais/beancount/issue/351) by Martin Michlmayr (Bitbucket: [tbm13](https://bitbucket.org/tbm13), GitHub: [tbm](https://github.com/tbm)).** ---------------------------------------- I [posted this to the beancount list](https://groups.google.com/forum/#!topic/beancount/SGDBejEtd0I) and Martin said this isn't supported at the moment. Opening a ticket. I...

blais

Implement `WHERE` for `PRINT`

2

It seems like `print` only supports `from`. What do you think of adding `where` to `print` and how hard would it be? Ledger allows this and this is a great...

tbm

The CSV table renderer goes the same column values formatting code used by the display renderer. Most of the work done by the renderers is not required for exporting to...

dnicolodi

According to the documentation for the `query` directive https://beancount.github.io/docs/beancount_language_syntax.html#query: > Also, the date of the query is intended to be the date at which the query is intended to be...

dnicolodi

Make the division operator handle division by zero returning `NULL` as in SQL and eventually remove the `SAFE_DIV()` function.

dnicolodi

Column name specified via AS can't be used in WHERE

5

**[Original report](https://bitbucket.org/blais/beancount/issue/344) by Martin Michlmayr (Bitbucket: [tbm13](https://bitbucket.org/tbm13), GitHub: [tbm](https://github.com/tbm)).** ---------------------------------------- I specify a column name via "AS foo" but then "WHERE foo" says that "foo" is an invalid column. It...

blais

Support quoted identifiers

4

Currently BQL uses single `'` and double `"` quotes interchangeably as string delimiters and does not have the concept of quoted identifiers. This make is impossible to have column names...

dnicolodi

What to replace `open_meta()` and `commodity_meta()` and similar with

1

Working toward the goal on making beanquery a general purpose SQL-like query language for arbitrary data and make the BQL language more regular, we need to decide what to do...

dnicolodi

GROUP BY and financial year

2

SELECT YEAR, SUM(position) WHERE account ~ '^Income' GROUP BY YEAR ORDER BY YEAR Unfortunately, the financial year is not the calendar year. It would be nice for BQL to somehow...

tbm

ORDER BY clause with no target should work

1

This should work: beancount> select account, sum(position) where currency = 'IRAUSD' group by account order by type; ERROR: All non-aggregates must be covered by GROUP-BY clause in aggregate query.

blais