Beancount Query Language (BQL) engine.

This crate provides a SQL-like query language for analyzing Beancount ledger data.

Overview

BQL is a specialized query language designed for financial data analysis. It operates on transaction postings while respecting double-entry bookkeeping constraints.

Query Types

• SELECT - General purpose queries with filtering, grouping, and ordering
• JOURNAL - Shorthand for account statements
• BALANCES - Shorthand for account balance tables
• PRINT - Output filtered transactions in Beancount syntax

Example

use rustledger_query::parse;

let query = parse("SELECT account, SUM(position) WHERE account ~ \"Expenses:\" GROUP BY account").unwrap();
println!("{:?}", query);

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