How to execute nested queries

[frapontillo]

I have just begun trying out BayesDB but I can't find a way to do nested queries. What I'd like to do is the following:

SELECT * FROM 
    (INFER some_attr, other_attr FROM my_btable WITH CONFIDENCE 0.9) AS t
WHERE t.some_attr = t.other_attr;

Basically, I'd like to simulate a TP/FP Rate test. Is this currently doable?

[jbaxter]

Thanks for the feedback! We are working on adding nested queries right now: they are on the roadmap for the next release. Once implemented, the query you wrote will work as is.

[frapontillo]

Are you also implementing aggregation functions?

[jbaxter]

Yes! In addition to a "SUMMARIZE" command, which gives statistical summaries of each column.

[frapontillo]

Great, thank you!