CLI correct SQL query to update struct field

[corrm]

spacetime sql conquer-mmo "SELECT * FROM character_position"
WARNING: This command is UNSTABLE and subject to breaking changes.

 character_id | prev_map_id | last_move_time                   | location                                        | direction
--------------+-------------+----------------------------------+-------------------------------------------------+--------------
 1            | 1010        | 2026-03-01T11:21:18.924697+00:00 | (map_id = 1010, x = 61, y = 109, elevation = 0) | (south = ())

spacetime sql conquer-mmo "UPDATE character_position SET location = (1000, 61, 109, 0) WHERE character_id = 1"
WARNING: This command is UNSTABLE and subject to breaking changes.

Error: Unsupported column/variable assignment expression: (1000, 61, 109, 0)

i tired a lot of syntax but no luck!. the docs show this syntax but i cant understand how to make it work!:

UPDATE table SET [ '(' assignment { ',' assignment } ')' ] [ WHERE predicate ]

[joshua-spacetime]

@corrm location is a product type and we currently don't have syntax for updating product or sum types via SQL DML. So the workaround is to use a reducer to update those types of columns.

[corrm]

@bfops No way this still a problem.!

[bfops]

Hey @corrm, this is unchanged. Is there something about your use case that makes it hard or impossible to use a reducer for this?

[corrm]

Hey @corrm, this is unchanged. Is there something about your use case that makes it hard or impossible to use a reducer for this?

AI agent running one cli command vs tell it write a reducer to edit diffrent values. Also ehat if i changed the code do i really need.to recompile the project when i need to edit a value at runtime.