Support BLOB column types in client SDKs

[abdelhameedhamdy]

Hey there,

It would be great to support syncing blobs, the pros is a lot , in terms of storage efficiency (db size with blobs is compact), performance, data integrity, dealing with data directly ... etc.

I have a use case of syncing PostGIS <> SpatiaLite (SQLite extension) in react-native, geometry data type is BLOB, when syncing it locally it is mapped as TEXT, Spatial functions deals with geom blobs instead, so to workaround that either creating extra tables and triggers to sync which in turns would double the SQLite DB size and a bit verbose, or decoding the encoded-hex blob data.
So dealing with the blobs directly is more efficient in many ways.

Hope to support this feature soon.
Thanks