sqlite3 .mode option to create HTML table automatically?

[davidj411]

the CLI for sqlite3 shows .mode of "html", which formats the output in
HTML format that is good to add to <TABLE>.

BUT i have not yet found anything for sqlite in python that does this.

in fact, i found an old post saying 'if you want the output in a
table, you must create it yourself'.

Does anyone know if this is still the case?

also, i'd like to know if i can get headers in the result set.
The CLI uses '.header ON' to enable this.
is there a place where i can change this too?

thanks!
David