It is also referred to as Citus
Hyperscale turns SQL DB it into a distributed database similar to data warehouses
This feature is also available for Azure DB for PostgreSQL as well
Provides support for:
- Data Sharding
- Real-time queries
- Time series workloads
What is Hyperscale Service Tier? - Azure SQL Database | Microsoft Docs