touches.sql

select
  state_name
from
  `bigquery-public-data.geo_us_boundaries.states`
where
  st_touches(state_geom,
    (
    select
      state_geom
    from
      `bigquery-public-data.geo_us_boundaries.states`
    where
      state_name = 'Virginia'))

# this query will select all states that touch Virginia
# we can select the geometry of Virginia in a subquery
# which will return all the states it touches in our main query