Comment by aspirin

Yes, PostGIS supports projection agnostic ”geography” types: https://postgis.net/workshops/postgis-intro/geography.html