are join queries supported?

[mysql]

are join queries supported?

[CraigLRussell]

Hi,

No, at the moment joins are not supported. We are looking at extending the object model with relationships and once that part is done we will look at queries over the relationships.

[chirag04]

Hi Craig,

Ya, I see joins are not supported. We are going to use node-mysql for complex queries and mysql-js for simple ones.

You can keep this issue open or closed :)

[CraigLRussell]

Hi Chirag,

We now support joins in queries. The way we do this is to define a Projection that can include both "regular" fields and "relationship" fields. With relationship fields you can compose a document by joining multiple tables (via foreign keys) together.

For examples, see test cases in test/composition directory.