singlestoredb-python icon indicating copy to clipboard operation
singlestoredb-python copied to clipboard

Add JSON support for UDF inputs and outputs

Open kesmit13 opened this issue 3 months ago • 0 comments

This branch includes support for JSON inputs and outputs for UDFs. This includes ways of specifying the JSON SQL type and applying transformers on the inputs and outputs to translate to and from strings that the database engine requires. Rather than just supporting a JSON type, this branch implements a way of specifying custom types with a specific SQL type for the input / output, and transformer functions for the inputs and outputs. These are wrapper in an Annotated object in the Python type annotation and can be used by customers as well as internal developers for creating new types. This process will eventually be used to support the vector types and other complex SingleStoreDB types.

kesmit13 avatar Oct 03 '25 17:10 kesmit13