I have a few tables:
- Jobs have a lonlat (st_point) column
- Coverage areas have a lonlat (st_point) column and a radius (integer).
- Hubs can have multiple coverage areas.
According to the image above, there are multiple coverage areas colored blue, and a single job colored orange.
Question: How would I query for all hubs where the job lonlat point is within any one of their coverage areas?