beanquery icon indicating copy to clipboard operation
beanquery copied to clipboard

Find a better solution for the `OPEN ON`, `CLOSE ON` and `CLEAR` clauses

Open dnicolodi opened this issue 1 year ago • 1 comments

Quoting from TODO.md:

The OPEN ON and CLOSE ON syntaxes get on my nerves.

I'm not so bothered by the syntax, but it is a very Beancount centric extension of the SQL syntax that maybe could be expressed in a nicer way without leaking the domain specific issue into the general purpose query language. However, no better syntax comes to mind.

dnicolodi avatar Jun 15 '24 20:06 dnicolodi

I gave this some thought in the past: these could be part of the table specification, e.g., ```

SELECT date, narration FROM beancount(/path/to/filename)

with options, e.g.

SELECT date, narration FROM beancount(/path/to/filename, open=2021-01-01, close=2022-01-01)


blais avatar Jun 16 '24 15:06 blais