Always Encrypted - get it working about go-mssqldb HOT 5 CLOSED

@shueybubbles Is it possible to raise some attention on this? Always Encrypted is in a bad place right now with language support outside of the C#/.NET/Java ecosystems. *Open source SQL drivers have MSSQL as an afterthought, and ODBC C++ wrappers have very mixed support (such as in the case of this situation).

I'm trying really hard to use Azure SQL for its Always Encrypted with Secure enclaves capabilities in a solution I'm building, but it is getting harder and harder to justify.

from go-mssqldb.

Did you have any success getting this to work @lokmannicholas ?

from go-mssqldb.

Does this driver even claim support for AE? It looks like this PR never got in:
denisenkom#637

from go-mssqldb.

Did you have any success getting this to work @lokmannicholas ?

it doesn't work, i am finding someone to make it work together @@

from go-mssqldb.

We are building a multi-phase plan for AE. Each phase corresponds to a complete set of functionality that can be released.
Phase 1 -
a. Define the connection string (including enclave settings)
b. Define a key provider interface, including how to pass along authentication parameters
c. Implement the AKV key provider
d. Configurable CEK cache
e. E2E testing of decrypting using AKV. This part will likely be done internally since it requires a real Azure sub.
Phase 2 -
a. Support for encryption of parameters in parameterized queries
b. Add a local certificate key provider
c. Enclaves
Phase 3 -
a. Performance tuning

from go-mssqldb.