SUPPORT Team,

PLEASE look below list of items:

1. Can you provide new feature to allow sql sub queries and correlated query like we use in oracle ?

1. Allow me to get distinct elements of grow-able array values using SQL query, currently it is not working on array values but on regular value it is working.

2. Can you please provide expression function like add, subtract, multiple, sum, etc.. like we do in oracle db. This will be really helpful while aggregating data, this will simply avoid me to work on pivot tables as additional task every time.

3. Also need mathematical functions like add, minus, on date functions or this will really save my time by subtracting a value from UTC time to covert it to EST on the fly while querying data

4. Please provide a sql function to convert data types from int to string or string to int specially while joining two collection columns ( when those 2 columns are with different data type)

Let me know if you don't understand above requirements.

Hope you implement these ASAP.