Would love something like that for storing large image datasets for computer vision. Storing embeddings, predictions and metadata in a contiguous format with compression support, ANN indexing support and SQL would be amazing.
There is an SQLite compression and encryption "add-on" which seems to do what you want. Check the official website.
Hint: You have to buy a license to use it legally.