MS SQL does allow for active-active-passive clsters. I'm no expert so hopefully somone here isso you can get a better idea--or Google active active SQL and see what you find.

SEATTLE-- (BUSINESS WIRE)-- PASS Summit 2016 -- ScaleArc, the leading provider of database load balancing software, announced today that the latest release of its ScaleArc for SQL Server software ...