Hosting Azure SQL Databases in Multiple Regions for Compliance and Access via Single API

Question

We are looking to implement a multi-region data storage strategy using Azure SQL Database. Our goal is to store EU customer data in an Azure SQL Database located in an EU region and non-EU customer data in a US-based Azure SQL Database to meet compliance requirements.

Can we host two separate Azure SQL databases in different regions (EU and US) and access them via the same API, dynamically routing requests based on the customer’s region? Additionally, what would be the best practices for implementing this setup while ensuring minimal latency and compliance with data residency regulations?

Would appreciate any guidance on architecture, routing strategies, and potential limitations.

Thank you!