I asked question in GORM repo about this https://github.com/go-gorm/gorm/issues/7189, but some solution that can be is to change sql.RawBytes to reflect.SliceOf(reflect.TypeOf(byte(0))) (as it was before) to return BLOB as byte arrays there. This then should not introduce breaking changes nor in GORM nor in go-sqlite
After this PR was merged https://github.com/mattn/go-sqlite3/pull/909/files go-sqlite started return correct types for sqlite types.
However the change of type for BLOB ends up to the fact, that in GORM deserialization of byte arrays become string. The reason of this is because GORM cast all
sql.RawBytesto strings for some reasons here https://github.com/go-gorm/gorm/blob/0daaf1747cfa4e4850376ad50a7834fb78b0cc0e/scan.go#L44 My assumption is that GORM do so, as a lot of drivers for different DBs return some good values for this sql.RawBytes. (here is example of issues raised https://github.com/go-gorm/gorm/issues/5783)I asked question in GORM repo about this https://github.com/go-gorm/gorm/issues/7189, but some solution that can be is to change
sql.RawBytestoreflect.SliceOf(reflect.TypeOf(byte(0)))(as it was before) to return BLOB as byte arrays there. This then should not introduce breaking changes nor in GORM nor in go-sqlite