flatten_json.sql

SELECT (route ->> 'lng')::float AS lng,
       (route ->> 'lat')::float AS lat,
       id AS endo_id,
       TYPE
FROM
  ( SELECT json_array_elements(route) route,
       id,
       TYPE
   FROM workouts LIMIT 5) w;