I am trying to run the following PostGIS query using CartoDB's SQL API:
SELECT the_geom, ST_Area(ST_Intersection(the_geom::geography, ST_Buffer(ST_SetSRID(ST_MakePoint(-52.4379, -12.6235), 4326)::geography, 25000))) / 1000000 AS polyarea
FROM dataset1
WHERE...