Hello devs I have a compressed database with sqlite_zstd which i would like to use in an android app with room database. knowing the shipped version of sqlite in android doesn't support extensions, requery/sqlite_android was used to load the extension for sqlite_zstd. the challenge the database tables do not remain the same after compression and the column types do not match when i use it as a pre-packaged database for room hence the error

Pre-packaged database has an invalid schema:

I have the full question over on stackoverflow at https://stackoverflow.com/questions/77493447/using-compressed-prepopulated-database-with-room