SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE features ( id INTEGER PRIMARY KEY, data TEXT )
✓
INSERT INTO features (data) VALUES
('{"A":{"B":{"coordinates":[{"x":1,"y":1},{"x":10,"y":10}]}}}'),
('{"A":{"B":{"coordinates":[{"x":4,"y":6},{"x":5,"y":11}]}}}');
✓
SELECT json(data) FROM features;

{
  "code": "SQLITE_ERROR"
}


UPDATE features
SET data = json_set(
             features.data, 
             "$.A.B.coordinates[0].x", json_extract(features.data, "$.A.B.coordinates[0].x") * 2,
             "$.A.B.coordinates[0].y", json_extract(features.data, "$.A.B.coordinates[0].y") * 2,
             "$.A.B.coordinates[1].x", json_extract(features.data, "$.A.B.coordinates[1].x") * 2,
             "$.A.B.coordinates[1].y", json_extract(features.data, "$.A.B.coordinates[1].y") * 2
           );

{
  "code": "SQLITE_ERROR"
}


SELECT * FROM features;


id
data


1
{"A":{"B":{"coordinates":[{"x":1,"y":1},{"x":10,"y":10}]}}}

2
{"A":{"B":{"coordinates":[{"x":4,"y":6},{"x":5,"y":11}]}}}

id	data
1	{"A":{"B":{"coordinates":[{"x":1,"y":1},{"x":10,"y":10}]}}}
2	{"A":{"B":{"coordinates":[{"x":4,"y":6},{"x":5,"y":11}]}}}