sqlar and the sqlite3 tcl interface
I can't seem to find any information about using SQLite3 archives from the official Tcl SQLite3 interface documentation:
I would rather not exec to the sqlar CLI to create and manage these archives if possible.
You will need to load the sqlar.c extension and then use it to access or create an SQLAR file. The only documentation is in comments in the source file, or some vague hints at https://www.sqlite.org/cli.html#_sql_used_to_implement_sqlite_archive_operations_