Routing with CARTO functions

query.sql

WITH 
 origin as (
   SELECT cartodb_id, name, the_geom FROM populated_places WHERE name ilike 'madrid'
 ), 
 destiny as (
   SELECT cartodb_id, name, the_geom FROM populated_places WHERE adm0name ilike 'spain'
 )
SELECT destiny.cartodb_id, origin.name || '-' || destiny.name as route, r.shape as the_geom, r.length, r.duration/60 as minutes
FROM origin, destiny, cdb_route_point_to_point(origin.the_geom, destiny.the_geom, 'car') r
WHERE origin.cartodb_id <> destiny.cartodb_id