Ha, careful with those chairs!
I was able to pretty quickly take your code and use this function to query it 🙂
SELECT
*
FROM OPENJSON
(
[dbo].[clr_http_request]('GET', 'http://overpass-api.de/api/interpreter?data=[out:json];area[name=%22Auckland%22]-%3E.a;(node(area.a)[amenity=cinema];way(area.a)[amenity=cinema];rel(area.a)[amenity=cinema]; );out;', NULL, NULL, 10000, 0, 0).value('/Response[1]/Body[1]', 'NVARCHAR(MAX)'),
'$.elements'
)
WITH
(
[type] nvarchar(max) N'$.type' ,
[id] nvarchar(max) N'$.id',
[lat] nvarchar(max) N'$.lat',
[lon] nvarchar(max) N'$.lon',
[amenity] nvarchar(max) N'$.tags.amenity',
[name] nvarchar(max) N'$.tags.name'
)