SQL Server 2016

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

CREATE TABLE logs
    ([time] datetime, [log] varchar(139))
INSERT INTO logs
    ([time], [log])
VALUES
    ('2019-02-10 05:36:09', '{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232},{"id":13,"x":99.12343123213,"y":88.123232}]}'),
    ('2019-02-10 04:24:13', '{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232}]}')
2 rows affected

SELECT logs.*
FROM logs
CROSS APPLY OPENJSON([log], '$.tags') WITH (id INT '$.id')
WHERE id = 13


time
log


2019-02-10 05:36:09.000
{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232},{"id":13,"x":99.12343123213,"y":88.123232}]}


SELECT logs.*
FROM logs
CROSS APPLY OPENJSON([log], '$.tags') WITH (id INT '$.id')
WHERE id = 12


time
log


2019-02-10 05:36:09.000
{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232},{"id":13,"x":99.12343123213,"y":88.123232}]}

2019-02-10 04:24:13.000
{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232}]}

time	log
2019-02-10 05:36:09.000	{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232},{"id":13,"x":99.12343123213,"y":88.123232}]}
2019-02-10 04:24:13.000	{"tags":[{"id":11,"x":99.12343123213,"y":88.123232},{"id":12,"x":99.12343123213,"y":88.123232}]}