https://blog.geomusings.com/2020/04/06/attribute-transfer-in-postgis-using-spatial-sql/
Attribute Transfer in PostGIS Using Spatial SQL