AI-powered mission intelligence at scale

1-- Find latest five assets within 50km of a point of interest
2-- and join with their latest telemetry data
3SELECT
4                   id, 
5                   type, 
6                   position,
7                   ->(SELECT * FROM telemetry ORDER BY timestamp DESC LIMIT 5).{ 
8                               id, 
9                               timestamp,
10                               asset: out 
11                   } AS latest
12               FROM asset
13               WHERE geo::distance(position, (-77.0369, 38.9072)) < 50000;