SQL & CartoCSS for routing

query.sql

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')

style.css

#table_name{
 line-opacity: 1;
 line-color: #000;
 line-width: 5;
}