Zstd with training libraries should beat Brotli and Brotli will struggle with non-text data although I haven’t benchmarked
Your underlying point though remains valid that the incremental complexity of building that training data probably doesn’t warrant it because the place where that becomes valuable is quite rare particularly for typical SQLite databases. Still a neat trick thing though.