implement named parameterized queries

[WolfgangFahl]

see beancount/beanquery#201

see e.g. https://github.com/WolfgangFahl/pyLoDStorage/blob/master/lodstorage/params.py

which does jinja compatible parameter handling and is used in https://github.com/WolfgangFahl/snapquery

with demos at https://snapquery.bitplan.com/ and https://genwiki2024.bitplan.com/

[WolfgangFahl]

npbeanquery -ep /tmp/endpoints.yaml -qp nomina_examples/queries.yaml --list
AccountSummary:AccountSummary
TotalSum:TotalSum
PayeeSummary:PayeeSummary

[WolfgangFahl]

npbeanquery  -qp nomina_examples/queries.yaml -qn TotalSum --params account=Expenses:Food:Groceries
[
  {
    "currency": "USD",
    "total": "6634.95"
  }
]

[WolfgangFahl]

npbeanquery -qp nomina_examples/queries.yaml -qn TotalSum --params account=Expenses:Food:Groceries -f github

TotalSum

query

select sum(position) as total
where account = 'Expenses:Food:Groceries'

result

total	currency
6635	USD