Suggestion: consider changing log_query_results_head=0 to show only column names

[damies13]

Hi

I just watched the DB Library update @ robocon 2026, firstly nice work with the updates 👍

I have a suggestion to consider changing the behaviour of log_query_results_head=0 to show only column names, and then make log_query_results_head=-1 to disable head limit

[amochin]

Hi Dave, thanks for submitting the issue! Could you please elaborate a bit more on your request?
I just can't see the value printing out only the column names.
Moreover, I believe it might be misleading - showing only column names looks for me naturally like a table with zero results - which might be not the case..

[damies13]

there are times where you just need the column names and not the data, i guess the best example I can give right now is if your verifying the schema was created correctly. some of the apps I built create an SQLite db file on first run, so in my tests I want to check the expected columns are in the table to ensure no regression, but I agree it probably wouldn't be used often

[amochin]

I see. Maybe the Description keyword would help in such a case?

[damies13]

I actually don't remember what I was thinking about when I raised this suggestion, so you are probably right showing the columns with 1 row of data is probably fine, and description could be used otherwise