KineticaJson

Values for the Kinetica types SQLx’s own PostgreSQL types cannot read or write over Kinetica’s protocol, or cannot reliably: see their module. A JSON column’s value: anything serde serializes, bound directly as JSON, and read back from the JSON Kinetica sends.

SQLx’s own serde_json::Value and sqlx::types::Json bind as PostgreSQL’s JSONB, whose binary form starts with a version byte, which Kinetica refuses as invalid JSON. This binds the JSON type instead, whose value is the JSON text itself, so it reaches its column in any parameter position. It reads JSON and JSONB columns, and text such as JSON_QUERY’s.