define GEOGRAPHY point variable in snowflake

I tried:

point GEOGRAPHY 
point := ST_MAKEPOINT(-2.6661587, 53.368992)

without success. Is this possible? To be used in SQL further down.

PS:

This:

BEGIN
	LET point GEOGRAPHY := ST_MAKEPOINT(-2.6661587, 53);
	RETURN point;
END;

SELECT
    st_distance(:point, POLYGON) AS some_distance
FROM "bla"."di"."bla"
WHERE
    1=1
ORDER BY st_distance(:point, POLYGON) ASC

throws:

Error: Bind variable :point not set. (line 7)

Using Snowflake Scripting block:

BEGIN
   LET point GEOGRAPHY := ST_MAKEPOINT(-2.6661587, 53.368992);
   RETURN point;
END;

Output:

{"coordinates":[-2.666158700000000e+00,5.336899200000000e+01],"type":"Point"}

EDIT:

CREATE OR REPLACE TABLE some_table
AS
SELECT ST_MAKEPOINT(-2.6661587, 54) POLYGON;

DECLARE 
    point GEOGRAPHY;
    rs    RESULTSET;
BEGIN
    point := ST_MAKEPOINT(-2.6661587, 53);

    rs := (EXECUTE IMMEDIATE  
            $$SELECT st_distance(TO_GEOGRAPHY(?), POLYGON) AS distance
            FROM some_table
            WHERE 1=1
            ORDER BY distance ASC$$ 
       USING (point));

    RETURN TABLE(rs);
END;

Output:

DISTANCE
111,195.101177485