What changes to the engine/sql interpreter/whatever would it take to
allow me to insert a record with a blob directly with a query?

Example:
CREATE TABLE MyTable (
MyText BLOB SUB_TYPE TEXT,
MyBinary BLOB
)

INSERT
INTO MyTable(MyText, MyBinary)
VALUES (
'John', /* This text should be interpreted as text stream. */
'21ab4c' /* This could be a base64 encoded binary stream. */
)

Marcelo Lopez Ruiz