Subqueries and Updates

Do you plan to support subqueries at some point? I've been trying to recreate the below.

select * from accounts where accountid in (select distinct(accountid) from accountholdings where balance > 1000)

I realize this gets very close to being a join, so whatever you plan to support around joining data would be interesting to hear. While 20megs is a lot to play with in terms of our document sizes, we may need to seperate out some of our archived data to avoid hitting this limit and so doing a join would make our lives a lot easier.

Also, will you support updates within JSON documents? For example:

Update account.holderinfo h set h.firstname='baz' where h.lastname = 'foo'

1 Answer

« Back to question.

First on subqueries: yes, we do plan to support these. You are correct that subqueries in the general case are essentially joins. We plan to distinguish in-document subqueries from cross-document subqueries via syntax. This is similar to how we distinguish in-document joins today.

As for document updates, the short answer is yes, but not in the Developer Preview timeframe. We'd be interested in hearing more about your use cases.