WITH
 origin as (
   SELECT the_geom FROM table_name WHERE cartodb_id = 1
 ),
 destiny as (
   SELECT the_geom FROM table_name WHERE cartodb_id = 2
 )
SELECT ST_Transform(shape, 3857) as the_geom_webmercator
FROM origin, destiny, cdb_route_point_to_point(origin.the_geom, destiny.the_geom, 'car')