Currently, the Forge SQL SDK does not natively support inserting or retrieving binary data (Node.js Buffer objects) into BLOB columns. When developers attempt to insert a Buffer, the SDK serializes it as a JSON object, resulting in errors such as stmt unknown field type 245. The current workaround is to manually encode binary data as a base64 string and store it in a TEXT column, then decode it on retrieval.

 

Please consider implementing native support in the Forge SQL SDK for handling binary data:

• Allowing direct insertion and retrieval of Node.js Buffer objects (or equivalent binary types) into BLOB columns, without requiring manual base64 encoding.

• Ensuring that the SDK transparently handles serialization and deserialization of binary data, so developers can use standard SQL patterns for BLOBs.