Anyquery is a SQL query engine that enables you to execute SQL queries on virtually anything, including SQLite databases. Moreover, as it can export a query result to an HTML table, you can transform a SQLite database into an HTML file with a straightforward SQL query.

anyquery -q "SELECT * FROM sqlite_master" --format html > tables.html

Additionally, you can modify each column using functions such as upper. For example, the following query exports a SQLite database to an HTML file and converts the name column to uppercase:

anyquery -q "SELECT upper(name), sql FROM sqlite_master" --format html > tables.html

See the functions documentation for more information on the available functions.