Beanquery: Customizable lightweight SQL query tool

beanquery is a customizable and extensible lightweight SQL query tool that works on tabular data, including Beancount ledger data.

With this tool you can write queries to extract information from your Beancount ledger. This is the documentation of functions and field names which are available for queries.

Please read the Manual of the Beancount Query Language (BQL) if you do not yet know how to write queries.

Targets

In a BQL query, you can reference various data fields as targets. Here you find the list of targets:

• …for the SELECT ... and FROM ... clauses: Targets: Entry.

• …for the WHERE ... clause: Fields: Posting

Functions in the Beancount query language

If you are looking for a particular function, best start at the list of BQL Functions by Category

You can also see the alphabetical list of List of all BQL Functions