Provide support for Azure SQL DB using Hyperscale. Provide the ability to define a pre-connection checkout procedure that can be used to modify the connection string prior to checking out a connection. For Azure SQL DB Hyperscale, it would dynamically switch the context of the Read-Write primary and the Read-Only replicas to achieve better performance. TDV caching and data ship would use ApplicationIntent=ReadWrite and user queries would use ApplicationIntent=ReadOnly in the connection string at the time of connection checkout.
Example connection string: jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=mydb;selectMethod=direct;encrypt=true;trustServerCertificate=true;ApplicationIntent=ReadWrite
or
jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=mydb;selectMethod=direct;encrypt=true;trustServerCertificate=true;ApplicationIntent=ReadOnly