Encrypt in Single Store and Decrypt in SQL Server

Question

I have a dataset in Single store. The objective is to encrypt a few columns within Single store, load the data into a SQL Server instance and then decrypt it there using an encryption key.

1. I tried using the AES_ENCRYPT function in single store. I encrypted a sample data with a specific key using the aes-128-ecb algorithm.
2. While loading and testing decryption in SQL server using DECRYPTBYKEY, I found that even though SQL server supports AES-128 encryption, it doesn't support encryption with different modes such as ECB, GCM or CBC which single store utilizes.

Looks like DECRYPTBYKEY on SQL Server can only decrypt the data encrypted by ENCRYPTBYKEY.

What other alternatives do I have?