SELECT pt.id
FROM points_table pt
WHERE ST_DWithin(ST_GeomFromText('POINT 0 0', 3857), pt.geom, 500);

SELECT * from your_table AS a
where ST_Intersects(a.geom,
ST_Envelope(
ST_Buffer(
ST_GeomFromText('POINT (-108 43)',4326),10)));