rustledger-query

Beancount Query Language (BQL) engine with SQL-like syntax.

Supported Syntax

SELECT account, SUM(position)
WHERE account ~ 'Expenses:'
GROUP BY account
ORDER BY SUM(position) DESC
LIMIT 10

Features

• Full BQL support (SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, PIVOT BY)
• FROM clause for system tables (#entries, #postings, etc.)
• Regex pattern matching (~ operator)
• Aggregate functions (SUM, COUNT, FIRST, LAST, MIN, MAX)
• Date functions (YEAR, MONTH, DAY, QUARTER)
• String functions (LENGTH, UPPER, LOWER)
• Account functions (ROOT, LEAF, PARENT)

Example

use rustledger_query::{parse, Executor};

let query = parse("SELECT account, SUM(position) GROUP BY account")?;
let mut executor = Executor::new(&directives);
let results = executor.execute(&query)?;

for row in &results.rows {
    println!("{:?}", row);
}

License

GPL-3.0