Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Encountered the same issue and went with this eventually:
> ```
> CREATE OR REPLACE FUNCTION geography_to_geojson(geography) RETURNS json AS $$
>   SELECT extensions.ST_AsGeoJSON($1)::json;
> $$ LANGUAGE SQL;
> 
> CREATE CAST (geography AS json) WITH FUNCTION geography_to_geojson(geography);
> ```

thanks <@!334468192993017857> ! it worked perfectly