Inconsistent output format of bean-query

[willocho]

I'm running bean-query from the cli. I'm trying to output a list of account names for passing to a different program.

When I run the query select distinct accounts from the command line, I receive strange output.

accounts
----------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------
Expenses:Personal:Grocery  Liabilities:US:Apple:AppleCard
Expenses:Personal:Other  Liabilities:US:Apple:AppleCard
Expenses:Personal:Other  Liabilities:US:AmericanExpress:DeltaSkyMiles
Expenses:Personal:Grocery  Liabilities:US:AmericanExpress:DeltaSkyMiles

Expenses:Personal:Restaurant  Liabilities:US:Apple:AppleCard
Expenses:Personal:Restaurant  Liabilities:US:AmericanExpress:DeltaSkyMiles
Assets:US:UWCU:Checking  Liabilities:US:Apple:AppleCard
Assets:US:Apple:Cash  Assets:US:CapitalOne:Rewards  Assets:US:ETrade:Individual:BSV  Assets:US:ETrade:Individual:Cash  Assets:US:ETrade:Individual:FNDF  Assets:US:ETrade:Individual:VEMAX  Assets:US:LMCU:Checking Assets:US:LMCU:Savings  Assets:US:TreasuryDirect:Bills  Assets:US:TreasuryDirect:IBonds  Assets:US:UWCU:Checking  Assets:US:UWCU:Savings  Assets:US:Venmo  Equity:Personal:Liquid  Liabilities:US:CapitalOne:Quicksilver  Liabilities:US:CapitalOne:Savor
Assets:US:Accrue:401k:Pre-Tax  Assets:US:Accrue:401k:Roth  Assets:US:ETrade:RothIRA:BIV  Assets:US:ETrade:RothIRA:Cash  Assets:US:ETrade:RothIRA:VEMAX  Assets:US:TreasuryDirect:Notes  Equity:Personal:Non-Liquid
Assets:US:AmericanExpress:Rewards  Equity:Personal:SkyMiles
Assets:US:UWCU:Checking  Expenses:TY2026:FICA  Expenses:TY2026:Federal-Tax  Expenses:TY2026:Medicare  Expenses:TY2026:State-Tax

The output is inconsistent with 0-4 accounts per line. I get essentially the same results if I use -f csv when I run the command. Is there a setting or cli parameter I can pass to get one account per line?

[willocho]

Versions are beanquery 0.2.0, beancount 3.2.0 and I'm on Manjaro Linux running zsh.

[dnicolodi]

The accounts column of the postings table (the table implicitly used in beanquery when one is not specified) contains a list of all the accounts involved in the transaction. The account column of the same table contains the account referred in a single posting. I suspect you want

SELECT DISTINCT account

or, depending on what you want to achieve,

SELECT account FROM #accounts