Use the Sessions extension from Tcl?
I feel that the answer should be obvious, but I am not sure whether it is obviously Yes or obviously No.
Since some of the C functions have arguments that are pointers, and Tcl does not have pointers, I think that, at the least, some kind of glue would be needed between the extension and Tcl. But my SQLite usage has been strictly Tcl, and I well could be missing something.
Any advice appreciated.
That's correct, you need some sort of wrapper code to call the C API from Tcl. It's quite an extensive interface too. I don't think that any such package exists in a ready-to-use form at present.
The wrapper code that we use for testing sessions is here:
It might be useful if you decide to develop a sessions wrapper yourself. Or if you just want to extract some functions to call the parts of sessions your app needs.