Skip to Content

Roadmap node.js runtime support associations in SELECT?

Following the discussion in an earlier question here: .

Mind you, this is for SELECT query SQL, not view creation SQL, thanks.

I've been advised by Christoph Wedler to reach out to the runtime experts and ask for the roadmap when path expressions will be supported (node.js). Also of equal interest is when mixins will be supported.

Many thanks, Martin

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 27, 2019 at 11:45 AM

    Hi Martin,

    thanks for you question. We have the support of path expressions in SELECT on our agenda. We will let you know as soon as it is available.

    Regards,

    Anne

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      just to make sure I understand your statement about the missing feature(s) correctly:
      The following example from the official documentation is not working as of now, because the associations are not yet resolved correctly. Is that, what you mean?

      SELECT.from (Books,[
        'ID', 'title', 'author.name as name'
      ]).where ({stock:{'>':11}})

      I stumbled across this issue in other use cases as well and thought about being sqlite-related.

  • Posted on Oct 03, 2019 at 06:43 AM

    OK Thank you Anne. Looking forward to it. I close this in the meantime.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 25, 2019 at 09:10 AM

    Hello Mike. Not exactly. Follow the link to the original post, there is a link to the documentation that mention that select with associations is supported.

    The use case you have found is interesting though, it suggests the same syntax as usually used in full fledged ORMs.

    Thanks for sharing!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.