another way of making temporary table by using UNNEST

in.sql

-- refers to https://pod.hatenablog.com/entry/2021/08/04/111107
WITH points AS (
    select * from UNNEST(ARRAY<STRUCT<id int, p STRUCT<x int64, y int64>>>[
        (1, (0, 10)),
        (2, (0, 10)),
        (2, (0, 10))
    ])
)
SELECT * FROM points

out.json

[
  {
    "id": "1",
    "p": {
      "x": "0",
      "y": "10"
    }
  },
  {
    "id": "2",
    "p": {
      "x": "0",
      "y": "10"
    }
  },
  {
    "id": "2",
    "p": {
      "x": "0",
      "y": "10"
    }
  }
]