It seems there is no way to override for a specific code block header
arguments specified for the whole file through #+property:
#+property: header-args:sqlite :header
#+begin_src elisp :results none
(require 'ob-sqlite)
#+end_src
I have tried "nil", etc. for ":header", but column names are always
added to results.
#+begin_src sqlite :results verbatim :header no
select 1 as "one", 2 as "two"
#+end_src
#+RESULTS:
: one,two
: 1,2
Bonus: it seems condition for :csv is inverted, so -csv is always added.
I have not managed to override comma using :separator since -csv is
added later.
I am just testing a patch for ob-sqlite, I am not a real user of it.